Save Job
Posted 1w ago

Information Technology Analyst IV (Cloud Data Engineer)

@ Solano County
Fairfield, California, United States
$130k-$158k/yrHybridFull Time
Responsibilities:leading projects, designing systems, developing ETL
Requirements Summary:Advanced data engineering and warehousing experience with Azure Data Lake, Synapse, ETL (SSIS/ADF), SQL, Python/R, Power BI; Bachelor's required; 5+ years progressive software development or infrastructure experience.
Technical Tools Mentioned:Azure Data Lake, Azure Synapse, SSIS, Azure Data Factory, SQL, Python, R, Power BI, DevOps, Purview, Dynamics CRM, Informatica, Redshift, Snowflake, Avatar, NextGen, Epic, SAS, Tableau, Qlik, Crystal Reports
Save
Mark Applied
Hide Job
Report & Hide
Job Description

About the Department

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

Click here to learn more about the Department of Information Technology


IDEAL CANDIDATE

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.


THE POSITION

Information Technology Analyst IV

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.


Click here for Information Technology Analyst IV (Cloud Data Engineer) Job Description

Minimum Qualifications

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.

Other Qualifications

7/17/2026 – 5:00pm Deadline to submit application and required documents for first application review.

8/21/2026 – 5:00pm Deadline to submit application and required documents for next application review. 


SELECTION PROCESS
Based on the information provided in the application documents, the qualified applicants may be invited for further examination and will either be pre-scheduled by the Department of Human Resources or be invited to self-schedule. All applicants meeting the minimum qualifications are not guaranteed advancement through any subsequent phase of the examination. Depending upon the number of applications received, the selection process may consist of an initial application screening, a mandatory information meeting, a 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 used to assess an applicant’s ability to advance in the process; as such, responses to supplemental questions should 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 selection 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 contingent job offer is accepted. These provisions are subject to change.

RETIREES - Solano County invites all qualified candidates to apply for positions; however pursuant to Government Code Section 21221(h) and 21224, 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 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.

 

How to Submit Your Documents  
In addition to uploading attachments when applying online, candidates may submit documents by fax to (707) 784-3424, or by email to [email protected].  Be sure to include the recruitment title and the recruitment number in your email or fax.  


Veteran’s Preference Points
 
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.

Benefits



We offer a benefits package to employees which includes health care, dental, vision, retirement, deferred compensation plans, flexible spending accounts, life insurance, holidays, vacation, and sick leave

To learn more, view our benefits summary.


Supplemental Questions







01
Which statement below best describes the highest level of education you have completed?

  • High school graduate, diploma or the equivalent (GED)
  • Associate degree
  • Bachelor's degree
  • Master's degree
  • Professional degree
  • Doctorate degree



02
If qualifying by education, I understand I must submit proof of education (copy of degree, transcripts, etc.) to meet the education requirements of this position.

  • Yes
  • No



03
How many years of performing progressively responsible software development or infrastructure management duties and functions do you have?

  • No experience
  • 1-2 years
  • 3-5 years
  • 6+ years



04
How many years of experience do you have working with cloud platforms (Azure, AWS, etc.)?

  • No experience
  • 1-2 years
  • 3-5 years
  • 6+ years



05
How many years of experience do you have working with data platform management systems (Microsoft,
Informatica, Redshift, Snowflake)?


  • No experience
  • 1-2 years
  • 3-5 years
  • 6+ years



06
How many years of experience do you have working with Electronic Health Record Systems (Avatar, NextGen,
Epic)?


  • No Experience
  • 1-2 years
  • 3-5 years
  • 6+ years



07
How many years of experience do you have working with Statistical/Data analytics tools (R, Python, SAS)?

  • No experience
  • 1-2 years
  • 3-5 years
  • 6+ years



08
How many years of experience do you have working with advanced Report and BI Development (Power BI,
SQL, Crystal Reports, Tableau, Qlik)?


  • No experience
  • 1-2 years
  • 3-5 years
  • 6+ years



09
How many years of experience do you have with IT Project Management?

  • No experience
  • 1-2 years
  • 3-5 years
  • 6+ years



10
How many years of experience do you have with Data Governance?

  • No experience
  • 1-2 years
  • 3-5 years
  • 6+ years



11
How many years of experience do you have with Data Warehousing?

  • No experience
  • 1-2 years
  • 3-5 years
  • 6+ years



12
How many years of experience do you have with Reference and Master Data?

  • No experience
  • 1-2 years
  • 3-5 years
  • 6+ years



13
How many years of experience do you have with Data Quality?

  • No experience
  • 1-2 years
  • 3-5 years
  • 6+ years



14
How many years of experience do you have with Data Security?

  • No experience
  • 1-2 years
  • 3-5 years
  • 6+ years



15
Please indicate which of the following certifications you have achieved (select all that apply):

  • Azure Fundamentals
  • Azure Data Fundamentals
  • Azure AI Fundamentals
  • Power BI Data Analyst
  • Azure Data Scientist
  • Azure Solution Architect
  • Azure Data Engineer
  • DAMA certification (CDMP)
  • I don't have any of the above certifications



16
Describe a project where you collaborated with diverse stakeholders to design and implement a complex data integration solution. How did you identify and address challenges, and what was the outcome?




    17
    Share an example of how you applied your expertise in modern data engineering tools (e.g., Azure Data factory, Synapse, DevOps, or Power BI) to create a scalable, innovative solution that enhanced data analytics or reporting capabilities. What impact did your solution have on the organization?




      Required Question



      Agency Information

      Employer
      Solano County
      Address

      675 Texas Street

      Suite 1800






      Fairfield, California, 94533
      Phone
      (707) 784-6170
      Website

      https://www.solanocounty.gov/