Kimball Data Modeling Jobs

1 job found

13d ago

Information Technology Analyst IV (Cloud Data Engineer)

Solano County Fairfield, CA

Fairfield, CA

13d ago

$62 - $75/hr Full time Manager Senior Analyst

Apply Now

Job Description

Solano County DoIT seeks a Senior Information Technology Analyst IV (Cloud Data Engineer) to lead design and maintenance of major data systems onsite in Fairfield, CA, with a salary of USD 62 - 75 per hour.

Responsibilities

Act as the team lead and project manager for designated major systems.
Provide advanced technical support to system users.
Offer strategic direction to software development, network and systems administration, service desk, security, and database teams, as well as consultants, on system design and infrastructure projects.

Requirements

Bachelor's degree is required.
Demonstrated advanced expertise in modern data warehousing technologies including Azure Data Lake, Azure Synapse, Kimball data modeling, facts and dimensions design, and Medallion Architecture for data engineering.
Strong ETL development experience with SSIS and Azure Data Factory.
Proficient in SQL, Python, and R.
Significant 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.

Technologies

Azure Data Lake
Azure Synapse
SSIS
Azure Data Factory
SQL
Python
R
Power BI
DevOps
Purview
Dynamics CRM
Medallion Architecture
Kimball data modeling
data warehouse technologies

The Position

This is the fourth classification level in the Information Technology Analyst job series.
Incumbents apply advanced specialized and technical analytical skills and act as team leader/project manager for designated major systems.
They perform the most difficult duties, including providing advanced technical support to system users.
They 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.

Ideal Candidate

Demonstrates advanced knowledge in modern data warehouse technologies, including Azure Data Lake, Azure Synapse, Kimball data modeling, facts and dimensions design, and Medallion Architecture.
Skilled in ETL development using SSIS and Azure Data Factory.
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.

Selection Process

Based on application documents, qualified applicants may be invited for further examination and will be pre-scheduled by the Department of Human Resources or invited to self-schedule.
All applicants meeting the minimum qualifications are not guaranteed advancement through any subsequent phase of the examination.
Depending on the number of applications, the process may include an initial application screening, mandatory information meeting, 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 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 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 a contingent job offer is accepted. Provisions are subject to change.
RETIREES - 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 requested materials (degree/transcripts, certificates, DD-214 if applicable, ADA Accommodation Request) must be submitted by the final filing date.
Previously submitted application materials for prior recruitments will not be applied for this recruitment but must be re-submitted for this recruitment.

How to Submit Your Documents

In addition to uploading attachments online, you may submit documents by fax to (707) 784-3424 or by email to recruitment@solanocounty.com. Include the recruitment title and recruitment number in your submission.

Veteran’s Preference Points

To be eligible, applicants must have served at least 181 consecutive days of active duty in the Armed Forces and have received an honorable discharge or a general discharge under honorable conditions; a copy of DD 214 (copy 4) must be received by the final filing date.
Service connected disability applicants must submit a recent VA award letter stating disability benefits.
Veteran preference points: five points for honorable/general discharge; ten points for 30 percent or more service-connected disability. Points apply to passing scores in competitive open examinations.

View full job page →

Get Kimball Data Modeling Jobs alerts

New Kimball Data Modeling Jobs, daily.