Job Title: Sr. Data Engineer – EHR Data Migration Company Name: eClinicalWorks Job Details: Hiring,Remotely,in,Westborough,,MA,In-Office,or,Remote,95K-130K,Annually,Mid,level Job Url: https://builtin.com/job/sr-data-engineer-ehr-data-migration/8670634 Job Description: We are eClinicalWorks. We are a privately held leader in healthcare IT, providing comprehensive, cloud based EHR/PRM solutions to medical professionals worldwide to improve workflows and reduce the risk of physician burnout. We care. We are committed to positive change. And that’s where you come in. Do you value creativity and innovation? Great, so do we. At eClinicalWorks, we share a passion for improving healthcare through dedication, education, and teamwork. Everyone has that one thing they’re really good at. We value your talent and want you to join our fast-paced, fun, and culturally diverse environment. Ready to make a difference? Apply today. Summary We’re hiring a hands-on Sr. Data Engineer to lead large-scale EHR → eClinicalWorks (eCW) data migrations. You’ll combine advanced SQL, Python + AI engineering, and Azure-native services to deliver ingestion, mapping, transformation, validation, and document conversion at scale. You’ll architect resilient ADF pipelines, Azure Functions, and AKS workloads, and apply LLM-powered data processing to accelerate mapping and improve quality. Key Responsibilities Client Engagement & Requirements Partner with customers to capture migration scope, workflows, and data quality expectations; lead technical discoveries, schema deep-dives, and gap analysis. Present migration strategies, risks, and timelines; set and manage SLAs/SLOs for each phase. Data Analysis, Mapping & Loading (EHR → eCW) Analyze complex schemas across SQL Server/MySQL/Oracle/APIs, design staging and canonical models. Build deterministic and AI-assisted mappings. AI Engineering & Automation Use Python with Copilot, Cursor, Azure OpenAI/Claude or Codex to accelerate coding, tests, and playbooks. Build LLM/RAG services for mapping suggestions, anomaly detection, context- aware transformations, design prompts, guardrails, and evaluation harnesses. Implement retrieval pipelines (embeddings, vector search) and maintain prompt/test corpora. Azure Cloud Data Platform Architect and operate ADF orchestrations; implement Azure Functions-based microservices; manage Blob/ADLS Gen2, Azure SQL/MI, Key Vault, and VNETs/private endpoints. Enable observability using Azure Monitor/Log Analytics/App Insights; publish run health, lineage, and cost dashboards. Establish CI/CD with Azure DevOps/GitHub Actions and IaC (Bicep/Terraform) enforce environments, approvals, and policy-as-code. Document Migration & Unstructured Data Processing Convert and migrate millions of documents (DOC/DOCX/RTF/TXT/IMG) into PDF. Run conversion at scale on AKS with containers/Helm, HPA/KEDA autoscaling, and Service Bus/Event Hubs for queue-driven orchestration. Ensure output quality (completeness, orientation, readability), retries/backoff, idempotency, and poison-message handling; track throughput/error budgets. Quality, Testing & Troubleshooting Implement data quality checks (Great Expectations/dbt tests) and automated reconciliation; own root-cause analysis for schema, mapping, and pipeline issues. Maintain playbooks/runbooks; drive continuous improvement and pattern reuse. Security & Compliance Ensure HIPAA compliance, PHI protection, encryption, secure data handling, and proper access controls. Follow internal security and auditing requirements when working with clinical datasets. Collaboration & Leadership Partner with Clinical Informatics, Product, Customer Success, and Engineering to deliver smooth migrations. Contribute to internal frameworks, tools, process improvements, and documentation. Mentor engineers; champion code reviews, testing, and an automation/AI-first engineering culture. Required Skills & Qualifications 3+ years of data engineering experience. Expert SQL (T‑SQL, window functions, indexing, query plan analysis, stored procedures/functions) on large datasets. Advanced Python (packaging, pytest, typing), building services/CLIs. Strong working knowledge of AI development tools (Codex, Copilot, Cursor) and LLM APIs (Azure OpenAI, Claude). Strong working knowledge of Azure: ADF, Azure Functions, Blob/ADLS Gen2, Azure SQL/MI, Key Vault, Monitor/Log Analytics, App Insights; Understanding of VNET/private endpoint networking. Containers/Kubernetes: Docker, AKS, Helm; autoscaling (HPA/KEDA), blue/green or canary deployments, image scanning. Knowledge of integrating with external platforms through SOAP, REST, and FHIR APIs to extract and migrate data. Certifications (Preferred) Microsoft Certified – Azure AI Engineer Associate Microsoft Certified – Fabric Data Engineer Associate Certified Kubernetes Administrator (CKA) Work Model Location: Hybrid (Massachusetts) or US-based remote with overlap as needed Compensation: Salary Range - $95,000 - $130,000 USD This role will receive a competitive salary and benefits. The salary for employees hired into this role will be aligned with the range above, exclusive of potential bonuses. If you are hired, your base salary will be determined based on factors such as professional background, skills, education, and experience. eClinicalWorks offers a rich suite of benefits which include the following: eighteen days of Paid Time Off per year which scales based on tenure; nine Paid Holidays and one Floating Holiday; insurance for eligible employees which includes medical, dental, vision, basic life, short term disability, long term disability, business travel accident, and accidental death and dismemberment. As well, we offer a 401(k) plan with a Company safe harbor contribution; Flexible Spending Account for Health Care and Dependent Care for eligible employees; limited personal leave; additional voluntary benefits, including additional insurance (hospital indemnity, critical illness, accident, supplemental life, short term disability buy up, pet), genetic testing, legal plan, and supplemental accidental death and dismemberment; and an annual discretionary bonus for eligible employees. eClinicalWorks is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills, and experiences that bring us together and help create a healthy world. Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.