Data Engineer II
Inland Empire Health Plan8 months ago
Rancho Cucamonga, CA, USAMid Level
Base Salary
$104k - $138k/yr
Responsibilities
- Design and develop enterprise data warehouse extraction, transformation, and loading solutions using SSIS, Azure Data Factory, Synapse Analytics, Azure Databricks, and PySpark.
- Develop data collection processes and source data from legacy systems for centralized data warehouse and reporting platforms.
- Translate analytic and user requirements into database requirements, technical solutions, database code, data mappings, and automation processes.
- Create and maintain scalable data pipeline architectures and optimize data ingestion, consumption, SQL queries, routines, and database performance.
- Collaborate with data engineering, BI and analytics, data warehouse architecture, data systems architecture, executive, product, data, and design teams.
- Analyze data quality issues, identify root causes, and implement solutions that improve data completeness, accuracy, reliability, and accessibility.
- Develop, enforce, and maintain data warehouse and ETL standards and architecture.
- Monitor and support ETL processes and provide proactive technical support for ETL and data warehouse systems.
- Perform source-to-target mapping validation, write and execute unit test cases, participate in code reviews, and document testing and review results.
- Facilitate problem management and communication among data architects, managers, informaticists, and analysts.
Requirements
- Bachelor's degree from an accredited institution is required; a master's degree is preferred.
- Four years of relevant work experience is required.
- Experience with logical, rational, dimensional, and physical data modeling is required.
- Strong database systems knowledge and SQL expertise, including T-SQL, stored procedures, functions, views, DDL, DML, and DCL, are required.
- Experience with orchestration tools, Azure DevOps, and CI/CD is required.
- Intermediate experience with Azure Data Catalogue/Purview, Azure Cloud, Databricks, Power BI Dataflows, Power Query, Azure Cosmos, Azure Monitor, PowerShell, and Python is required.
- Development experience with PySpark, Spark, Hadoop, Kubernetes, and RDMIS is highly desired.
- Knowledge of multi-server environments, linked servers, data replication, and backup/restore using Microsoft SQL Server 2008 or later is required.
- Knowledge of applicable data privacy practices and laws is required.
- Azure Data Engineering Certification is preferred.
- Strong written and oral communication, technical documentation, interpersonal, analytical, problem-solving, prioritization, and task-execution skills are required.
Benefits
- Hybrid schedule: remote on Mondays and Fridays and onsite Tuesday through Thursday in Rancho Cucamonga, California.
- Medical, dental, and vision insurance.
- Life insurance and short-term and long-term disability options.
- CalPERS retirement and a 457(b) option with contribution match.
- Paid life insurance for employees.
- Flexible Spending Account for healthcare and childcare.
- On-site fitness center, wellness programs, and pet care insurance.
- Career advancement and professional development opportunities.
- Salary range of USD $104,041.60 to USD $137,841.60 per year.
Tech Stack
Categories
Data Engineering
About Inland Empire Health Plan
Inland Empire Health Plan is a nonprofit, government-sponsored managed care health plan that administers Medi-Cal and Medicare-Medicaid benefits for residents of Riverside and San Bernardino counties. It contracts with a regional provider network and offers HMO coverage, care management, and member services; more than 1.5 million people are enrolled. Founded in 1995 and headquartered in Rancho Cucamonga, CA, it operates as a public plan serving California’s Inland Empire.