← Back to jobsJob ID col-cmv8h4kpa08dwoz01z8auam59

IEHPPosted 30+ days ago

Data Engineer II

Full-time
Hybrid
4+ years
Competitive
Posted 30+ days ago

Responsibilities Design and develop data warehouse Extraction, Transformation and Loading (ETL) solutions using Microsoft SQL Server Integration Services (SSIS), Azure Data Factory, Synapse Analytics, Az Data Bricks, PySpark ETL Develop and implement data collection processes in conjunction with the data warehouse. Source data from legacy systems supporting a centralized data warehouse and reporting platform Develop

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • Design and develop data warehouse Extraction, Transformation and Loading (ETL) solutions using Microsoft SQL Server Integration Services (SSIS), Azure Data Factory, Synapse Analytics, Az Data Bricks, PySpark ETL
  • Develop and implement data collection processes in conjunction with the data warehouse. Source data from legacy systems supporting a centralized data warehouse and reporting platform
  • Develop technical solutions to meet the requirements for Data Warehouse, BI & Analytics. Work with Informaticists and Analysts to translate analytic requirements into technical solutions
  • Collaborate and contribute to data integration strategies and visions. Create and maintain optimal data pipeline architectures based on micro services based on platform and application requirements
  • Work closely with the Data Engineering team, BI & Analytics team, Data Warehouse Architect, and Data Systems Architect to design data and analytics solutions to increase the usability, completeness, and accuracy of enterprise data
  • Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs
  • Analyze user requirements and translate user requirements into database requirements and implement them in database code
  • Provide detailed analysis of data issues, data mapping, and the process for automation and enhancement of data quality. Assemble large, complex data sets that meet functional / non-functional business requirements
  • Identify, design, and implement process improvements: automating manual pipeline processes, optimizing data ingestion and consumption, re-designing infrastructure for greater scalability, micro services, and others as applicable
  • Create, maintain, and optimize SQL queries and routines. Analyze potential data quality issues to determine the root cause and create effective solutions
  • Develop, adopt, and enforce Data Warehouse and ETL standards and architecture. Monitor and support ETL processes ensuring integrity and proper integration of all data sources
  • Facilitate problem management and communication among data architects, managers, informaticists and analysts
  • Perform development activities such as source to target mapping validations, identify, document and execute unit test cases/scripts, peer and lead code reviews per code review checklist and document test and review results
  • Provide ongoing proactive technical support for ETL and data warehouse system to ensure business continuity
  • Perform any other duties as required to ensure Health Plan operations and department business needs are successful

Qualifications

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

Preferred

  • Master's degree from an accredited institution preferred
  • Azure Data Engineering Certification is preferred

Required skills

ETLAzure Data FactorySynapse AnalyticsAzure DatabricksPySparkSQLData modelingAzure DevOpsCI/CDPower BIPower QueryKubernetes

Nice to have

CommunicationInterpersonal skillsSelf-motivationAttention to detailAnalytical skillsProblem-solving

Full job description

Responsibilities

  • Design and develop data warehouse Extraction, Transformation and Loading (ETL) solutions using Microsoft SQL Server Integration Services (SSIS), Azure Data Factory, Synapse Analytics, Az Data Bricks, PySpark ETL
  • Develop and implement data collection processes in conjunction with the data warehouse. Source data from legacy systems supporting a centralized data warehouse and reporting platform
  • Develop technical solutions to meet the requirements for Data Warehouse, BI & Analytics. Work with Informaticists and Analysts to translate analytic requirements into technical solutions
  • Collaborate and contribute to data integration strategies and visions. Create and maintain optimal data pipeline architectures based on micro services based on platform and application requirements
  • Work closely with the Data Engineering team, BI & Analytics team, Data Warehouse Architect, and Data Systems Architect to design data and analytics solutions to increase the usability, completeness, and accuracy of enterprise data
  • Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs
  • Analyze user requirements and translate user requirements into database requirements and implement them in database code
  • Provide detailed analysis of data issues, data mapping, and the process for automation and enhancement of data quality. Assemble large, complex data sets that meet functional / non-functional business requirements
  • Identify, design, and implement process improvements: automating manual pipeline processes, optimizing data ingestion and consumption, re-designing infrastructure for greater scalability, micro services, and others as applicable
  • Create, maintain, and optimize SQL queries and routines. Analyze potential data quality issues to determine the root cause and create effective solutions
  • Develop, adopt, and enforce Data Warehouse and ETL standards and architecture. Monitor and support ETL processes ensuring integrity and proper integration of all data sources
  • Facilitate problem management and communication among data architects, managers, informaticists and analysts
  • Perform development activities such as source to target mapping validations, identify, document and execute unit test cases/scripts, peer and lead code reviews per code review checklist and document test and review results
  • Provide ongoing proactive technical support for ETL and data warehouse system to ensure business continuity
  • Perform any other duties as required to ensure Health Plan operations and department business needs are successful

Preferred

  • Master's degree from an accredited institution preferred
  • Azure Data Engineering Certification is preferred

Benefits

  • 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

Qualifications

  • 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
  • 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
  • Master's degree from an accredited institution preferred
  • Azure Data Engineering Certification is preferred
  • Four (4) years of relevant work experience.

Required skills

  • ETL, Microsoft SQL Server Integration Services (SSIS), Azure Data Factory, Synapse Analytics, Azure Databricks, PySpark, SQL, Data modeling, Azure DevOps, CI/CD, Power BI, Power Query, Kubernetes

Preferred skills

  • Communication, Interpersonal skills, Self-motivation, Attention to detail, Analytical skills, Problem-solving

Experience

  • 4+ years

Company

  • With a mission to heal and inspire the human spirit, Inland Empire Health Plan (IEHP) is one of the top 10 largest Medicaid health plans, the largest not-for-profit Medicare-Medicaid public health plan in the country, and for the fourth year in a row, certified as A Great Place To Work®.
  • Rancho Cucamonga, California, USA
  • http://ww3.iehp.org/

Job details

Employment type

Full-time

Seniority level

4+ years

Date posted

Sep 28, 2026

Work mode

Hybrid

Job source

Ethic Leaf recruiter

Company

IEHP

Information Technology & AI

With a mission to heal and inspire the human spirit, Inland Empire Health Plan (IEHP) is one of the top 10 largest Medicaid health plans, the largest not-for-profit Medicare-Medicaid public health plan in the country, and for the fourth year in a row, certified as A Great Place To Work®.

See all 2 jobs from IEHP →
  • Rancho Cucamonga, California, USA
  • Information Technology & AI
  • ww3.iehp.org

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Rancho Cucamonga

Artificial Intelligence (AI)

1d ago

New

Data Engineer

Full-timeHybridGlendale, CACompetitive

Prudent Technologies and Consulting, Inc. is hiring a Data Engineer to build and maintain data pipelines and support migration of Snowflake transformations to Databricks.

Why similarSame roleCI/CDGlendale

Meritore Technologies

1d ago

New

AWS Data Engineer

Full-timeOn-siteTorrance, CACompetitive

Meritore Technologies is hiring an AWS Data Engineer to build and operate scalable AWS data pipelines and cloud-based data lake and warehouse solutions.

Why similarSame roleCI/CDTorrance

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleAzure Data FactoryRemote

Get new Data Engineer jobs in Rancho Cucamonga by email

Create job alert

Data Engineer II

IEHP · Competitive

Apply via Ethic Leaf