Data Engineer II

Inland Empire Health Plan offers a data engineering role that emphasizes service, stability, and ongoing growth. The Data Engineer II position provides a competitive salary range of USD 104,041.60 to 137,841.60 per year and a hybrid work setup in Rancho Cucamonga, CA. You will design, build, and maintain the data warehouse ETL landscape to improve data reliability, accessibility, and analytics, collaborating across data engineering, BI and analytics, and enterprise architecture to strengthen our enterprise data capabilities.

Work model: hybrid schedule with remote work on Mondays and Fridays and on-site collaboration Tuesday through Thursday in Rancho Cucamonga, CA.

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

Overview

What you can expect is a role rooted in serving others, with opportunities to grow alongside a team dedicated to healing and inspiring the human spirit. This position invites you to move from a routine job to a meaningful, authentic experience within IEHP.

Responsibilities

• Design and implement data warehouse ETL solutions using SSIS, Azure Data Factory, Synapse Analytics, Az Data Bricks, and PySpark ETL
• Develop data collection processes aligned with the data warehouse
• Ingest data from legacy systems to support a centralized data warehouse and reporting platform
• Develop 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 roadmaps
• Build and maintain scalable data pipelines and microservices-based architectures based on platform and application requirements
• Work with the Data Engineering, BI and Analytics, Data Warehouse Architect, and Data Systems Architect to design data and analytics solutions that improve usability, completeness, and accuracy of enterprise data
• Support stakeholders including executives, product, data and design teams with data-related technical issues and infrastructure needs
• Analyze user requirements and translate them into database specifications, implementing them in code
• Analyze data issues, map data, and automate enhancements to data quality
• Assemble large, complex data sets that meet functional and non-functional business requirements
• Identify and implement process improvements, automating manual pipelines, optimizing data ingestion and consumption, and redesigning infrastructure for scalability and microservices
• Create, maintain, and optimize SQL queries and routines
• Analyze 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 integrity and proper integration of data sources
• Facilitate problem management and cross-team communication among data architects, managers, informaticists, and analysts
• Perform source-to-target mapping validations
• Identify, document and execute unit tests and scripts
• Peer and lead code reviews according to the checklist and document results
• Provide ongoing proactive technical support for ETL and data warehouse systems to ensure business continuity
• Perform additional duties as needed to support Health Plan operations and department goals

Requirements

• Four (4) years of relevant work experience
• Experience and knowledge in logical, rational, dimensional, and physical data modeling
• Background in database systems with strong 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

Technologies

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