Sr. BI Engineer

Facility Corporate - Enterprise Allocations Schedule - Shift - Hours Full Time - Remote The Senior BI Engineer will design, develop, and support the enterprise BI and analytics platform, delivering scalable and high-performance reporting solutions across clinical, operational, and financial domains. This role is responsible for building and optimizing end-to-end BI solutions, including data modeling, semantic layer development, and dashboard delivery, ensuring consistency, accuracy, and performance across all reporting assets. The role will design and implement star/snowflake schema data models, develop reusable data marts, and define standardized business metrics to support a governed analytics framework. The Senior BI Engineer will build and maintain Power BI solutions, including DAX measures, Power Query transformations, and optimized data models, while ensuring efficient query performance and scalable report design. This position will work closely with data engineering, application teams, and business stakeholders to translate complex requirements into technical BI solutions. Responsibilities include writing advanced SQL queries and optimizing reporting datasets for performance and usability. The Senior BI Engineer will also enforce BI development standards, support data governance initiatives, and contribute to the establishment of a unified semantic layer to enable consistent and trusted reporting across the organization. ESSENTIAL DUTIES AND RESPONSIBILITIES Design and develop enterprise BI solutions using Power BI, including scalable dashboards and reporting models. Build and maintain dimensional data models (star/snowflake schemas) and reusable datasets for enterprise reporting. Develop and optimize semantic models with standardized business definitions, KPIs, and measures. Write advanced SQL queries for data extraction, transformation, and reporting logic. Develop complex DAX measures and Power Query (M) transformations to support analytical requirements. Design and implement advanced Power BI visualizations, including drill-through reports, dynamic tooltips, decomposition trees, key influencers, field parameters, What-If analysis, and paginated reports. Develop advanced interactive visuals such as custom visuals (Power KPI Visual, xVizSuite, OKViz visuals, Zebra BI visuals), KPI scorecards, waterfall charts, funnel charts, heat maps, trend analysis visuals, and variance analysis dashboards. Build highly interactive reporting experiences using bookmarks, buttons, slicer panels, synced slicers, and dynamic page navigation. Optimize dashboard performance and user experience through efficient modeling, aggregations, and visualization best practices. Translate business requirements into technical BI specifications and end-to-end reporting solutions. Enforce BI development standards, naming conventions, and documentation practices. Support data governance by ensuring consistency, accuracy, and alignment of enterprise metrics. Troubleshoot and resolve BI/reporting issues and ensure data reliability across dashboards. Manage Power BI Service administration, including workspace setup, access control, security roles, and capacity utilization. Oversee dataset refresh schedules, gateway configurations, and deployment pipelines in Power BI Service. Monitor and optimize Power BI environment performance, usage, and governance compliance. QUALIFICATIONS EDUCATION Bachelor’s degree in Computer Science, Data Science, Information Systems, Health Informatics, or related field required. Master’s degree in Data Science, Business Analytics, or related discipline preferred. EXPERIENCE 10+ years of experience in BI, Data Analytics, or Data Engineering. Strong experience with Power BI development and enterprise dashboarding. Expertise in SQL, data modeling (star/snowflake), DAX, and Power Query. Experience with Power BI Service administration and deployment. Proven ability to translate business requirements into scalable BI solutions. KNOWLEDGE, SKILLS AND ABILITIES Strong knowledge of BI concepts and dimensional modeling (star/snowflake) Advanced Power BI skills (DAX, Power Query, dashboard development) Strong SQL skills for querying and performance tuning Experience with Power BI Service administration and deployment Ability to design scalable, high-performance BI solutions Strong analytical and problem-solving skills Ability to translate business needs into technical solutions Strong communication and stakeholder collaboration skills TYPICAL WORKING CONDITIONS Primarily office-based or remote/hybrid work environment Extended periods working on a computer and analyzing data Standard business hours with occasional flexibility based on project deadlines May require occasional meetings with business and technical stakeholders across time zones Fast-paced environment with multiple concurrent priorities and deadlines Limited travel, if any, depending on organizational needs OTHER PHYSICAL REQUIREMENTS Vision Sense of sound Sense of touch PERFORMANCE REQUIREMENTS Adhere to all organizational information security policies and protect all sensitive information including but not limited to ePHI and PHI (Protected Health Information) in accordance with organizational policy, Federal, State, and local regulations. The foregoing description is not intended and should not be construed to be an exhaustive list of all responsibilities, skills, effort or working conditions associated with the job. It is intended to be an accurate reflection of the general nature of level of the job. #J-18808-Ljbffr Pediatric Associates