Information Technology Analyst IV (Cloud Data Engineer)

About the role

The Solano County Department of Information Technology (DoIT) provides customer-oriented and convenient access to information and services through the use of technology. The department strives for cost-effective use of technology, facilitating interactive exchange and sharing of data within departments, with constituents, and with other governments and business partners.

Responsibilities

• Perform the most difficult and responsible duties including providing advanced technical support to system users.
• 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.

Requirements

• Education: Equivalent to an Associate’s degree, preferably in information technology, or a closely related field.
• Experience: Five (5) years of experience performing progressively responsible software development, or infrastructure management duties and functions.

Qualifications

• Advanced knowledge in modern data warehouse technologies, Azure Data Lake, Azure Synapse, Kimball data modeling, facts and dimensions design, and data engineering practices including Medallion Architecture.
• Skilled in ETL development using SSIS and Azure Data Factory, and proficient in SQL, Python, and R.
• Strong experience with Power BI, DevOps, Purview, and Dynamics CRM.

Skills

• Azure Data Fundamentals
• Azure AI Associate
• Azure Data Engineer or Azure Solution Architect
• DAMA CDMP
• Power BI Data Analyst

Benefits

Not specified.

Pay

Not specified.

Schedule

Not specified.

Additional Information

Note: Additional experience may substitute on a year for year basis for the educational requirement.