Data Engineer II

Overview:

What you can expectFind 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 experienceThe 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.Key Responsibilities:1. 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.2. 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.3. Develop technical solutions to meet the requirements for Data Warehouse, BI & Analytics4. 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 data5. Analyze user requirements and translate into database requirements and implement in database code6. Create and maintain the optimal data pipeline architectures based on micro services based on platform and application requirements7. 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.10. 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 data11. Create, maintain, and optimize SQL queries and routines12. Analyze potential data quality issues to determine the root cause and create effective solutions.13. Develop, adopt, and enforce Data Warehouse and ETL standards and architecture14. Monitor and support ETL processes ensuring integrity and proper integration of all data sources15. Create high throughput historical and incremental ETL jobs16. Facilitate problem management, and communication among data architects, managers, informaticists and analysts17. Provide detailed analysis of data issues; data mapping; and the process for automation and enhancement of data quality18. 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.19. Collaborate and contribute to data integration strategies and visions20. Provide ongoing proactive technical support for ETL and data warehouse system to ensure business continuity.21. Work with Informaticists and Analysts to translate analytic requirements into technical solutions.Commitment to Quality: The IEHP Team is committed to incorporate IEHPs 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 retirement457(b) option with a contribution matchGenerous paid time off- vacation, holidays, sickState of the art fitness center on-siteMedical Insurance with Dental and VisionPaid life insurance for employees with additional optionsShort-term, and long-term disability optionsPet care insuranceFlexible Spending Account Health Care/ChildcareWellness programs that promote a healthy work-life balanceCareer advancement opportunities and professional developmentCompetitive salary with annual merit increaseTeam bonus opportunities

Qualifications:Duties & ResponsibilitiesDesign 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 & AnalyticsWork closely with the data engineering and BI & Analytics teams to design data and analytics solutions to increase the usability, completeness, and accuracy of enterprise dataAnalyze user requirements and translate into database requirements and implement in database codeCreate and maintain the optimal data pipeline architectures based on micro services based on platform and application requirementsAssemble 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 dataCreate, maintain, and optimize SQL queries and routineAnalyze potential data quality issues to determine the root cause and create effective solutions.Develop, adopt, and enforce Data Warehouse and ETL standards and architectureMonitor and support ETL processes ensuring integrity and proper integration of all data sourcesCreate high throughput historical and incremental ETL jobsFacilitate problem management, and communication among data architects, managers, informaticists and analystsProvide detailed analysis of data issues; data mapping; and the process for automation and enhancement of data qualityPerform 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 visionProvide 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 & ExperienceBachelor's degree from an accredited institution requiredMulti-server environment knowledge such as linked servers, data replication, backup/restore with MS SQL Server 2008+Knowledge of applicable data privacy practices and lawsKey QualificationsHighly 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 TODAYPay Range:USD $50.02 - USD $66.27 /Hr. #J-18808-Ljbffr