Information Technology Analyst IV (Cloud Data Engineer)

Solano County Department of Information Technology seeks an Information Technology Analyst IV, Cloud Data Engineer, to lead the design and upkeep of major data systems, deliver advanced technical support to users, and guide cross-functional teams across software development, networks and systems, service desk, security, and database platforms. This onsite role is based in Fairfield, California.

Responsibilities

• Act 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 Information Technology Analysts, and/or consultants on system design or infrastructure and maintenance projects.

Requirements

• Bachelor's degree required.
• Demonstrated expertise in modern data warehouse technologies, including Azure Data Lake, Azure Synapse, Kimball data modeling with facts and dimensions, and data engineering practices such as Medallion Architecture.
• Strong ETL development skills using SSIS and Azure Data Factory.
• Proficiency in SQL, Python, and R.
• Significant 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
• Kimball data modeling
• Data warehouse technologies

The Position

This role is the fourth classification tier within the Information Technology Analyst series. Individuals in this grade apply highly specialized technical analysis skills while serving as team leader or project manager for major systems. They perform the most demanding duties, including providing advanced technical support to system users, and they lead aspects of software development, network and systems administration, service desk, security and database efforts, or consultants on assigned designs or infrastructure projects.

Ideal Candidate

The ideal candidate possesses advanced knowledge of modern data warehousing technologies such as Azure Data Lake and Azure Synapse, along with Kimball data modeling of facts and dimensions and Medallion Architecture. They are adept at ETL development with SSIS and Azure Data Factory, and skilled 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 materials, either pre-scheduled or self-scheduled.
• A minimum score of 70% is required to proceed, unless otherwise announced.
• The process may include initial application screening, information meeting, supplemental questionnaire assessment, written and/or practical exams, oral board interviews, or combinations thereof.
• Responses to supplemental questions may be used as screening and testing tools; treat them as part of the evaluation.
• All applicants meeting minimum qualifications are not guaranteed advancement.
• Background and reference checks will be conducted after a contingent job offer, with provisions subject to change.
• Retirees may be subject to hiring restrictions under applicable law.

How to Apply

Applications must be submitted through the NEOGOV system. Paper copies are not accepted. All requested supporting materials, such as transcripts, certificates, or DD-214 if applicable, must be provided by the final filing date. Previously submitted materials for prior recruitments must be re-submitted for this recruitment.

How to Submit Your Documents

In addition to uploading attachments online, you may submit documents by fax to (707) 784-3424 or by email to [email protected]. Include the recruitment title and recruitment number in your email or fax.

Veteran’s Preference Points

Eligible applicants must have served at least 181 consecutive days of active duty in the U.S. Armed Forces and received an honorable discharge or general discharge under honorable conditions. A copy of the DD 214 showing discharge type must be received by the final filing date. Veterans with a service-connected disability must submit a recent VA award letter. Veteran preference points add to the final score in competitive open examinations, with higher points for disabled veterans as defined by policy.