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.
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.
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 & Requirements
Four (4) years of relevant work experience.
Experience and knowledge in logical, rational, dimensional, and physical data modeling.
Background in database systems along with a strong knowledge of SQL.
Experience with Orchestration tools, Azure DevOps, and CI/CD.
Intermediate experience with the following tools and technologies: Azure Data Catalogue / Purview Azure Cloud Databricks Power BI Dataflows Power Query Azure Cosmos Azure Monitor PowerShell Python
Development experience using PySpark, Spark, Hadoop, Kubernetes, and RDMIS is highly desired
Bachelor's degree from an accredited institution required
Master's degree from an accredited institution preferred
Azure Data Engineering Certification is preferred
Key Qualifications
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
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
Good written and oral communication skills
Strong technical documentation skills
Good interpersonal skills
Highly self-motivated and directed
Keen attention to detail
Proven analytical and problem-solving abilities
Ability to effectively prioritize and execute tasks in a high-pressure environment
Start your journey towards a thriving future with IEHP and apply TODAY!