BI Engineer

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. #J-18808-Ljbffr Ventois Inc.