Information Technology Analyst IV (Cloud Data Engineer)

Solano County • Fairfield, CA

2d

About The Position

Solano County Department of Information Technology (DoIT) provides customer-oriented and convenient access to information and services through the use of technology; anytime - anywhere. The County strives for cost-effective use of technology, with interactive exchange and sharing of data within departments, with constituents, with other governments and business partners. The guiding principles of DoIT are: Support and facilitate access to County information for the public and its employees and to help the County conduct its business in a fast and easy manner Support the business goals of the County in an efficient, cost-effective manner Provide safe and secure systems and an integration mechanism to streamline business practices Provide ongoing technology training for staff Provide opportunities for constituents to utilize technology in their interaction with the County Share and exchange information using multiple channels. This is the fourth classification level within the Information Technology Analyst job series. Incumbents in this job class possess and apply advanced levels of specialized and technical analytical skills and knowledge while serving as team leader/project manager for designated major systems. Incumbents in this job class perform the most difficult and responsible duties including providing advanced technical support to system users. Incumbents in this job class 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. The eligible list created as a result of this recruitment will be used to fill full-time and part-time regular, limited-term or extra-help positions as vacancies occur throughout the County.

Requirements

• Equivalent to an Associate’s degree, preferably in information technology, or a closely related field.
• Five (5) years of experience performing progressively responsible software development, or infrastructure management duties and functions.
• A Bachelor’s degree from an accredited college or university, preferably in information technology, management information systems may be substituted for two years of experience.
• Additional experience may substitute on a year for year basis for the educational requirement.
• Applicants may be required to possess a valid California Driver’s License, Class C.
• All licenses, certificates and registrations must be kept current while employed in this class.

Nice To Haves

• 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.
• 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.

Responsibilities

• Serve as team leader/project manager for designated major systems.
• Perform the most difficult and responsible duties including providing advanced technical support to system users.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree