Data Analytics Engineer

100% Remote Anywhere

Shift: Monday through Friday 8am - 5pm EST

You will be responsible for extracting, copying and transforming clinical data and loading it into Azure SQL databases and data warehouses, supporting multiple Performance Partnership consulting projects.

At ***, our vision is to relentlessly reimagine healthcare, one diagnosis at a time.

You will be a part of the Performance Partnership team and report to the Senior Manager of Analytics, responsible for leading the development of Microsoft Azure-based automation (data collection, data quality, data transformation, data integration, business intelligence).

Responsibilities

1. Develop and implement automation roadmap for Azure cloud data processing
2. Define, develop, maintain and document database and warehouse architecture
3. Work with external customers to extract data from various source systems (LIS, time management and financial)
4. Leverage healthcare standards to integrate seamlessly into clinical systems and workflows, robustly addressing data privacy, security, authentication, auditing and other essential functions
5. Keep abreast of emerging technologies and standards inside and outside of the healthcare space and recommend technologies to best fit business needs

Qualifications

1. Bachelor of Science degree with 5+ years of experience OR Master of Science degree with 3+ years of experience
2. Deep understanding of ETL, ELT pipelines, with the ability to design, optimize and orchestrate (SSIS, Data Factory)
3. Significant expertise with relational DBMSs (Azure SQL, SQL Server), DDL, DML, Index management and query optimization
4. Experience with CI/CD platforms (Git, Azure DevOps)
5. Experience in Microsoft Azure cloud resource management, cloud architecture and cloud security

Preferred Qualifications

1. Experience building and maintaining Azure Analysis Services (Tabular Models)
2. Experience working with highly controlled health data (HIPAA, GDPR)
3. Azure Storage – data lake scripting (automating movement of data using Azure functions or automation scripts)
4. Power BI and DAX programming experience (star schema data modeling, measure design)
5. Previous clinical laboratory analytics experience