HR Home Salary Listing Class Descriptions Employee Benefits FAQ

Information Technology Analyst IV (Data Engineer)

Recruitment #23-364060-02

Go Back View Benefits

Introduction

Enjoy great benefits, job security and contribute to your community at Solano County!

Information Technology | GlobalTech Recruitment


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

Find out more about the Department of Information Technology by clicking on the following link: Department of Information Technology

THE POSITION

(Data Engineer) 

As an Information Technology Analyst IV (Data Engineer) you will apply advanced levels of specialized and technical analytical skills and knowledge while serving as team leader/project manager for designated major systems. You will perform the most difficult tasks within the Information Technology Analyst series including providing advanced technical support to system users. You will 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. Supervision from our Information Technology Analyst (Principal) as well as our Information Technology Manager. You may also receive functional direction from the Assistant Director and/or Chief Information Officer. 

Our current Opportunity is within our Data Management Team!
As an Information Technology Analyst IV (Data Engineer), you will be a prominent member of our Data Management team supporting the Central IT department of the County of Solano, two (2) data centers, eighteen (18) departments with over 3,000 employees across multiple industries, ultimately providing service to over 447,643 constituents.

As a member of our Data Management Team, you will primarily support our Health and Social Services Department which includes Public Health, Social and Behavioral Health Services and has the highest demand for data use and reporting requirements. You will profile and use data sources to build a data model to generate clean and accurate data for report writers and data users across the County. You will also work with data users to identify and anticipate reporting and data needs, extract data from the source systems, profile and load it into a model, and generate reports and analytics.


Education and Experience Requirements 

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.

Please click on the following link to access the job description: 


The Ideal Candidate 

The ideal candidate is an excellent communicator; they are collaborative, motivating, entrepreneurial, and comfortable working autonomously. They will form meaningful partnerships within the department and with stakeholders throughout the County. Our ideal candidate embraces change and looks for opportunities for improvement. They enjoy examining data, visualizing, and creating a story, and can project practical applications for the data in multiple scenarios. 

Desired Knowledge and Experience
Data warehouse experience including data sourcing, analyzing, and modeling
Azure Synapse
Power BI
Data Factory
DevOps
Purview
D365
Kimball, Snowflake
Informatica, Talend
Python, R, SAS

Desired Certifications
Data Scientist
Azure Solution Architect
Azure Data Engineer
DAMA certified (CDMP)

BENEFITS/ WHAT'S IN IT FOR YOU?



Solano County offers a cafeteria-style medical package with health benefits, offered through CalPERS. The County contribution for family coverage is $1,900.58 per month for 2023. The County offers a cash back provision for those who choose employee-only or who waive medical insurance coverage.  The County may offer a supplemental contribution for employees enrolled in Employee plus Two or More coverage.

Dental and vision insurances for the employee and eligible dependents are paid 100% by the County.

Solano County participates in CalPERS retirement and contributes to Social Security. 
The County observes twelve (12) full day fixed and two (2) half day fixed paid holidays per year. Additionally, employees in this bargaining unit receive two (2) floating paid holiday(s) per year.  Vacation is accrued at approximately ten (10) days per year. Sick leave accrues at approximately 12 days per year. Effective July 1 of each year, 80 hours of administrative leave is granted.

Employees are eligible to receive an additional 2.5% longevity pay, per level, after the completion of continuous service at 10, 20, 25, 30 and 35 years. 

Please click on the following link to access the benefits summary: 


Learning and Development Culture

Solano County is committed to “Invest In and For the Future” by providing training resources to encourage employee professional development and growth within our organization. While employed with Solano County, employees have the opportunity to pursue their career goals, interests, and develop the competencies on the Solano County Leadership Development Model by participating in the following programs: 

  • Tuition Reimbursement Program 
  • Annual Education Fair 
  • County Mentoring Program 
  • Leadership Academy 
  • Supervisory Trainings 
  • Skill Development Trainings 
  • Self-paced learning opportunities

SELECTION PROCESS

04/05/2023 - Deadline to submit application along with educational documents. Applications will be reviewed every 3 weeks thereafter. 

05/01-05/05 - Tentative dates for hiring interviews 

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

Please click on "Apply Online" at the bottom of this posting.

Applications must be submitted through the JobAps 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 fax to (707) 784-3424, or by email to recruitment@solanocounty.com and are due by the application review date. Be sure to include the recruitment title (Information Technology Analyst IV) and the recruitment number (23-364060-02) in your email or fax. 

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.

DOCUMENT SUBMITTAL REQUIREMENTS

EDUCATION DOCUMENTS MAY BE REQUIRED

