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. Part of your responsibilities may also include functioning as a project manager and/or team leader over technical and professional staff.
Our current Opportunity is within our Data Management Team!
As an Information Technology Analyst IV (Data Engineer), you will be 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 system, profile and load it into a model, and generate reports.
Position 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.
REQUIRED LICENSING, CERTIFICATION AND REGISTRATION:
Applicants may be required to possess a valid California Driver’s License, Class C.
To view the full job description for this position, please visit:
Our ideal candidate is an excellent communicator; they are collaborative, motivating, entrepreneurial, and comfortable working autonomously. Our ideal candidate will form meaningful partnerships within our 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.
Desired Systems Experience:
Azure Synapse
Power BI
Data Factory
DevOps, Purview
D365
Snowflake
Informatica
Talend
SAS
Amazon or Google Cloud tools
Desired Tools and Languages:
Kimball Methodology and/or Snowflake Methodology
Coding with Python, R, SAS
Desired Certifications:
Azure Fundamentals
Azure Data Fundamentals
Azure Data Engineering
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,586.60 per month for 2021. 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 for the first three (3) years. 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.
To view the benefits for a regular position, please visit:
Extra-help employees who work less than 29 hours per week do not typically receive or accrue benefits of regular employees during their period of employment. All extra-help employees accrue .034 hours of Paid Time Off.
To view the benefits for this extra-help position, please visit:
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
Next Application Review Window:
10/12/2021 – 5:00pm Deadline to submit application and required documents for application review.
TBD - window for department 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 visit the County of Solano website, www.jobsatsolanocounty.com, to apply. 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. Be sure to include the recruitment title (Information Technology Analyst IV) and the recruitment number (21-367060-01) in your email or fax, and are due by the application review 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.
SPECIAL REQUIREMENTS
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 final filing date. Candidates who fail to submit their transcripts by the final filing date 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 (21-367060-01) in your email or fax.
SUPPLEMENTAL INFORMATION
This 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.
I have experience in application support / implementation / administration using the following Enterprise solutions: (Check all that apply)
Data Platform Management (Azure Data Factory, Data Lake)
Data Platform Management System (Informatica, Redshift, Snowflake, etc)
Electronic Health Record Systems (Avatar, NextGen, EPIC, etc)
Content Management Systems (Hyland, Documentum, etc)
Case Management Systems (CalWIN/CalSAWS, CWS/CMS, CMIPS II, LEAPS, etc)
Other (Indicate type of Enterprise Solution)
I do not have any experience with Enterprise solutions.
If you selected other on the above question, please enter your response below.
2.
I have experience with the following Analytics systems: (check all that apply)
Microsoft Power BI
Microsoft SQL Server Reporting Services
Statistical tools such as R or SAS
Crystal Reports
Other
I do not have any experience with Analytics solutions.
If you selected other on the above question, please enter your response below.
3.
I have experience with the following CRM support systems: (check all that apply)
Dynamics 365
Salesforce
Other
I do not have any experience with CRM support systems.
If you selected other on the above question, please enter your response below.
4.
I have experience with the following EHR systems: (check all that apply)
NextGen
Avatar
EPIC
Cerner
Other
I do not have any experience with EHR systems.
If you selected other on the above question, please enter your response below.
5.
I have experience with the following Data Management Body of Knowledge Domains: (check all that apply)
Data Governance
Data Modeling and Design
Data Integration and Operability
Reference and Master Data
DW and BI
Meta Data
Data Quality
Other
I do not have experience with Data Management Body of Knowledge Domains.
If you selected other on the above question, please enter your response below.
6.
I have obtained the following certifications: (check all that apply)
Azure Fundamentals
Azure Data Fundamentals
Azure Data Engineering
DAMA (CDMP)
Other
I do not have any technology certifications.
If you selected other on the above question, please enter your response below.
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 FINAL FILING DATE. 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 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 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
