Information Technology Analyst IV (Cloud Data Engineer)

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, Applications must be submitted through the NEOGOV system. Paper copies of applications are not accepted. All additional application materials as requested in the job announcement (degree/transcripts, certificates, DD-214 if applicable, ADA Accommodation Request) must be submitted by the final filing date. Previously submitted application materials (i.e. copies of diploma and/or transcripts, etc.) for prior recruitments will not be applied for this recruitment but must be re-submitted for this recruitment.

Any further questions can be directed to the Department of Human Resources at (707) 784-6170, business hours are Monday-Friday, 8:00 a.m.-5:00 p.m. EOE/AA

Please note that all dates/times listed in the job announcement are Pacific Time. A Bachelor’s degree is required for this position. All candidates are strongly encouraged to submit a copy of their college diploma (verifying the degree, date earned and area of specialization) or official/unofficial transcripts (verifying institution, student, date, degree and area of specialization conferred) by the final filing deadline. Candidates who fail to submit their diploma or transcripts by the final filing date may be disqualified from the recruitment. PLEASE NOTE THE FOLLOWING: Candidates who attended a college or university that is accredited by a foreign or non-U.S. accrediting agency must have their educational units evaluated by an educational evaluation service. The result must be submitted to the Human Resources Department no later than the close of the recruitment. Please contact the local college or university to learn where this service can be obtained.

The ideal candidate will demonstrate 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. They should be 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 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., Education: Equivalent to an Associate’s degree, preferably in information technology, or a closely related field.

Experience: Depending upon assignment: Five (5) years of experience performing progressively responsible software development, or infrastructure management duties and functions.

Note: 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.

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

LICENSING, CERTIFICATION AND REGISTRATION REQUIREMENTS:

• Applicants may be required to possess a valid California Driver’s License, Class C.

Note: All licenses, certificates and registrations must be kept current while employed in this class., To be eligible, applicant must have served at least 181 consecutive days of active duty in the Armed Forces of the United States and have received either an honorable discharge or a general discharge under honorable conditions. A COPY OF THE DD 214, SHOWING DISCHARGE TYPE (GENERALLY COPY 4), MUST BE RECEIVED IN THE HUMAN RESOURCES DEPARTMENT BY THE FINAL FILING DATE (or APPLICATION REVIEW DEADLINE).

Applicants who have a service connected disability must also submit a recent award letter from the VA stating they are receiving disability benefits for service connected reasons.

Veteran applicants for initial County employment with an honorable or general under conditions discharge shall receive five (5) points added to their combined score. Disabled veterans rated at not less than 30% disability shall have ten (10) points added to their combined score. Veteran’s preference points will only be added to passing scores in competitive open examinations.

Americans with Disabilities Act

It is the policy of Solano County that all employment decisions and personnel policies will be applied equally to all County employees and applicants and be based upon the needs of County service, job related merit, and ability to perform the job.

APPLICANTS WITH DISABILITIES: Qualified individuals with a disability, who are able to perform the essential functions of the job, with or without reasonable accommodation, and need an accommodation during any phase of the recruitment/testing/examination process (as detailed in the “Selection Process”) in the Human Resources Department by the application review deadline. Applicants will be contacted to discuss the specifics of the request.

Pulled from the full job description

• Health insurance
• Vision insurance
• Dental insurance
• Flexible spending account
• Life insurance
• Pension plan