Data Engineer

JOB SUMMARY

The Data Engineer is responsible for designing, developing, integrating, and maintaining the data infrastructure necessary to support clinical, operational, financial, quality, and strategic initiatives across Pinehurst Surgical Clinic. This position works across EHR platforms, clinical applications, business systems, interfaces, reporting platforms, and emerging technologies to ensure organizational data is reliable, accessible, secure, and actionable.

The role develops automated data pipelines and integrations, improves reporting and analytics capabilities, reduces manual data-processing workflows, and establishes scalable data architecture to support future analytics, artificial intelligence, and automation initiatives. The Data Engineer collaborates with Health Information Systems, clinical and operational leadership, vendors, analysts, and other stakeholders to translate organizational needs into technical solutions.

RESPONSIBILITIES

Data Engineering and Integration

• Design, develop, maintain, and monitor ETL/ELT workflows and automated data pipelines between clinical, operational, financial, and third-party systems.
• Develop integrations using APIs, databases, flat files, and healthcare interoperability standards including HL7, FHIR, C-CDA, and related technologies.
• Extract, normalize, transform, reconcile, and validate data from multiple healthcare applications and data sources.
• Design scalable data structures, relational models, reporting datasets, and data marts to support analytics and organizational reporting.
• Develop processes for historical data extraction, conversion, archival, and migration associated with application transitions.
• Troubleshoot data integration, synchronization, mapping, and data-quality issues across systems.

Epic and Clinical Data

• Support data and integration requirements associated with Epic Community Connect.
• Assist with source-to-target mapping, historical data conversion, interface validation, reporting requirements, and reconciliation between legacy and future-state systems.
• Develop technical solutions to preserve access to historical clinical and operational information as systems are transitioned or retired.
• Collaborate with clinical, operational, and technical teams to ensure data remains accurate and clinically meaningful throughout system implementations and migrations.

Analytics and Quality Reporting

• Develop reliable datasets and automated processes supporting clinical quality, MIPS, operational, financial, and executive reporting.
• Build data-validation and reconciliation processes that improve the completeness and accuracy of regulatory and quality reporting.
• Partner with operational and clinical stakeholders to translate business requirements into measurable KPIs, data models, dashboards, and reporting solutions.
• Support automated identification of missing or incomplete clinical information and development of workflows that allow staff to efficiently address identified deficiencies.
• Develop and maintain integrations and datasets supporting multiple business intelligence platforms.

Automation and Process Improvement

• Identify manual, repetitive, or data-intensive workflows that can be automated.
• Develop scripts, applications, API integrations, and workflow automation solutions to improve efficiency and data accuracy.
• Use Python, SQL, Microsoft Power Platform, APIs, and related tools to automate data movement and business processes.
• Work with operational teams to measure the effectiveness of automated workflows and identify opportunities for continued improvement.

Artificial Intelligence and Emerging Technology

• Develop and maintain the data infrastructure and integrations necessary to support approved artificial intelligence and machine-learning applications.
• Integrate approved AI services and APIs with organizational systems and workflows when appropriate.
• Prepare, structure, validate, and govern organizational data used by AI-enabled applications.
• Assist with development of automated workflows incorporating generative AI, natural-language processing, predictive analytics, or other emerging technologies.
• Evaluate emerging data, automation, and AI technologies and recommend appropriate use cases based on organizational needs.
• Establish appropriate controls for AI-enabled workflows involving PHI or other sensitive organizational information.
• Assist with measurement of AI initiatives, including utilization, workflow impact, accuracy, efficiency, and other defined performance indicators.

Data Governance, Security, and Reliability

• Maintain data architecture, mapping, interface, pipeline, and technical-process documentation.
• Develop and implement data-quality standards, validation rules, monitoring, and exception reporting.
• Support organizational data governance including data ownership, definitions, lineage, access, retention, and appropriate use.
• Ensure data solutions comply with HIPAA, organizational security standards, privacy requirements, and applicable regulatory requirements.
• Apply appropriate access controls, logging, auditing, and security practices to systems containing PHI or other sensitive information.
• Monitor production data workflows and proactively identify and correct failures or data-quality issues.

Physical Requirements

• Prolonged periods of sitting and computer work while providing technical support and documenting service requests.
• Ability to stand, walk, bend, and reach when installing or troubleshooting equipment.
• Manual dexterity to operate computer hardware, mobile devices, and standard office equipment.
• Ability to install, connect, and configure workstations, peripherals, and network devices.
• Ability to lift and move computer equipment and related materials up to 25–40 pounds occasionally.
• Ability to work in confined spaces such as wiring closets, server rooms, and under desks when servicing equipment.
• Visual acuity sufficient to read technical documentation, monitor screens, and configure systems.
• Ability to travel between clinical locations or departments as needed.
• Ability to respond to urgent technical issues and provide support outside normal business hours when required.