Business Intelligence (BI) Analyst - Onsite/Hybrid role

GEMCORE’s continued success has earned national recognition through Inc. Magazine’s Fastest Growing‑Growing Companies and Cleveland Plain Dealer Top Workplace awards for seven consecutive years. We are seeking a mission-driven leader who shares our passion for delivering exceptional patient care, operational excellence, and best-in-class diabetes support.

GEMCORE is seeking an experienced and strategic BI Analyst to focus on the design, development, and delivery of reporting and analytics solutions using Power BI, relational databases, semantic models, and ad hoc data requests. This role will partner closely with business stakeholders to transform data into actionable insights through scalable reporting and analytics solutions.

Key Responsibilities:

• Collaborate with stakeholders to understand business requirements and translate them into technical reporting

• Design, develop, and maintain interactive dashboards, reports, and scorecards using Power BI

• Build and optimize semantic models to support enterprise reporting and self-service analytics

• Develop complex SQL queries, views, and stored procedures to extract, transform, and analyze data

• Perform data analysis to identify trends, patterns, correlations, anomalies, and business opportunities

• Ensure data accuracy, integrity, consistency, and availability across reporting platforms

• Understand and analyze database relationships and data lineage across multiple systems and sources

• Familiarity with Microsoft Fabric solutions, including pipelines, workspaces, lakehouses, warehouses, semantic models, and related artifacts is preferred

• Assist with data platform security and access management within Microsoft Fabric

• Support end users through training, troubleshooting, documentation, and ongoing technical assistance

• Recommend and implement best practices related to reporting, data modeling, performance optimization, and data governance