Data Engineer

The Data Engineer role supports Neighborhood Family Practice by designing and maintaining secure, scalable data infrastructure that brings together clinical, operational, financial, quality, and value-based care data for reporting, analytics, and regulatory needs.

Key Responsibilities

• Design, develop, test, deploy, and maintain automated data pipelines across Epic’s financial, operational, quality, and partner data sources, including NetSuite, PayCom, and Pioneer.
• Build and maintain scalable data models, data warehouses, and curated datasets that support Power BI reporting and advanced analytics.
• Create automated workflows for data extraction, transformation, validation, reconciliation, and monitoring.
• Implement data-quality controls to detect missing, duplicate, inconsistent, or inaccurate information.
• Troubleshoot dataflow, interface, integration, and reporting issues in collaboration with clinical, operational, and technical teams.
• Work with data analysts and business leaders to convert reporting requirements into durable technical solutions.
• Maintain technical documentation, including data dictionaries, source-to-target mappings, business rules, pipeline dependencies, and system workflows.
• Apply HIPAA, privacy, information-security, and role-based access requirements throughout the data lifecycle.
• Monitor pipeline performance, investigate failures, and implement solutions that reduce manual intervention.
• Provide education to staff on data definitions, collection standards, system workflows, and downstream impacts of documentation practices.
• Support data governance, change management, testing, and validation activities for new systems and reporting initiatives.
• Perform other duties as assigned.

Required Qualifications

• 3+ years of relevant experience.
• Advanced SQL, including query optimization and relational data modeling.
• Experience building automated ETL or ELT pipelines.
• Experience using Python for data processing, validation, scripting, and automation.
• Experience supporting data warehouses, reporting databases, or analytics platforms.
• Knowledge of data-quality controls, testing, reconciliation, and technical documentation.
• Understanding of healthcare, privacy, and security requirements.
• Education: Bachelor’s degree in computer science, Information Technology, or a similar field.

Preferred Qualifications

• Experience with Microsoft Azure and Azure Data Factory.
• Experience developing semantic models or datasets for Microsoft Power BI.
• Experience with Epic, OCHIN, or comparable electronic health record data.
• Familiarity with healthcare interoperability standards and clinical terminology.
• Experience with payer, claims, quality-measure, UDS, population health, or value-based care data.
• Experience working in an FQHC, community health center, or ambulatory healthcare environment.

Tools and Technologies

• SQL, Python, ETL, ELT, Power BI
• Microsoft Azure, Azure Data Factory
• Epic, NetSuite, PayCom, Pioneer, OCHIN
• Microsoft Power BI

Location and Salary

• Location: Cleveland, OH (onsite)
• Compensation: USD 75,000 - 85,000 per year

Essential Physical Demands and Work Environment

• Ability to communicate effectively verbally and in writing, including through electronic communication devices.
• Ability to sit, stand, bend, and walk for extended periods of time; occasional lifting of up to 30 lbs.
• Willingness to travel locally between sites; driver’s license and automotive insurance preferred.