The Office of Data and Innovation (ODI) — part of the state’s central data team, known as CalData — is seeking a data services and platform lead (IT manager II).
The lead will be part of a team of data and analytics engineering professionals supporting ODI, developing shared platforms, services and standards for ODI usage. “These platforms, services, and standards support advanced analytics, open data, and user research for clients,” the job posting says. “They also help develop data pipelines to support project work. The team will be the go-to consultants on building a modern data stack for other state teams and will share approaches and lessons with the broader state community.”
The posting and the duty statement continue: “You will be responsible for establishing the blueprint of ODI’s modern data stack. You will bring a user orientation to your work. Working with ODI staff across teams, you will define the architecture based on real need. You will help identify and vet tools that meet the architectural blueprint. You will 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.”
Desirable qualifications include:
- Experience translating business needs into technical implementations, including mapping out business processes and data models.
- Experience architecting cloud data platforms to support analytics; estimating and projecting costs of cloud data platforms; data manipulation and analytical thinking; implementing CI/CD for analytics workflows; and experience in implementing modern cloud data warehouse (i.e., Snowflake, Redshift, BigQuery, etc.), data orchestrators (i.e., Airflow) and loaders (i.e., Fivetran, Stitch, Hevo, etc.).
Bonus qualifications, according to the posting, include:
- 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, especially creating and deploying through a framework.
- Experience training non-technical users to use technology to support their work.
- Programming proficiency in SQL, experience with DBT or comparable technology, and experience with Python, Scala.
- Experience working with a variety of databases, APIs, and formats to extract and transform data.
The position has a monthly salary range of $10,421 to $12,668, and the application deadline is Oct. 10.
The California Department of Education is seeking a State Special Schools IT administrator (IT manager I) to oversee the IT environment, security and customer service desk at the State Special Schools and Diagnostic Centers.
The administrator has oversight of three key areas, according to the job posting and duty statement: Operational Management and Technical Leadership, IT standardization and project leadership. Desirable qualifications for this position include:
- Two-plus years’ working experience supervising employees in an IT support environment.
- Five-plus years’ working experience as a technical specialist implementing and supporting (a) computer networks, (b) various operating systems and application software, and (c) storage, server and desktop computing hardware.
- Experience supporting IT in a K-12 school environment.
- Experience managing multiple high-priority initiatives in a fast-paced, highly technical environment, solving problems and making decisions on a daily basis relative to IT service desk responsibilities.
The position has a monthly salary range of $8,591 to $11,512, and the application deadline is Oct. 4.
Candidates for the position of principal data architect (IT manager II) are being sought by the Office of Cradle-to-Career Data, “a statewide data system that will provide tools to help students reach their goals and deliver information on education and workforce outcomes.
“Under the administrative direction of the director of Data Infrastructure, the principal data architect is responsible for helping to build and protect the analytical data system that will power our public-facing dashboards, query tools, and research requests for C2C,” the job posting says. “The principal data architect will work closely with the director of Data Infrastructure to manage the data infrastructure staff and contractors and work closely with the data and research services team, information security professionals, and data providers to ensure the data system meets user needs.”
Desirable qualifications include:
- Bachelor’s and master’s degrees in IT, social science, data analysis, economics, public policy, education policy, or a related field.
- Experience at the senior leadership level of planning and managing strategic projects.
- Experience designing, developing, deploying, securing and maintaining infrastructure of cloud-based data systems.
More details about the position and the responsibilities can be found in the duty statement. The monthly salary range is $10,421 to $12,668, and the application deadline is Oct. 10.
The California Department of Transportation (Caltrans) is seeking a senior Oracle data warehouse specialist (IT specialist II).
“If you want to be a part of a new office committed to successfully establishing and maintaining an enterprise data warehouse and departmentwide business intelligence program, then this is the position for you,” the job posting says. “The incumbent’s primary focus is on the standards, processes, procedures for the analysis, design, implementation, maintenance and operations of data warehousing. …
“The incumbent’s secondary focus is business intelligence, data analysis and reporting. The incumbent performs highly complex activities of the System Development Life Cycle, which includes systems: analysis, design, build, test, maintenance and operations. The incumbent provides training to staff in the configuration and use of data warehouse and business intelligence technologies. The incumbent also performs functions including, but not limited to, researching, writing, reporting, presenting, etc.”
Additional details about the role are available in the duty statement. The position has a monthly salary range of $7,893 to $10,576, and the recruitment will continue until the role is filled.