Data Integration Engineer III
Transcarent
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $80,000 - $95,000 per year
Job Level
Mid-LevelSenior
Tech Stack
ETLSQL
About the role
- Collaborate with partners and internal stakeholders to define requirements for the ingestion, transformation, and extraction of data in support of Accolade’s services.
- Lead data integration work for new customer implementations—building pipelines and connecting external partner data into Accolade’s systems to support operational and business needs.
- Break down work into epics, stories, and tasks, partnering with your team to groom, estimate, plan, and deliver on two-week sprints.
- Design, build, test, and deploy reliable data pipelines that deliver high-quality, timely data.
- Ensure integrations are scalable, well-documented, and aligned with Accolade’s data standards.
- Analyze and troubleshoot data quality issues raised by partners; perform root cause analysis and drive issues to resolution.
- Partner with internal teams to diagnose platform or processing issues that impact data ingestion or extraction, and contribute to continuous improvement initiatives that enhance data consistency and reliability.
- Support Issue Management workflows, respond to data-related questions, and proactively identify opportunities to improve data health.
- Analyze data files, layouts, and data dictionaries from healthcare administrative data sources (eligibility, plan/account, medical claims, pharmacy claims).
- Define business and technical requirements, create interface definitions, and produce clear source-to-target mappings.
- Become a subject-matter expert in Accolade’s platform, data model, and integration patterns.
- Help maintain consistency across data models and ensure adherence to standards across multiple customer and platform initiatives.
- Participate in learning opportunities, cross-functional training, and innovation projects outside of sprint work.
- Bring forward ideas for improving architecture, tooling, automation, and processes.
Requirements
- Bachelor’s degree in Information Management, Computer Science/Engineering, Mathematics, Business, or a related field.
- 4+ years of hands-on experience in data-centric testing and database environments—healthcare claims or enrollment data experience is highly preferred.
- Exposure to Talend or other ETL/ELT tools is a plus.
- Strong understanding and experience with SQL, data validation, multidimensional data models, and concepts such as slowly changing dimensions (SCD) and change data capture (CDC).
- Experience working on an Agile team within a CI/CD development environment, with the ability to collaborate effectively and deliver high-quality solutions in fast-paced settings.
- Ability to analyze complex data and process flows, translate business needs into functional specifications, and align data processes with broader business goals.
- Strong foundation in data warehousing principles, architecture, and implementation at scale.
Benefits
- Competitive medical, dental, and vision coverage
- Competitive 401(k) Plan with a generous company match
- Flexible Time Off/Paid Time Off, 12 paid holidays
- Protection Plans including Life Insurance, Disability Insurance, and Supplemental Insurance
- Mental Health and Wellness benefits
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data integrationdata pipelinesSQLdata validationmultidimensional data modelsslowly changing dimensionschange data capturedata warehousing principlesETL toolsdatabase environments
Soft skills
collaborationproblem-solvingcommunicationanalytical thinkingcontinuous improvementadaptabilityteamworkleadershipplanninginnovation