Information Technology Analyst IV (Cloud Data Engineer)

Solano County DoIT seeks a Senior Information Technology Analyst IV (Cloud Data Engineer) to lead design and maintenance of major data systems onsite in Fairfield, CA, with a salary of USD 62 - 75 per hour.

Responsibilities

• Act as the team lead and project manager for designated major systems.
• Provide advanced technical support to system users.
• Offer strategic direction to software development, network and systems administration, service desk, security, and database teams, as well as consultants, on system design and infrastructure projects.

Requirements

• Bachelor's degree is required.
• Demonstrated advanced expertise in modern data warehousing technologies including Azure Data Lake, Azure Synapse, Kimball data modeling, facts and dimensions design, and Medallion Architecture for data engineering.
• Strong ETL development experience with SSIS and Azure Data Factory.
• Proficient 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 is the fourth classification level in the Information Technology Analyst job series.
• Incumbents apply advanced specialized and technical analytical skills and act as team leader/project manager for designated major systems.
• They perform the most difficult duties, including providing advanced technical support to system users.
• They provide lead direction to software development, network/systems administration, service desk, or security and database systems, other Information Technology Analysts, and/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 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

• Based on application documents, qualified applicants may be invited for further examination and will be pre-scheduled by the Department of Human Resources or invited to self-schedule.
• All applicants meeting the minimum qualifications are not guaranteed advancement through any subsequent phase of the examination.
• Depending on the number of applications, the process may include an initial application screening, mandatory information meeting, supplemental questionnaire assessment, a written and/or practical exam, an oral board exam, or any combination listed.
• Responses to supplemental questions may be used as screening and testing mechanisms and will be treated as test examination responses.
• Information contained herein does not constitute either an expressed or implied contract.
• A minimum score of 70% is required to continue in the process, unless otherwise announced.
• All potential new hires and employees considered for promotion to management, confidential positions or unrepresented positions will be subject to a background and reference check after a contingent job offer is accepted. Provisions are subject to change.
• RETIREES - Hiring restrictions may apply to California Public Sector Pension Plan Retirees.

How to Apply

• Applications must be submitted through the NEOGOV system. Paper copies of applications are not accepted. All requested materials (degree/transcripts, certificates, DD-214 if applicable, ADA Accommodation Request) must be submitted by the final filing date.
• Previously submitted application materials for prior recruitments will not be applied for this recruitment but 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 submission.

Veteran’s Preference Points

• To be eligible, applicants must have served at least 181 consecutive days of active duty in the Armed Forces and have received an honorable discharge or a general discharge under honorable conditions; a copy of DD 214 (copy 4) must be received by the final filing date.
• Service connected disability applicants must submit a recent VA award letter stating disability benefits.
• Veteran preference points: five points for honorable/general discharge; ten points for 30 percent or more service-connected disability. Points apply to passing scores in competitive open examinations.