Hybrid Data Engineer II — ETL & Warehouse Specialist

Talentify; Rancho Cucamonga (CA); Hybrid; USD 120,000 - 150,000; Full time

Benefits offered by this job

Competitive salary

Hybrid schedule

On-site fitness center

Medical, dental, and vision insurance

Life and disability coverage

Professional development opportunities

Wellness programs

Job summary

IEHP is seeking a Data Engineer II to enhance data reliability, quality, and accessibility. You will integrate data from multiple sources into canonical formats and build architectures enabling extraction, transformation, and modeling for analytics programs.

Core duties include back-end data warehouse development, ETL processes, and dimensional modelling. The role emphasizes data accessibility for performance evaluation and optimization, ensuring scalable, consistent data structures and robust

Qualifications

• 4 years of relevant work experience in data engineering or related field.
• Experience with logical, rational, dimensional, and physical data modeling.
• Strong SQL knowledge and experience with MS SQL Server.
• Experience with orchestration tools and CI/CD pipelines; Azure DevOps preferred.

Responsibilities

• Assist in improving data reliability and quality across sources.
• Combine raw data into consistent, machine-readable formats.
• Develop and test architectures for data extraction and transformation for predictive or prescriptive modeling.
• Manage back-end development life cycle for the enterprise data warehouse, including ETL, warehouse design, and performance tuning.

Skills

SQL

PySpark

Spark

Hadoop

Kubernetes

Python

PowerShell

CI/CD

Azure DevOps

Databricks

Power BI

Azure Cosmos

Azure Monitor

Power Query

Databases

RDMIS

Education

Bachelor's degree

Master’s degree (preferred)

Azure Data Engineering Certification (preferred)

Tools

Azure Data Catalogue / Purview

Azure Cloud

Databricks

Power BI Dataflows

Power Query

Azure Cosmos

Azure Monitor

Job description

IEHP is seeking a Data Engineer II to enhance data reliability, quality, and accessibility. You will integrate data from multiple sources into canonical formats and build architectures enabling extraction, transformation, and modeling for analytics programs.

Core duties include back-end data warehouse development, ETL processes, and dimensional modelling. The role emphasizes data accessibility for performance evaluation and optimization, ensuring scalable, consistent data structures and robust