Descripción función
Who We Are
HaloMD specializes in Independent Dispute Resolution (IDR) through The No Surprises Act and state regulations for out-of-network healthcare providers, leveraging advanced technology and deep industry expertise to secure optimized reimbursements.
Job Summary
The Data Engineer contributes to the development and maintenance of data pipelines and ingestion infrastructure that power HaloMD's core platform. This role supports engineering work related to data entering the system from external sources - including EDI/EOB file ingestion, third-party data feeds, email ingestion, and API integrations with external vendors. A significant component of this role involves building and maintaining DBT models that encode client-specific business rules during onboarding, working alongside senior engineers and Business Analysts to translate client data requirements into reliable Snowflake transformations.
The Data Engineer operates independently on well-defined initiatives and is expected to own their work end-to-end - from development through documentation and ongoing support - with minimal oversight.
Key Responsibilities
Data Pipeline & Ingestion Engineering
- Build and maintain data pipelines that handle ingestion of external data sources, including EDI/EOB files, third-party data feeds, secure and standard email, and API integrations with external vendors.
- Develop and maintain Snowflake objects supporting ingestion workflows, including stored procedures, views, staging tables, and batch logic.
- Implement workflow orchestration logic in Dagster under the guidance of senior engineers, including scheduling, dependency management, and basic alerting.
- Support the build and maintenance of API integrations connecting external systems to HaloMD's ingestion pipeline.
- Monitor assigned pipelines for failures and data quality issues, investigating and resolving problems within the defined scope and escalating when needed.
DBT Development & Client Onboarding
- Build, test, and maintain DBT models in Snowflake that implement client-specific business rules across data mart domains, including Claims, Disputes, Invoices, Customers & Entity, and Benchmark data.
- Collaborate with Business Analysts during client onboarding to translate data mapping specifications and business logic into DBT transformations following established patterns and standards.
- Write well-structured, thoroughly tested DBT models with clear documentation - including logic descriptions and business rule rationale.
- Validate DBT outputs against client-defined expectations, working with BAs and QA to confirm accuracy before go-live.
Quality, Accuracy & Ownership
- Take ownership of the pipelines and models you build - monitor for failures, investigate anomalies, and resolve issues proactively.
- Validate outputs at every stage and confirm downstream impact before closing any ticket or deployment.
- Maintain clear documentation for all pipeline changes, including object names, logic descriptions, and before/after evidence prior to deployment.
- Understand how ingestion failures impact client onboarding timelines and downstream data availability and communicate risks early.
Cross-Functional Collaboration
- Partners with Business Analysts, QA, and Customer Success to ensure ingestion and onboarding deliverables meet defined requirements and business expectations.
- Participate in sprint ceremonies and maintain ticket hygiene in Azure DevOps, including status updates, documentation links, and deployment evidence.
- Communicate clearly about blockers and timelines, surfacing issues early rather than absorbing delays.
- Work within established change management processes, including release schedules, peer review, and version control via Azure DevOps.
Experience
- 4 - 7+ years of experience in data engineering, software engineering, or a closely related role.
- Hands-on experience with DBT for transformation modeling and testing required.
- Experience with Snowflake and familiarity with Dagster or equivalent orchestration tooling required.
- Healthcare or healthcare technology industry experience preferred, not required.
Technical Skills
- Strong SQL proficiency - CTEs, window functions, conditional logic, deduplication, and stored procedures in Snowflake.
- Hands-on experience with DBT for transformation modeling, testing, and documentation.
- Working knowledge of Dagster or similar workflow orchestration tools.
- Familiarity with API-driven architectures and messaging systems, including topics, subscriptions, and queues.
- Experience with EDI, EOB, or similar structured file format ingestion preferred.
- Proficiency in Azure DevOps for ticket tracking, source control, and CI/CD workflows.
- Familiarity with Power BI or similar reporting tools for validating data outputs preferred.
Education
- Bachelor's degree in computer science, Information Technology, Data Engineering, or a related field, or equivalent professional work experience is required.
Soft Skills
- Strong sense of ownership - you follow your work through to completion and don't consider something done until the output is validated and documented.
- Detail-oriented with a proactive approach to identifying issues before they become problems.
- Able to translate business requirements into technical logic and ask the right clarifying questions when requirements are ambiguous.
- Clear communicator - able to provide concise status updates and flag blockers without being prompted.
- Comfortable managing multiple workstreams in a fast-paced environment with shifting priorities.
Perks & Benefits:
- Remote - Work from anywhere is the United States with reliable high-speed internet
- Multiple medical plan options
- Health Savings Account with company contributions
- Dental & vision coverage for you and your dependents
- 401k with Company match
- Vacation, sick time & Company paid holidays
- Company wellbeing program with health insurance incentives
What's Next?
If you're ready to bring your skills and passion to our growing team, we want to hear from you! Apply today and help us create a future where success is the standard.