Business Intelligence Analyst Senior

Illuminate USA•Pataskala, OH

2d•Onsite

About The Position

Illuminate USA is seeking a Senior BI Analyst to join their Business Intelligence team. This role is a senior individual contributor responsible for building and maintaining dashboards, reports, and semantic models using plant floor and enterprise data. The analyst will focus on complex builds and data modeling, serving as a technical expert in Microsoft Fabric and a resource for Power BI and DAX questions. The position involves partnering with various business and IT teams to integrate data from ERP, MES/OT, and WMS systems into governed BI assets. The company is a rapidly growing solar panel manufacturer in Central Ohio, established by leaders in renewable energy, with a vision to be a major player in the Western Hemisphere. They emphasize a collaborative, people-focused, and forward-thinking workplace with competitive compensation and benefits.

Requirements

Bachelor's degree in Business, Computer Science, Data Science, Information Systems, or a related field, or equivalent practical experience.
3+ years of experience in business intelligence or data analytics.
Hands-on Power BI report and data model development.
At least 1 year working directly in Microsoft Fabric.
Strong SQL skills.
Experience with data warehousing, data modeling, and ETL/ELT concepts.
Experience with cloud computing platforms (Azure) and Azure-based data engineering tools and services (e.g., Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage).
Hands-on expertise with Power BI (DAX, Power Query, dataset and semantic model design).
Deep, hands-on experience with Microsoft Fabric, including lakehouse architecture, data pipelines, Dataflows Gen2, OneLake, semantic models, and Direct Lake versus import mode trade-offs.
Experience working with data from ERP systems (e.g., Oracle).
Experience with operational/OT systems such as MES, SCADA, or WMS.
Strong analytical, problem-solving, and communication skills.
Ability to explain technical concepts to non-technical business users.

Nice To Haves

Microsoft Fabric or Power BI certification (e.g., PL-300, DP-600).
Experience in a manufacturing or industrial environment, including exposure to plant floor or OT data.
Exposure to data governance concepts, data catalogs, or metadata management tools (e.g., Microsoft Purview, Collibra, or Informatica).
Prior experience informally mentoring or reviewing the work of other analysts.

Responsibilities

Design, build, and maintain dashboards, self-service reports, and executive scorecards in Power BI covering operations, supply chain, quality, and other business functions.
Develop and maintain semantic layers, dataset designs, and DAX calculations for reports, following team data modeling standards.
Translate business requirements into technical specifications, wireframes, and report designs; run user acceptance testing with business stakeholders.
Serve as the team's technical lead on Microsoft Fabric, designing and building lakehouses, data pipelines, Dataflows Gen2, and semantic models, and setting patterns for team usage.
Optimize Fabric capacity usage, workspace and item architecture, and Direct Lake versus import model design for performance and cost.
Troubleshoot and resolve data quality, performance, and refresh issues in owned reports and datasets, escalating systemic issues.
Own end-to-end ELT processes for BI data sources, including designing, building, and maintaining data pipelines that feed Fabric lakehouses and semantic models.
Act as a go-to resource for other BI analysts on Power BI, DAX, and data modeling questions; review peers' report builds informally.
Help onboard new BI analysts and contractors to the team's tools, standards, and project backlog.
Follow and help refine the team's BI development standards, including naming conventions, folder structure, version control, and documentation practices.
Apply enterprise data governance standards, including master data definitions, metadata, and data lineage, to BI assets.
Maintain metric definitions and calculation logic for owned reports in the enterprise metrics library.
Contribute to the data catalog and lineage documentation for datasets and reports maintained.
Flag data quality issues found during report development to the appropriate data steward or system owner and track remediation.
Run requirements-gathering sessions and demos with business users, and support office hours and enablement sessions.
Collaborate with Infrastructure and Applications teams on data source connectivity, refresh scheduling, and performance for BI platforms.
Support BI's participation in the IT Change Management process for changes affecting reports, datasets, or data platforms.