Data Engineer II

2 weeks ago

Rancho Cucamonga California, United States Inland Empire Health Plan Full time
Overview:
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

 

The Data Engineer II assists in the implementation of methods to improve data reliability and quality. This role is responsible for combining raw information from different sources to create consistent and machine-readable formats. The Data Engineer II must also develop and test architectures that enable data extraction and transformation for predictive or prescriptive modeling. The Data Engineer II will focus on data accessibility, which will enable the organization to utilize data for performance evaluation and optimization. The data Engineer II is also responsible for managing the entire back-end development life cycle for the company's enterprise data warehouse. In this role the incumbent will handle tasks associated with the implementation of ETL procedures, building warehouse databases, database performance management, and dimensional modeling and design of the table structures, in addition to collaboration with, inter-departments to ensure member needs are met while simultaneously building strong peer relationships.

 

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.

Additional Benefits:
 

Perks

 

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

 

CalPERS retirement

457(b) option with a contribution match

Generous paid time off- vacation, holidays, sick

State of the art fitness center on-site

Medical Insurance with Dental and Vision

Paid life insurance for employees with additional options

Short-term, and long-term disability options

Pet care insurance

Flexible Spending Account – Health Care/Childcare

Wellness programs that promote a healthy work-life balance

Career advancement opportunities and professional development

Competitive salary with annual merit increase

Team bonus opportunities

Qualifications:
 

Duties & 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 closely with the data engineering and BI & Analytics teams to design data and analytics solutions to increase the usability, completeness, and accuracy of enterprise data

Analyze user requirements and translate into database requirements and implement in database code

Create and maintain the optimal data pipeline architectures based on micro services based on platform and application requirements

Assemble large, complex data sets that meet functional / non-functional business requirements8.

Identify, design, and implement process improvements: automating manual pipeline processes, optimizing data ingestion and consumption, re-designing infrastructure for greater scalability, micro services, etc9.

Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.

 Work closely with Data Warehouse Architect and Data Systems Architect to design data and analytics solutions to increase the usability, completeness, and accuracy of enterprise data

Create, maintain, and optimize SQL queries and routine

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

Create high throughput historical and incremental ETL jobs

Facilitate problem management, and communication among data architects, managers, informaticists and analysts

Provide detailed analysis of data issues; data mapping; and the process for automation and enhancement of data quality

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.

Collaborate and contribute to data integration strategies and vision

Provide ongoing proactive technical support for ETL and data warehouse system to ensure business continuity.

Work with Informaticists and Analysts to translate analytic requirements into technical solutions.

 

 

Education & Experience

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

 

 

Key Qualifications

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

 

 

 

 

 

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

