Data Engineer

  • Solano County
  • Fairfield, CA, USA
  • Mar 18, 2021
Full-time Data Engineering Data Management Data Modeling Data Warehousing Information Systems (IS) Information Technology (IT) Python R SAS Software Development

Job Description

 The County of Solano has three (3) openings for Data Engineers to assist the Department of Information Technology (DoIT) to build a data warehouse from the ground up.

These newly created data engineer positions will start the development of the data warehouse team and bring the knowledge, vision and drive to successfully lay the foundation for data rationalization. These positions are responsible for analyzing and profiling data from our 18 departments. The largest and most complex department in the County is Health and Social Services (HSS), which includes Public Health, Social and Behavioral Health Services and has the highest demand for data use and reporting requirements. The Data Management Team serves in the Central IT department of the County of Solano, supporting two data centers, 18 departments with over 3,000 employees who work across multiple industries and providing services to approximately 447,643 constituents. If you are looking for an amazing career opportunity, in a dynamic and fast paced environment, working with a forward thinking, team-oriented organization.

IDEAL CANDIDATE

Our Data Engineers 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. These Engineers will 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.

Our ideal candidate will be an excellent communicator who is collaborative, motivating, and entrepreneurial spirit to work independently, drive their own work, and effectively collaborate and work within a team. The Data Engineers will constantly question the status quo and ask how things can be done better. We are looking for someone who can see the data, visualize it, and make a story out of it, and have the ability to imagine the data differently for reporting needs.

Below is a list of our department’s tools and transferable competitor tools. We hope to see ideal candidates bring knowledge and experience in some or all of these areas.

  • Data warehouse experience: data sourcing, analyzing and modeling experience.
  • DoIT’s Data Tools:  
  • Azure Synapse, Power BI, Data Factory, DevOps, Purview, D365
  • Competitor Data Tools: Snowflake, Informatica, Talend, SAS, Amazon or Google Cloud tools
  • Other Tools and Languages: Kimball Methodology and/or Snowflake Methodology
  • Desired Coding Languages:  Python, r, SAS

Education and Experience – Minimum Qualifications

  • Data warehouse experience: data sourcing, analyzing and modeling experience.
  • Equivalent to an Associate’s degree, preferably in information technology, or a closely related field., AND;
  • Five (5) years of experience performing progressively responsible software development, or infrastructure management duties and functions.
  • Note: Additional experience may substitute on a year for year basis for the educational requirement.
  • Bachelor’s degree from an accredited college or university, preferably in information technology, management information systems may be substituted for two years of experience.

Licenses and Certifications:

  • Must possess a California class-C driver’s license.
  • Desired Certifications: Azure Fundamentals, Azure Data Fundamentals, Azure Data Engineering, and it would be very helpful if you were DAMA certified (CDMP).

COMPENSATION AND BENEFITS

The salary range for this position is Annual Salary: $99,618 – $121,086 DOE/DOQ. In addition to the base salary, the County offers an excellent benefits package, see the full brochure on our job board for more details.

HOW TO APPLY:

This position is open until filled, apply immediately for consideration by clicking the 'Apply Now' button below.

  • Interviews will be held as ideal candidates are identified, starting the week of April 12th
 
 
 

Salary

$99,618 – $121,086 DOE/DOQ