BI Engineer

Ventois Inc.; Shrewsbury (MA); On-site; USD 80,000 - 120,000; Full time

Job summary

A healthcare technology company in Shrewsbury is seeking a professional to design and implement data integration solutions. The role involves executing SQL queries, collaborating with stakeholders, and ensuring compliance with healthcare data standards. Candidates should have extensive experience with healthcare data and proficiency in tools like Snowflake and Power BI. This position focuses on optimizing data models and ETL pipelines while maintaining data integrity and performance.

Qualifications

• Extensive experience in healthcare data integration and workflows.
• Knowledge of HL7 standards and compliance with healthcare data privacy.
• Proven ability to collaborate with stakeholders and gather requirements.

Responsibilities

• Design and implement data exchange between healthcare information systems.
• Execute SQL and SnowSQL queries for data extraction and transformation.
• Perform testing and validation of migrated reports.

Tools

SQL

SnowSQL

Snowflake

Qlik

Power BI

Tableau

Job description

Job Responsibilities

• Healthcare Data Integration: Design, implement, and troubleshoot data exchange between healthcare information systems using the HL7 standard to ensure accurate, compliant, and seamless data flow.
• Extensive experience working with healthcare data and understanding healthcare workflows.
• Collaboration & Requirements Gathering: Work closely with operational, clinical, and business stakeholders to understand requirements, define key metrics, and translate business needs into effective BI solutions.
• Execute SQL and SnowSQL queries to extract, transform, and load data from Snowflake and other healthcare data repositories, ensuring high data integrity and performance.
• Perform rigorous testing and validation of migrated reports to Qlik and Power BI and ensure fidelity, accuracy, and performance compared to the original Tableau versions.
• Maintain compliance with healthcare data privacy standards and participate in change control and governance processes for BI assets.
• Work in Agile sprints to plan, prioritize, and deliver migration milestones, including peer reviews, QA testing, and production deployment.
• Data Modeling & ETL: Build and manage complex data models and ETL pipelines to integrate data from various sources, including databases, APIs, and flat files.
• Document business logic, metadata mappings, and migration strategies for each report to support QA, training, and long-term maintenance by downstream teams.
• Conduct performance tuning and optimization for large datasets and slow-loading dashboards, leveraging aggregations, query folding, and incremental refresh strategies.
• Monitor usage metrics and integrated feedback loops to prioritize enhancements and address usability issues proactively.
• Implement role-level and row-level security (RLS) strategies to ensure HIPAA-compliant access control across dashboards for physicians, administrators, and finance leaders.