All candidates qualifying for the position under the education requirement must submit a copy of their official/unofficial transcripts (verifying the courses and units completed) or degree (verifying date, degree and area of specialization conferred) by the application submittal deadline.  Candidates who fail to submit their transcripts by the application submittal deadline will 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 recruitment@solanocounty.com.  Be sure to include the recruitment title (Information Technology Analyst IV) and the recruitment number (23-364060-02) in your email or fax. 

SUPPLEMENTAL QUESTIONNAIRE

The Supplemental Questionnaire will be used to determine applicants’ qualifications for this position and assess an applicant’s ability to advance in the recruitment process; therefore, applicants are encouraged to answer all questions thoroughly and completely.  Omitted information will not be considered or assumed.  Applicants who have no experience in a specific area are recommended to state "no experience in this area" instead of leaving the space blank.
 
Please note that the experience in your answers must be reflected in your employment history.
1.

How many years of full-time experience do you have performing progressively responsible software development or infrastructure management duties and functions? 
 No experience
 Less than 1 year
 2 to 3 years
 4 to 5 years
 6+ years
2.

What is the highest level of education you have completed? 
 High School Diploma
 Associate's Degree
 Bachelor's Degree
 Master's Degree
3.

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

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

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

How many years of experience do you have working with Content Management Systems (Hyland, Documentum)? 
 No experience
 1-2 years
 3-5 years
 6+ years
7.

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

How many years of experience do you have working with CRM Systems (Dynamics365, Saleforce)? 
 No experience
 1-2 years
 3-5 years
 6+ years
9.

How many years of experience do you have working with Report and BI Development (Power BI, SQL, Crystal Reports, Tableau)? 
 No experience
 1-2 years
 3-5 years
 6+ years
10.

How many years of experience do you have with IT Project Management? 
 No experience
 1-2 years
 3-5 years
 6+ years
11.

How many years of experience do you have with Data Governance? 
 No experience
 1-2 years
 3-5 years
 6+ years
12.

How many years of experience do you have with Data Warehousing? 
 No experience
 1-2 years
 3-5 years
 6+ years
13.

How many years of experience do you have with Reference and Master Data? 
 No experience
 1-2 years
 3-5 years
 6+ years
14.

How many years of experience do you have with Metadata? 
 No experience
 1-2 years
 3-5 years
 6+ years
15.

How many years of experience do you have with Data Quality? 
 No experience
 1-2 years
 3-5 years
 6+ years
16.

How many years of experience do you have with Data Security? 
 No experience
 1-2 years
 3-5 years
 6+ years
17.

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
Data Scientist
Azure Data Engineer
Azure Solution Architect
DAMA certification (CDMP)
18.

Will you be submitting proof of education? If so, how will you be submitting proof of education (transcripts, copy of degree, etc.)? 
 Attached to this application
 Via email at recruitment@solanocounty.com
 I will not be submitting educational documents

Supervision Received and Exercised

Supervision is received from a Principal Information Technology Analyst or an Information Technology Manager. The incumbent may receive functional direction from the Assistant Director and/or Chief Information Officer.  Incumbents in this classification may function as a project manager and/or team leader over technical and professional staff.

VETERANS 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 APPLICATION SUBMITTAL 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”), must complete the following form: Request for Testing Accommodation by Applicants with Disabilities Form

This form must be received in the Human Resources Department by the final filing date of the recruitment.  Applicants will be contacted to discuss the specifics of the request.

SOLANO COUNTY


Click here to take a video tour of Solano County

OUR COMMUNITY

Solano County is the ideal place to live, learn, work and play…  The America's Promise Alliance has named Solano County as one of the 100 Best Communities for Young People for six straight years—the only California community with that distinction.

Live – Solano County as well as cities within the County have ranked in the top 15 hottest markets across the country and within the Bay Area due to prime location and affordability.

Learn – Higher education abounds! Within the County, education choices include: Solano Community College, CSU Maritime Academy, Brandman University, and Touro University. Bordering our County is the renowned University of California Davis.

Work – The blend of agriculture, corporate business and pleasant lifestyle enhance the attraction of Solano County. Blessed with a thriving agricultural economy, the county is also home to biotechnology and other growth industries.

Play - Situated midway between San Francisco and Sacramento—the State capitol, Solano County is home to rolling hillsides, waterfronts and fertile farmland. County residents can enjoy day trips to the San Francisco Bay area, Lake Tahoe region and the Napa and Sonoma Valleys.

County Population (2019): 447,643

The provisions of this bulletin do not constitute an expressed or implied contract. Any provision contained in this bulletin may be modified or revoked without notice.  

SOLANO COUNTY IS AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER