Solano County DoIT offers an onsite Cloud Data Engineer role in Fairfield, CA with a competitive hourly range of $62 to $75. This senior level position focuses on designing and maintaining major data systems, delivering advanced user support, and leading cross functional teams across software development, networks and systems, service desk, security, and database platforms. It presents a pathway to influence how data is Architected and used across county IT services.
Benefits and opportunities
Onsite opportunity in Fairfield, California with a competitive hourly rate. The role enables leadership of key data system initiatives and collaboration across IT disciplines to advance data engineering practices and data warehouse technologies.
Responsibilities
- Serve as team lead and project manager for designated major systems.
- Provide advanced technical support to system users.
- Provide lead direction to software development, network and systems administration, service desk, security and database teams, other IT Analysts, and/or consultants on system design and infrastructure projects.
Requirements
- Bachelor's degree required.
- Ideal candidates will demonstrate advanced knowledge in modern data warehouse technologies, including Azure Data Lake, Azure Synapse, Kimball data modeling, facts and dimensions design, and data engineering practices such as Medallion Architecture.
- Skilled in ETL development using SSIS and Azure Data Factory.
- Proficient in SQL, Python, and R.
- Strong experience with Power BI, DevOps, Purview, and Dynamics CRM is highly desirable.
- Preferred certifications include Azure Data Fundamentals, Azure AI Associate, Azure Data Engineer or Azure Solution Architect, DAMA CDMP, and Power BI Data Analyst.
Technologies
- Azure Data Lake
- Azure Synapse
- SSIS
- Azure Data Factory
- SQL
- Python
- R
- Power BI
- DevOps
- Purview
- Dynamics CRM
- Medallion Architecture
-
- Data warehouse technologies
The position
This role is the fourth classification level within the Information Technology Analyst job series. Incumbents apply advanced specialized and technical analytical skills while serving as team leader or project manager for designated major systems. They perform the most difficult duties, including providing advanced technical support to system users, and provide lead direction to software development, network and systems administration, service desk, or security and database teams, or consultants on assigned systems design or infrastructure and maintenance projects.
Ideal candidate
- Demonstrates advanced knowledge in modern data warehouse technologies, including Azure Data Lake, Azure Synapse, Kimball data modeling, facts and dimensions design, and data engineering practices such as Medallion Architecture.
- Skilled in ETL development using SSIS and Azure Data Factory.
- Proficient in SQL, Python, and R.
- Strong experience with Power BI, DevOps, Purview, and Dynamics CRM is highly desirable.
- Preferred certifications include Azure Data Fundamentals, Azure AI Associate, Azure Data Engineer or Azure Solution Architect, DAMA CDMP, and Power BI Data Analyst.
Selection process
- Qualified applicants may be invited for further examination based on application information, scheduled by the Department of Human Resources or via self-scheduling.
- Meeting minimum qualifications does not guarantee advancement to subsequent phases.
- The process may include initial application screening, information meeting, supplemental questionnaire assessment, written or practical exams, an oral board, or any combination thereof.
- Responses to supplemental questions may be used for screening and testing; treat them as examination responses.
- Information does not constitute a contract.
- A minimum score of 70% is required to continue in the process unless announced otherwise.
- New hires and certain promotions are subject to background and reference checks after a contingent offer is accepted; these provisions may change.
- Retirees may be subject to hiring restrictions under Government Code sections 21221(h) and 21224.
How to apply
Applications must be submitted through the NEOGOV system. Paper applications are not accepted. All requested materials, such as transcripts, certificates, DD-214 if applicable, and ADA Accommodation Requests, must be submitted by the final filing date. Materials submitted for prior recruitments will not be applied to this recruitment and must be re-submitted.
How to submit your documents
In addition to online uploads, you may submit documents by fax to 707-784-3424 or by email to recruitment@solanocounty.com. Please include the recruitment title and recruitment number in your submission.
Veterans preference points
Applicants with eligible military service may qualify for veteran preference. To receive points, a DD 214 showing discharge type must be submitted to the Human Resources Department by the final filing date. Service-connected disability applicants may also submit a VA award letter. Eligible veterans receive five preference points; disabled veterans with at least 30 percent disability receive ten points. Preference points apply to passing scores in competitive open examinations.
