Data Engineer II

IEHP; Rancho Cucamonga (CA); Hybrid; USD 104,041 - 137,841; Full time

Benefits offered by this job

Competitive salary

Hybrid schedule

Fitness center on-site

Medical, dental, and vision insurance

Career advancement opportunities

Wellness programs

Paid life insurance

Pet care insurance

Job summary

A healthcare organization in Rancho Cucamonga is seeking a Data Engineer II to enhance data reliability and develop efficient architectures for data management. Ideal candidates will have four years of experience in data modeling with strong SQL skills, and will be involved in all aspects of data extraction and transformation processes. This role offers a competitive salary and a hybrid working model, along with comprehensive benefits including health insurance and career advancement opportunities.

Qualifications

• Four years of relevant work experience in data modeling.
• Experience with orchestration tools like Azure DevOps.
• Ability to develop ETL procedures and manage data warehouses.
• Strong analytical and problem-solving skills.

Responsibilities

• Assist in improving data reliability and quality.
• Develop architectures for data extraction and transformation.
• Handle back‑end development life cycle for the data warehouse.
• Implement ETL procedures and manage warehouse databases.

Skills

Data modeling

SQL

Azure Data Catalogue

Power BI Dataflows

Python

T-SQL

Education

Bachelor's degree

Master’s degree (preferred)

Azure Data Engineering Certification (preferred)

Tools

Azure Cloud

Databricks

PySpark

Hadoop

Kubernetes

Job description

What you can expect!

Find joy in serving others with IEHP! We welcome you to join us in “healing and inspiring the human spirit” and to pivot from a “job” opportunity to an authentic experience.

The Data Engineer II assists in the implementation of methods to improve data reliability and quality. This role is responsible for combining raw information from different sources to create consistent and machine-readable formats. The Data Engineer II must also develop and test architectures that enable data extraction and transformation for predictive or prescriptive modeling. The Data Engineer II will focus on data accessibility, which will enable the organization to utilize data for performance evaluation and optimization. The Data Engineer II is also responsible for managing the entire back‑end development life cycle for the company's enterprise data warehouse. In this role the incumbent will handle tasks associated with the implementation of ETL procedures, building warehouse databases, database performance management, and dimensional modeling and design of the table structures.

Commitment to Quality: The IEHP Team is committed to incorporating IEHP’s Quality Program goals including, but not limited to, HEDIS, CAHPS, and NCQA Accreditation.

Perks

• 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.

Education & Requirements

• Four (4) years of relevant work experience. Experience and knowledge in logical, rational, dimensional, and physical data modeling. Background in database systems along with a strong knowledge of SQL. Experience with Orchestration tools, Azure DevOps, and CI/CD. Intermediate experience with the following tools and technologies:
  • Azure Data Catalogue / Purview
  • Azure Cloud
  • Databricks
  • Power BI Dataflows
  • Power Query
  • Azure Cosmos
  • Azure Monitor
  • PowerShell
  • Python
• Development experience using PySpark, Spark, Hadoop, Kubernetes, and RDMIS is highly desired.
• Bachelor's degree from an accredited institution required.
• Master’s degree from an accredited institution preferred.
• Azure Data Engineering Certification is preferred.

Key Qualifications

• Multi‑server environment knowledge such as linked servers, data replication, backup/restore with MS SQL Server 2008+.
• Knowledge of applicable data privacy practices and laws.
• Highly skilled in developing and optimizing T‑SQL (DDL, DML, DCL) queries, stored procedures, functions, and views for various applications that involve numerous database tables and complex business logic.
• Good written and oral communication skills.
• Strong technical documentation skills.
• Good interpersonal skills.
• Highly self‑motivated and directed.
• Keen attention to detail.
• Proven analytical and problem‑solving abilities.
• Ability to effectively prioritize and execute tasks in a high‑pressure environment.

Start your journey towards a thriving future with IEHP and apply TODAY!

Pay Range

• $104,041.60 USD Annually - $137,841.60 USD Annually