Data Engineer III

Inland Empire Health Plans; California (MO); Hybrid; USD 100,000 - 130,000; Full time

Job summary

Inland Empire Health Plans is looking for a Data Engineer III responsible for designing and developing data solutions. The ideal candidate will have extensive experience in Azure, strong programming skills, and the ability to mentor junior engineers. This role combines technical expertise with a commitment to enhance data processes and pipeline architectures, making a significant impact in healthcare services.

Benefits

Competitive salary

Hybrid schedule

CalPERS retirement

State of the art fitness center on-site

Medical Insurance with Dental and Vision

Career advancement opportunities

Wellness programs that promote healthy work-life balance

Flexible Spending Account – Health Care/Childcare

Paid life insurance for employees

Pet care insurance

Qualifications

• Minimum of 8 years in Azure data solutions.
• 5 years hands-on experience with cloud orchestration and CI/CD pipelines.
• Fluency in Python or Java.

Responsibilities

• Design and implement data solutions based on business requirements.
• Create data pipeline architecture and maintain process design artifacts.
• Lead design and development of data transformation.

Skills

DevOps

Python

Java

Data Privacy

Big Data Architecture

Education

Bachelor’s degree in Computer Science, Statistics, Mathematics or Engineering

Tools

Azure Data Lake

Azure Data Factory

Azure SQL Data Warehouse

Azure Synapse

Cosmos DB

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!

Under the direction of the Department Leadership, the Data Engineer III is responsible for the design, planning and development of IEHP data solutions. The Data Engineer III will lead the design and development of data transformation. This position will be involved in data architecture. The Data Engineer III is expected to lead by example. In this role the Data Engineer III will follow coding standards throughout all aspects of the solution development to produce efficient and high-quality solutions, in addition to collaboration with, inter-departments to ensure member needs are met while simultaneously building strong peer relationships.

Key Responsibilities:

1. Design, develop and implement reliable and effective data solutions based on business requirements.
2. Maintain process design artifacts like data flow diagrams, end user process maps and technical design documents.
3. Find trends in data sets and develop algorithms to help make raw data more useful to IEHP.
4. Create and maintain optimal data pipeline architecture that meet security standards.
5. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.
6. Develop best practices for database design and development activities.
7. Create complex functions, scripts, and services to support the Data Services team.
8. Ensure all data solutions meet company and performance requirements.
9. Work under minimal supervision with wide latitude for independent judgment.
10. Conduct code reviews.
11. Direct and mentor some level I and II engineers.
12. Serve as a subject matter expert in key business projects.
13. Recommend improvements to existing Data Services processes as necessary.
14. Provide detailed analysis of data issues; data mapping; and the process for automation and enhancement of data quality.
15. Analyze and integrate new technologies with existing applications to improve the design and functionality of applications.
16. Maintain proficient programming skills in REST web services, C#.NET, TSQL, XML, JSON, and other relevant languages and/or frameworks.
17. Develop and automate solutions to consume data from multiple data sources, including external API
18. Program and modify code in languages like Java, Json, Python, and Spark to support and implement Data Warehouse solutions.
19. Design and deploy enterprise-scale cloud infrastructure solutions.
20. Research, analyze, recommend and select technical approaches for solving difficult and meaningful development and integration problems.
21. Work closely with the Data and Engineering teams to design best in class Azure implementations.
22. Clearly and regularly communicate with management, colleagues, and domain units.

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

Perks

IEHP is not only committed to healing and inspiring the human spirit of our Members, but we also aim to match our team members with the same energy by providing prime benefits and more.

• Competitive salary.
• Hybrid schedule.
• CalPERS retirement.
• 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 & Experience

• Minimum of eight (8) years of experience in provisioning, configuring, and developing solutions in Azure Data Lake, Azure Data Factory, Azure SQL Data Warehouse, Azure Synapse and Cosmos DB.
• Eight (8) years implementing software development methodologies.
• Eight (8) years working with relational databases. Experience building and optimizing big data pipelines, architectures, and data sets.
• Experience performing root cause analysis on internal and external data and processes. Experience using Source Control and management tools such as Azure DevOps and Gitlab/GitHub. Experience transforming requirements into Design Concepts and ERDs using Visio and similar tools.
• Of the total eight, a minimum of five (5) years of hands-on experience with cloud orchestration and automation tools and CI/CD pipeline creation is required.
• Bachelor’s degree in a quantitative discipline such as Computer Science, Statistics, Mathematics or Engineering from an accredited institution required.

Key Qualifications

• Strong knowledge and understanding in the following areas:
  - DevOps, Python or Java or Json, (HL7/ FHIR is a plus)
  - Applicable data privacy practices and laws
  - common SDLC models (Waterfall, Agile - Scrum and Kanban)
  - Practice of DevOps
  - Non-relational database (NoSQL) designs using MongoDB and others
  - Relational databases like MS SQL Server
  - Fluency with at least one scripting or programming language such as Python.
  - Message queuing, stream processing, and highly scalable ‘big data’ data stores.

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