Senior Data Engineer

Job Purpose The Senior Data Engineer designs, builds, and maintains scalable data pipelines and architectures to support the Denials AI workflow under the guidance of the Team Lead, Data Management. This role ensures data is reliable, compliant with HIPAA, and optimized.Required Hours: 9AM-5PM ESTDuties & ResponsibilitiesCollaborate with the Team Lead and cross functional teams to gather and refine data requirements for Denials AI solutionsDesign, implement, and optimize ETL/ELT pipelines using Python, Dagster, DBT, and AWS data services (Athena, Glue, SQS)Develop and maintain data models in PostgreSQL; write efficient SQL for querying and performance tuningMonitor pipeline health and performance; troubleshoot data incidents and implement preventive measuresEnforce data quality and governance standards, including HIPAA compliance for PHI handlingConduct code reviews, share best practices, and mentor junior data engineersAutomate deployment and monitoring tasks using infrastructure-as-code and AWS CloudWatch metrics and alarmsDocument data workflows, schemas, and operational runbooks to support team knowledge transferOther duties as assignedUse, protect and disclose patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standardsUnderstand and comply with Information Security and HIPAA policies and procedures at all timesLimit viewing of PHI to the absolute minimum as necessary to perform assigned dutiesQualificationsBachelor’s or master’s degree in Computer Science, Data Engineering, or related field5+ years of hands on experience building and operating production grade data pipelinesSolid experience with workflow orchestration tools (Dagster) and transformation frameworks (DBT) or other similar tools such (Microsoft SSIS, AWS Glue, Air Flow)Strong SQL skills on PostgreSQL for data modeling and query optimization or any other similar technologies (Microsoft SQL Server, Oracle, AWS RDS)Working knowledge with AWS data services: Athena, Glue, SQS, SNS, IAM, and CloudWatchBasic proficiency in Python and Python data frameworks (Pandas, PySpark)Experience with version control (GitHub) and CI/CD for data projectsFamiliarity with healthcare data standards and HIPAA complianceExperience mentoring or leading small technical effortsProficiency in Microsoft Office SuiteStrong interpersonal skills, ability to communicate well at all levels of the organizationStrong problem solving and creative skills and the ability to exercise sound judgment and make decisions based on accurate and timely analysesHigh level of integrity and dependability with a strong sense of urgency and results orientedExcellent written and verbal communication skills requiredWorking ConditionsRegular working hours; on-call for data pipeline incident response.Must possess a smart-phone or electronic device capable of downloading applications, for multifactor authentication and security purposes.Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear.Mental Demands: The employee must be able to follow directions, collaborate with others, and handle stress.Work Environment: The noise level in the work environment is usually minimal.Med-Metrix will not discriminate against any employee or applicant for employment because of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, veteran status, other non-merit based factors, or any other characteristic protected by federal, state or local law.Originally posted on Himalayas