Data Jobs in Rancho Cucamonga, CA

1 job found

Include remote jobs

19d ago

Data Engineer II

Inland Empire Health Plan Rancho Cucamonga, CA

Rancho Cucamonga, CA

19d ago

$104k - $138k/yr Full time Analytics Azure Data Factory Azure Databricks

Apply Now

Job Description

IEHP offers a benefits-forward, mission-driven environment where you can grow as a Data Engineer II while making a tangible impact on care delivery. You will design, build, and maintain data warehouse ETL processes to boost data reliability, accessibility, and analytics, with oversight of the enterprise data warehouse back end. The role features a competitive salary, a hybrid work schedule, and a comprehensive benefits package that supports health, retirement, and well-being. The culture centers on serving others and is built around healing and inspiring the human spirit.

Pay range: USD 104,041.60 – 137,841.60 per year

Benefits

Competitive salary
Hybrid schedule
State of the art fitness center on-site
Medical insurance with dental and vision
Life, short-term, and long-term disability options
Career advancement opportunities and professional development
Wellness programs that promote a healthy work-life balance
Flexible Spending Account – Health Care/Childcare
CalPERS retirement
457(b) option with a contribution match
Paid life insurance for employees
Pet care insurance

Key Responsibilities

Design and implement data warehouse ETL solutions using SSIS, Azure Data Factory, Synapse Analytics, Azure Data Bricks, and PySpark ETL
Develop and deploy data collection processes aligned with the data warehouse
Source data from legacy systems to support a centralized data warehouse and reporting platform
Create technical solutions to meet Data Warehouse, BI and Analytics requirements
Collaborate with informaticists and analysts to translate analytic needs into technical solutions
Contribute to data integration strategies and the vision for data architecture
Build and maintain optimal data pipeline architectures based on microservices aligned with platform and application requirements
Partner with the Data Engineering, BI & Analytics teams, the Data Warehouse Architect, and the Data Systems Architect to design usable, complete, and accurate enterprise data solutions
Support data infrastructure needs for stakeholders including Executive, Product, Data and Design teams
Analyze user requirements and translate them into database specifications, implementing them in database code
Provide detailed analysis of data issues, data mapping, and automation to improve data quality
Assemble large, complex data sets to meet functional and non-functional business requirements
Identify and implement process improvements such as automating pipelines, optimizing data ingestion, and designing scalable infrastructure
Create, maintain, and optimize SQL queries and routines
Investigate data quality issues to determine root causes and implement solutions
Develop, adopt, and enforce Data Warehouse and ETL standards and architecture
Monitor and support ETL processes to ensure data source integrity
Facilitate problem management and communication among data architects, managers, informaticists, and analysts
Perform source-to-target mapping validations and document results
Identify, document, and execute unit tests; lead code reviews and document results
Provide ongoing proactive technical support for ETL and data warehouse systems to ensure business continuity
Perform other duties as needed to support Health Plan operations and departmental needs

Requirements

Four years of relevant work experience
Experience with logical, dimensional, and physical data modeling concepts
Strong background in database systems with solid SQL skills
Experience with orchestration tools, Azure DevOps, and CI/CD
Intermediate experience with the following technologies and tools:
- Azure Data Catalogue / Purview
- Azure Cloud
- Databricks
- Power BI Dataflows
- Power Query
- Azure Cosmos
- Azure Monitor
- PowerShell
- Python
- PySpark, Spark, Hadoop, Kubernetes, and RDMIS development is highly desirable
Bachelor's degree from an accredited institution is required
Master’s degree from an accredited institution is preferred
Azure Data Engineering Certification is preferred

Technologies

SQL Server Integration Services (SSIS)
Azure Data Factory
Synapse Analytics
Azure Databricks
PySpark
SQL, T-SQL
Power BI Dataflows
Power Query
Azure Cosmos
Azure Monitor
PowerShell
Python
Databricks, Spark, Hadoop
Kubernetes
RDMIS
MS SQL Server
Azure Data Catalogue / Purview
Azure Cloud
Azure DevOps

Work Model and Location

This position operates on a hybrid schedule with remote work on Mondays and Fridays, and onsite presence Tuesday through Thursday in Rancho Cucamonga, CA.

View full job page →

Get Data Jobs in Rancho Cucamonga, CA alerts

New Data Jobs in Rancho Cucamonga, CA, daily.