Data Engineer

Duties The role is responsible for the development and maintenance of an in-house C# application developed to integrate into various Electronic Medical Record (EMR) and Practice Management (PM) systems. Integration technologies include Microsoft SQL, MySQL, Oracle SQL, Databricks, web services, and flat files (e.g., CSV, JSON, XML). The application is often installed within the practice's environment on a hosted machine, which requires additional knowledge of basic infrastructure such as using Virtual Private Network (VPN) clients and remote screen technologies. Once the application is installed and configured, the position is responsible for the analysis and transformation of raw data into discrete data points within an internal cloud-hosted Microsoft SQL environment. The transformation is achieved by an Extract/Transform/Load (ETL) workflow. After the transformation is complete, they will then work with clinical personnel at the practice to perform various data Quality Assurance (QA) tasks to verify data quality. Primary Responsibilities Develop and maintain the in-house C# application. Develop and maintain data transformation and ETL procedures. Investigate and map database or other repositories to determine where data points may be found when presented with a new EMR/PM platform. Write queries and scripts to extract mapped data. Coordinate and install the application into medical practices' environments. Identify operational issues and defects that cause data flow to be interrupted or impacted. Learn to navigate several EMR and PM systems for data validation. Serve as third-level support for the service desk to troubleshoot clinical and technical issues. Interact with clinical personnel to understand where data resides in patient charts, and map to the internal data model. Facilitate internal validation of imported data with clinical teams. Facilitate external validation with healthcare providers. Skills A deep knowledge of and experience with C# development in .NET, including class inheritance, dependency injection, and ADO.NET. Ability to write complex SQL queries (Microsoft T-SQL or Databricks SQL) to support an ETL process, daily development, and troubleshooting/issue resolution. Ability to create and schedule notebooks within Databricks to facilitate data ingestion, transformation, or export. Basic familiarity with infrastructure technologies such as VPN and remote screens. Ability to track product implementation on a practice-by-practice basis, and shepherd along integration and adoption. Ability to extract data via API calls to Cloud Services and troubleshoot with applications such as Postman. Ability to explore an unknown SQL database to Client and map various data points. Adapt to speaking both clinically and technically. Present final work product of platform integration back to stakeholders. Ability to maintain applications through monitoring and performance tuning. Experience troubleshooting applications and an understanding of when the issue needs escalation beyond primary skillset (e.g., issues with Active Directory, network traffic routing, etc.). Comfort escalating troubleshooting to both internal technical resources as well as external resources. Experience creating and maintaining containerization platforms such as Azure Kubernetes Service. Experience containerizing applications using both Windows and Linux containers. Experience with both legacy .Net Framework applications and modern .Net Core applications. Establishing deployment pipelines and release management. Ability to perform basic-intermediate database management tasks such as performance monitoring and database backup/transaction log restores. Ability to design and implement large software projects spread among multiple developers. Prior experience with scripting automation through Microsoft PowerShell. Note: Sponsorship is not provided for this opening. Candidates must now and in the future be legally eligible to work in the US for any employer.

Created: 2026-03-04