Job description 

Essential Functions

• Extract data from on-prem databases using appropriate tools and techniques.
• Transform and clean the data to ensure its suitability for PowerBI analysis.
• Build and maintain data pipelines for regular data refresh in PowerBI.
• Monitor and maintain Azure Synapse pipelines for on-prem data extraction and transformation.
• Collaborate with analysts to understand data requirements and model design.
• Troubleshoot data pipeline issues and optimize data processing performance.
• Collaborate with Business Analysts to understand data requirements and refine pipeline configurations.
• Stay updated on Azure Synapse advancements and explore new data integration possibilities.
• All other duties and responsibilities as assigned.

Skills needed to be successful

• Strong understanding of laboratory workflows and processes
• Familiarity with relevant laboratory procedures and tests
• Awareness of regulatory requirements and compliance standards

Required Experience & Education

• Bachelor’s degree in Engineering, Computer Science or related discipline or equivalent experience
• At least 5 years of experience with the following or similar:
  • Data Engineering and Data Management: Azure Data Lake Storage, Azure Monitor, Azure Data Factory, Azure Stream Analytics, Azure Data Catalog
  • Programming skills: Expertise in languages such as Python or R for data manipulation, model development, and analysis.
• RDBMS design (SQL Server, T-SQL, Oracle, etc.)

Preferred Experience & Education

• Knowledge of scientific data software, medical devices, or healthcare software

Supervisory Responsibilities

• None