Business Intelligence Analyst Senior

Illuminate USA•Pataskala, OH

About The Position

Illuminate USA is seeking a Senior BI Analyst to serve as a senior individual contributor on the Business Intelligence team. The role builds and maintains dashboards, reports, and semantic models that turn plant-floor and enterprise data into trusted, decision-ready information. It handles complex development and data-modeling work, serves as the team's technical resource on Microsoft Fabric, and supports other analysts with Power BI and DAX questions. It does not carry the Lead BI Analyst's day-to-day workload assignment or people leadership responsibilities. The analyst will work primarily with Power BI, Microsoft Fabric, SQL, and underlying data models, partnering with Operations, Supply Chain, Finance, Quality, Plant leadership, and IT teams. The role connects ERP, MES/OT, and WMS data into governed, reusable BI assets. It also supports data governance, stakeholder engagement, BI adoption, and platform collaboration.

Requirements

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

Nice To Haves

  • Microsoft Fabric or Power BI certification, such as PL-300 or DP-600.
  • Experience in a manufacturing or industrial environment, including exposure to plant-floor or OT data.
  • Experience with operational or OT systems such as MES, SCADA, or WMS.
  • Exposure to data governance concepts, data catalogs, or metadata-management tools such as Microsoft Purview, Collibra, or Informatica.
  • Prior experience informally mentoring other analysts or reviewing their work.

Responsibilities

  • Design, build, and maintain Power BI dashboards, self-service reports, and executive scorecards for operations, supply chain, quality, and other business functions.
  • Develop and maintain semantic layers, dataset designs, and DAX calculations in accordance with team data-modeling standards.
  • Translate business requirements into technical specifications, wireframes, and report designs, and conduct user acceptance testing with business stakeholders.
  • Serve as the team's technical lead on Microsoft Fabric by designing and building lakehouses, data pipelines, Dataflows Gen2, and semantic models, and establishing patterns for Fabric adoption.
  • 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 to the Application Manager.
  • Own end-to-end ELT processes for BI data sources, including designing, building, and maintaining pipelines that feed Fabric lakehouses and semantic models.
  • Support other BI analysts with Power BI, DAX, and data-modeling questions and informally review report builds when asked.
  • Help onboard new BI analysts and contractors to the team's tools, standards, and current project backlog.
  • Follow and help refine BI development standards for naming conventions, folder structure, version control, and documentation.
  • Apply enterprise data governance standards, including master data definitions, metadata, and data lineage, to BI assets.
  • Maintain accurate, non-duplicative metric definitions and calculation logic for owned reports in the enterprise metrics library.
  • Contribute to data catalog and lineage documentation, such as Microsoft Purview or an equivalent, for maintained datasets and reports.
  • Flag data quality issues to the appropriate data steward or system owner and track remediation.
  • Lead requirements-gathering sessions and demos with business users, and support office hours and enablement sessions to promote self-service BI adoption.
  • Collaborate with Infrastructure and Applications teams on data-source connectivity, refresh scheduling, and BI platform performance.
  • Support BI participation in IT Change Management, including Change Request Forms and CAB reviews, for changes affecting reports, datasets, or data platforms.

Benefits

  • Competitive pay
  • Comprehensive benefits
  • Continuous opportunities for career growth
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service