Data Engineer

Job Description

Interwell Health is seeking a Data Engineer to contribute to its mission of reimagining healthcare. The Data Engineer will be responsible for corporate claims data acquisition, file loading, and structure development. This role involves designing and developing database systems, processes, and documentation, including data collection, analysis, algorithm design, flowchart creation, code implementation, and EDW database maintenance.Role involves:

• Collaborating with development groups to deliver projects.
• Maintaining knowledge of the latest technologies.
• Identifying enhancement options and process improvements.
• Assisting with schema design, code review, and SQL query tuning.
• Writing and deploying SQL code.
• Mentoring junior teammates.
• Becoming skilled with the architecture and technology supporting the Datawarehouse.
• Ensuring the distribution of knowledge for processes being designed and built within the team.
• Ensuring the design of sufficient documentation for easy and smooth hand-over of projects.
• Participating in the formulation and design of methodologies.
• Training in developing tools that are available with the Datawarehouse and Lakehouse infrastructure.
• Monitoring and troubleshooting data pipelines.

Requirements:

• 3-5 years related experience in data engineering with bachelor’s degree; or a master’s degree with 3 years’ experience.
• Ability to architect simple and complex solutions related to integration with other applications and design.
• Excellent communication skills, both verbal and written.
• Strong presentation skills.
• Experience working under tight deadlines while maintaining high product relevance and quality.
• Azure/SQL focus
• Strong understanding of data lake and Lakehouse architecture principles, data modeling techniques, and data warehousing concepts.
• 3-5 years’ experience using Azure Data Factory pipelines and Databricks.
• 5 years’ experience working with Azure databases.
• Extensive experience with MS SQL stack. (SSIS and ADF)
• Extensive experience with Azure - Cloud migration.
• Python experience.

Role offers:

• Opportunity to work with a mission-driven company.
• A commitment to diversity, equity, and inclusion.