Data Engineer III

Date: Jan 16, 2022

Location: Rancho Cucamonga, CA, US

Company: Inland Empire Health Plans

Job Requisition ID: 5542 


Position Summary/Position


Under the direction of the Data Warehouse Manager, the Data Warehouse Developer III manages the design, planning and development of Data Warehouse solutions. This role leads the ETL development, design and create procedures to acquire, harmonize, and consolidate the IEHP data assets. the Data Warehouse Developer III is expected to lead by example.  The Data Warehouse Developer III leads and mentors coding activities throughout all aspects of the data warehouse function to produce efficient and high quality solutions.

Major Functions (Duties and Responsibilities)


1. Design, develop and lead data warehouse Extraction, Transformation and Loading (ETL) solutions using Microsoft SQL Server Integration Services (SSIS)
2. Lead, design, develop and implement data collection processes in conjunction with the data warehouse. Source data from HSP and legacy systems supporting a centralized data warehouse and reporting platform.
3. Lead, design and implement technical solutions to meet the requirements for Data Science and Data Warehouse
4. Analyze user requirements and translate into database requirements and implement in database code
5. Manage and enforce standards on data modeling, data profiling, database design and metadata management
6. Lead and mentor tuning activities throughout all aspects of the data warehouse function to produce efficient and high quality solutions
7. Proactively design and build process to prevent potential data quality issues
8. Work closely with Data Warehouse Architect and Informatics Architect to design data and analytics solutions to increase the usability, completeness, and accuracy of enterprise data
9. Create, maintain and optimize SQL queries and routines
10. Develop, adopt, and enforce Data Warehouse and ETL standards and architecture
11. Monitor and support ETL processes ensuring integrity and proper integration of all data sources
12. Create high throughput historical and incremental ETL jobs
13. Facilitate change control, problem management, and communication among data architects, managers, informaticsts and analysts
14. Provide detailed analysis of data issues; data mapping; and the process for automation and enhancement of data quality
15. 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.
16. Collaborate and contribute to data integration strategies and visions
17. Ensure that all deliverables are thoroughly documented in Data Warehouse and ETL knowledge base documents
18. Provide ongoing proactive technical support for ETL and data warehouse system to ensure business continuity
19. Work with Informaticsts and Analysts to translate analytic requirements into technical solutions.

Supervisory Responsibilities

Leading: Self

Experience Qualifications


Five (5) years experience performing data warehouse development, modification and support. Three (3) years with SQL Server – SSIS.  Five (5) years experience with knowledge of data warehouse technical architectures, ETL, data structures, and reporting tools and environments.  Experience in code development, testing for QA, and data profiling.  Must be able to perform SQL queries tuning activities. Experience in normalized, dimensional, star schema and snow flake schematic models. Experience and knowledge in logical, rational, dimensional, and physical data modeling. Experience working in a team-oriented, collaborative environment. Background in database systems.

Education Qualifications


Bachelor's of Science degree from an accredited institution required.

Preferred Education


Master’s of Science degree from an accredited institution preferred.

Drivers License Required


Knowledge Requirement


An understanding of healthcare systems and healthcare databases desirable. Strong understanding of database structures, theories, principles, and practices. Knowledge of professional software engineering practices and best practices for the full software development life cycle (SDLC), including coding standards, code reviews, source control management, build processes, testing, and operations. Strong knowledge of SQL. Multi-server environment knowledge such as linked servers, data replication, backup/restore with MS SQL Server 2008+. 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. Knowledge of applicable data privacy practices and laws.

Skills Requirement


Good written and oral communication skills. Strong technical documentation skills. Good interpersonal skills. Proven analytical and problem-solving abilities.

Abilities Requirement


Ability to effectively prioritize and execute tasks in a high-pressure environment. Highly self motivated and directed. Keen attention to detail.

Commitment to Team Culture


The IEHP Team environment requires a Team Member to participate in the IEHP Team Culture. A Team Member demonstrates support of the Culture by developing professional and effective working relationships that include elements of respect and cooperation with Team Members, Members and associates outside of our organization.

Working Conditions


Word processing and programming involving computer keyboard and screens.


Starting Salary: $111,550.40  - $142,230.40  

Pay rate will commensurate with experience


Inland Empire Health Plan (IEHP) is the largest not-for-profit Medi-Cal and Medicare health plan in the Inland Empire. We are also one of the largest employers in the region. With a provider network of more than 6,000 and a team of more than 2,000 employees, IEHP provides quality, accessible healthcare services to more than 1.2 million members. And our mission and core values help guide us in the development of innovative programs and the creation of an award winning workplace. As the healthcare landscape is transformed, we’re ready to make a difference today and in the years to come. Join our Team and Make a Difference with us! IEHP offers a Competitive salary and a benefit package with a value estimated at 35% of the annual salary, including medical, dental, vision, team bonus, and retirement plan.


Nearest Major Market: Riverside
Nearest Secondary Market: Los Angeles