Sr. Data Engineer - REMOTE

• Design, develop, and maintain scalable data pipelines to extract, transform, and load (ETL) data from FHIR APIs into SQL databases.
• Work closely with stakeholders to understand data requirements and ensure data quality and integrity.
• Develop analytics solutions and dashboards using Power BI to support business insights.
• Optimize data workflows and troubleshoot data-related issues.
• Collaborate with cross-functional teams including data scientists, analysts, and business users. .
• Drive project and technology goals in compliance with organizational objectives.

• Engineering Degree BE/ME/BTech/MTech/BSc/MSc.
• Technical certification in multiple technologies is desirable.

• Strong hands-on experience with FHIR standards and data structures.
• Proficiency in Python for data engineering tasks.
• Expertise in SQL and data analytics.
• Experience with Power BI for data visualization and reporting.
• Solid understanding of ETL processes and data pipeline architecture
• Since standard commercial reporting tools do not support querying from FHIR, we are looking to replicate our FHIR data into a SQL (Postgres) data structure
• There are many complexities in this transition including: Handling repeating (and nested repeating) structures in FHIR (e.g., do some specific rows get promoted to the top of the structure? Do you create child tables for these? Do you keep the JSON structure in a field in the target schema?), Multiple coding on the same concept, Denormalization for performance reasons
• The technical approach is to use Python to transform the data with reusable script segments for different FHIR data types
• The logical work is to make the choices above informed partly by reporting priorities above
• Experience in healthcare data systems or interoperability standards.

PSRTek