We are seeking a Lead Platform Engineer for Data to join the Data Services and Engineering team at ODI, a team filled with bright and empathetic data people. ODI works across all departments in the state, with data that touches all Californians. You will find that the problems and challenges we engage with require the heart as much as the mind.
Location: This position provides telework opportunities in accordance with agency telework policies. ODI is currently operating in a hybrid work environment with staff reporting to the office 2 days a week to either Sacramento HQ or our Oakland Hub.
Annual salary: $128,808 – $156,576 based on experience and qualifications
Benefits: The state offers many benefits, including pension, health benefits (including after retirement), life insurance, employee assistance program, and much more.
Last day to apply: Final filing date is July 1, 2024.
What you’ll do
- Be responsible for establishing the blueprint of ODI’s modern data stack.
- Bring a user orientation to your work.
- Complement the Data Services and Engineering team skillsets with your depth of experience in architecting data platforms in the cloud, developing infrastructure as code, and setting up effective CI/CD workflows for analytics.
- Help identify and vet tools that meet the architectural blueprint.
- Adopt a platform mindset avoiding bespoke solutions in favor of cloud-first, sustainable, and scalable solutions that address common needs across many projects and clients.
You will find additional information about the job in the Duty Statement.
We have a guide to the civil service application process. It covers:
- How to apply
- Civil service exams
- Interviews
Desirable qualifications
We encourage you to apply regardless of whether you think you meet 100% of these skills below.
- Technical/Knowledge Skills
- Experience translating business needs into technical implementations, including mapping out business processes and data models
- Experience architecting cloud data platforms to support analytics
- Experience estimating and projecting costs of cloud data platforms
- Experience in data manipulation and analytical thinking
- Experience implementing CI/CD for analytics workflows
- Experience with infrastructure as code (Terraform, CloudFormation, or similar)
- Experience implementing a modern cloud data warehouse (e.g. Snowflake, Redshift, BigQuery, etc)
- Experience implementing data orchestrators (ie Airflow) and loaders (e.g. Fivetran, Stitch, Hevo, etc)
- Personal Skills
- Enjoys collaborative processes and developing shared understanding
- Ability to communicate with technical and non-technical audiences
- Investigative ability and intellectual curiosity
- Excellent oral and written communication skills
- Ability to learn and embrace new technologies
- Demonstrated ability working with diverse groups of stakeholders
- Comfort with risk and trying new things
- Ability to work independently and as part of a small team
- Commitment to equity and the use of data to meet the needs of all Californians
- Bonus qualifications
- Experience moving data from legacy on-premises sources to cloud based
- Familiarity with Microsoft’s Azure Cloud Tools and/or PowerBI
- Experience writing and maintaining ETL/ELT code
- Experience training non-technical users to use technology to support their work
- Programming proficiency in SQL
- Experience with dbt or comparable technology
- Experience with Python, Scala, or other data-oriented programming language
- Experience working with a variety of databases, APIs, and file formats to extract and transform data
About ODI
We deliver better services to Californians through technology and design. We do so through close partnership with other state departments. Our goal is to create programs and products that are more equitable and effective. We listen to Californians who use a program now or may do so tomorrow and learn about what they need.
We:
- Build tools and products
- Create and enhance digital services
- Conduct research
- Identify data solutions
- Offer training
We are a cross-discipline staff with blended backgrounds in:
- Design
- Engineering
- Product
- Operations
- Data
- Research
- Policy
- Strategy
Learn more about ODI’s vision and mission.
Diversity, equity, and inclusion at ODI
Diversity, equity, and inclusion help us deliver better government services to Californians.
- Fostering diversity inspires better ideas and more innovative thinking.
- Feeling included nurtures a shared sense of community. This drives us to take collective action on challenging problems.
- Prioritizing equity ensures we build solutions for people whose needs are often overlooked.
We acknowledge our history and present of implicit and structural injustice, bias, and discrimination. We see, hear, and accept each other and the lived experiences we bring to our work. We support each other in learning and developing so we can help all Californians thrive.
We understand this work is never done. That’s why we commit to constant improvement.