Pay Range:
USD $50.02 - USD $66.27 /Hr.

  • Data Engineer II

    3 days ago

    Rancho Cucamonga, United States Inland Empire Health Plan Full time

    Overview: 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!The Data Engineer II assists in the implementation of methods to improve data reliability and quality. This role is responsible for combining raw information...

  • Data Engineer II

    1 week ago

    Rancho Cucamonga, United States Inland Empire Health Plans Full time

    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! The Data Engineer II assists in the implementation of methods to improve data reliability and quality. This role is responsible for combining raw information...

  • Healthcare Data Analyst II

    1 week ago

    Rancho Cucamonga, United States Inland Empire Health Plans Full time

    What you can expect! This is a Hybrid Role with Southern California Residency Required. The position is scheduled to be on site in Rancho Cucamonga, California weekly Tuesday-Thursday. 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...

  • Healthcare Data Analyst II

    7 days ago

    Rancho Cucamonga, United States IEHP Full time

    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 team, the Healthcare Data Analyst II - Data Quality & Reporting (HDA II - DQ & R) is responsible for leading...

  • Engineer II

    3 days ago

    Rancho Cucamonga, United States Inland Empire Health Plan Full time

    Overview: 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 Supervisor, Integrated Operations, Engineer II, Technology Integrated Operations will be focused on overall monitoring of the...

  • Healthcare Data Analyst II

    6 days ago

    Rancho Cucamonga, United States Inland Empire Health Plan Full time

    Overview: 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 team, the Healthcare Data Analyst II Data Quality & Reporting (HDA II DQ & R) is responsible for leading...

  • Engineer II

    1 week ago

    Rancho Cucamonga, United States Robert Maddox Full time

    Job Description Job Description Key Responsibilities: 1. Engineering plan preparation and production. 2. Perform design tasks, engineering calculations, solve design problems and develop knowledge of general design standards and agency requirements for plan preparation. 3. Coordinate with architect/agency/client for production of design. 4. Maintain updated...

  • Engineer II

    1 month ago

    Rancho Cucamonga, United States Inland Empire Health Plans Full time

    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 Supervisor, Integrated Operations, Engineer II, Technology – Integrated Operations will be focused on overall monitoring of the...

  • Engineer II

    1 week ago

    Rancho Cucamonga, United States Robert Maddox Full time

    Job DescriptionJob DescriptionKey Responsibilities: 1. Engineering plan preparation and production.2. Perform design tasks, engineering calculations, solve design problems and develop knowledge of general design standards and agency requirements for plan preparation.3. Coordinate with architect/agency/client for production of design.4. Maintain updated...

  • IT Specialist II

    9 hours ago

    Rancho Cucamonga, United States Inland Empire Health Plans Full time

    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! The IT Specialist II - EDI will work with the client implementation team to assist in the on boarding of new clients. The IT Specialist II - EDI will be...

  • IT Specialist Ii

    1 month ago

    Rancho Cucamonga, United States Inland Empire Health Plan Full time

    **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!** The IT Specialist II - EDI will work with the client implementation team to assist in the on boarding of new clients. The IT Specialist II - EDI...

  • IT Specialist Ii

    1 month ago

    Rancho Cucamonga, United States Inland Empire Health Plan Full time

    Overview: **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!** The IT Specialist II - EDI will work with the client implementation team to assist in the on boarding of new clients. The IT Specialist...

  • Quality Improvement Facilitator II

    3 weeks ago

    Rancho Cucamonga, United States Inland Empire Health Plan Full time

    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 management, and with minimal supervision, the Quality Improvement (QI) Facilitator II works closely with front line leaders, external...

  • Healthcare Data Analyst II

    4 weeks ago

    Rancho Cucamonga, United States IEHP Full time

    What You Can You 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! Spearhead analysis and reporting for Health Plan's elite teams. Mastermind of relational databases, strategic magic, and impactful presentations. From decoding...

  • Manager, Data Integration

    7 hours ago

    Rancho Cucamonga, United States Inland Empire Health Plans Full time

    What You Can You 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! Lead a dynamic team of Integration/Interoperability Engineers as the Manager of data Integration & Interoperability! Drive system-to-system integrations...

  • Sr. Monitoring and Observability engineer w/d Dynatrace and SolarWinds Exp

    3 days ago

    Rancho Cucamonga, United States Saxon Global Full time

    Duties and Responsibilities: The Monitoring and Observability engineer will be responsible for Designing, configuring, monitoring, implementing, and maintaining our observability solutions and troubleshooting IT systems and applications to ensure optimal performance and reliability. You will work closely with cross-functional teams to identify potential...

  • Spacecraft Systems Engineer I/II Pipeline

    7 hours ago

    California, United States Rocket Lab Full time

    SPACE SYSTEMS Rocket Lab’s Space Systems team is responsible for every satellite and satellite component made by Rocket Lab: from complete satellites destined for missions to the Moon and Mars, to the individual components and subsystems that make up a satellite like solar panels, flight software, reaction wheels and star trackers, separation systems,...

  • Management Analyst II/III

    9 hours ago

    Rancho Cucamonga, United States City of Rancho Cucamonga Full time

    Team RC has the perfect career opportunity for you! We value our employees here at Team RC! The City of Rancho Cucamonga (Team RC) is not your average public agency employer. We are an award-winning “Best-in-Class Employer” by Gallagher! We currently have openings in multiple departments for the position of Management Analyst II-III. The vacancies are...

  • Project Engineer II

    6 hours ago

    Rancho Cucamonga, United States ISEC Full time

    Reports to: Operations Manager/Project Manager FLSA Status: Exempt Position Summary The Project Engineer is responsible for assisting the Project Manager with administrative duties associated with the project, material releases, vendor follow-up, coding invoices for A/P, routine correspondence, field dimensioning, change orders, submittals and labor and...

  • Equipment Engineer II/Senior Equipment Engineer

    2 days ago

    California, United States Rocket Lab Full time

    ENGINEERING Engineering is at the heart of Rocket Lab. Our engineering team has a proven track record of designing and developing world-class rockets and spacecraft that are changing the way we access and use space. You’ll work alongside driven, talented engineers from varied backgrounds and experience levels, all committed to the same mission. Our...