Data Engineer

Job Description

Job Summary:

We are seeking a talented Data Engineer with experience in managing data workflows using SQL. We are working on SQL-based solutions for our client’s healthcare data needs, and we need an engineer to help enhance and maintain these systems. Experience in SQL is a must, while familiarity with DBT is preferred. This role focuses on day-to-day development work, with potential mentorship opportunities for junior engineers over time.

This is an opportunity to join the Maitri family early, with ample room for career growth, including potential engineering management responsibilities for the right candidate.

Job Description:

As a Data Engineer, your responsibilities will include:

• Designing, developing, and maintaining scalable data models using SQL to support healthcare data analytics.
• Optimizing and troubleshooting SQL queries and ensuring efficient database performance.
• Developing Python-based ETL pipelines to streamline data extraction, transformation, and loading processes.
• Collaborating with cross-functional teams to translate business requirements into effective data solutions.
• Developing fast, reliable, and large-scale data processing pipelines to ingest data from multiple sources into an enterprise data warehouse and data lake.
• Implementing ETL processes to extract, transform, and load healthcare data from various sources using Apache Airflow.
• Ensuring data integrity and accuracy by working closely with data analysts and stakeholders.
• Documenting data models, processes, and transformations.
• Staying up to date with healthcare industry standards and best practices for data engineering.
• Identifying and resolving data-related issues and system malfunctions.
• Collaborating closely with project managers, business analysts, and other stakeholders.

Job Specification:

Required Skills and Expertise:

• Education: Bachelor's degree in Computer Science, Engineering, or a related field.
• Experience: 2+ years of experience working with US healthcare data, with a focus on SQL. Knowledge of DBT is a plus.
• SQL Skills: Advanced SQL proficiency, including complex queries, performance optimization, and familiarity with various databases.
• Programming: Strong experience in Python for building ETL pipelines, including data extraction from APIs or databases, data transformation, and loading into target systems.
• Healthcare Data: Strong understanding of US healthcare datasets, including medical records, claims, eligibility records, and compliance standards (e.g., HIPAA).
• ETL: Experience in data extraction, transformation, and loading (ETL) processes.
• Data Modeling: Proven ability to design and implement efficient and scalable data models.
• Troubleshooting: Experience diagnosing and resolving data-related issues.
• Analytics: Strong analytical skills for working with structured and unstructured datasets.
• Collaboration: Strong communication skills and experience working with cross-functional teams in a fast-paced environment.

Preferred Skills:

• Knowledge of Apache AIrflow is a plus.
• Knowledge of CMS Data Code Sets (ICD-10, CPT-4, HCPCS, NDC, Taxonomy)
• HEDIS and HCC knowledge

Soft Skills:

• Analytical thinking and problem-solving skills.
• Strong attention to detail and accuracy.
• Good written and verbal communication skills.
• A continuous learning mindset to stay current with industry trends.

Application Procedure:

1. Email your application and resume to [email protected]
2. Mention “Data Engineer” in the email subject.