Strategic BI Analyst — Power BI, SQL & Data Modeling

GEMCORE; Hudson (OH); On-site; USD 90,000 - 130,000; Full time

Job summary

GEMCORE seeks an experienced BI Analyst to design, develop, and deliver reporting solutions using Power BI and SQL across enterprise systems. You will build semantic models and pipelines within Microsoft Fabric to enable self-service analytics and trusted data delivery.

Responsibilities include collaborating with stakeholders, optimizing data models, and guiding end users with documentation and training. Bachelor's degree and 7+ years' experience required.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• 7+ years of experience as a BI Analyst, BI Developer, or Data Analyst.

Responsibilities

• Collaborate with stakeholders to translate business requirements into technical reporting.
• Design, develop, and maintain dashboards, reports, and scorecards using Power BI.
• Build and optimize semantic models for enterprise reporting and self-service analytics.
• Develop complex SQL queries, views, and stored procedures for data extraction and analysis.
• Analyze data to identify trends, patterns, and business opportunities.
• Ensure data accuracy and availability across reporting platforms.
• Understand database relationships and data lineage across multiple systems.
• Assist with data platform security and access management within Microsoft Fabric.
• Support end users with training, troubleshooting, and documentation.
• Recommend best practices for reporting, data modeling, performance, and data governance.

Skills

SQL

DAX

Data modeling

Semantic models

Relational databases

Dimensional modeling

Data warehousing

Power BI

Interpersonal skills

Communication skills

Troubleshooting

Education

Bachelor's degree in Computer Science or Information Systems

Tools

Power BI

Microsoft Fabric

Lakehouse

Warehouse

Data Factory Pipelines

Semantic Models

Job description

GEMCORE seeks an experienced BI Analyst to design, develop, and deliver reporting solutions using Power BI and SQL across enterprise systems. You will build semantic models and pipelines within Microsoft Fabric to enable self-service analytics and trusted data delivery.

Responsibilities include collaborating with stakeholders, optimizing data models, and guiding end users with documentation and training. Bachelor's degree and 7+ years' experience required.