Business Intelligence Analyst Senior

Job Description Located in the heart of Central Ohio, Illuminate USA is transforming solar panel manufacturing from our cutting-edge facility in Pataskala. As a new standalone joint venture established by two global leaders in renewable energy, we’ve rapidly grown to over 1,500 associates and are now fully operational in our 1.1 million-square-foot factory. Our vision is to establish one of the largest solar panel manufacturing operations in the Western Hemisphere.

This is an exciting time to join Illuminate USA as we continue to grow and innovate. We’re not just building solar panels—we’re building a team of dedicated, passionate associates eager to make a real impact. If you’re looking to be part of a collaborative, people-focused, and forward-thinking workplace, we want to hear from you! We offer competitive pay, comprehensive benefits, and continuous opportunities for career growth.

Come join us on this journey to create a brighter, more sustainable future in the Columbus area. Illuminate USA is looking for a Senior BI Analyst to serve as a senior individual contributor on the Business Intelligence team, building and maintaining the dashboards, reports, and semantic models that turn plant floor and enterprise data into trusted, decision-ready information. This role takes on the more complex builds and data modeling work on the team, serves as the team's deep technical resource on Microsoft Fabric, and is a go-to resource for other analysts on Power BI and DAX questions, but does not carry the day-to-day workload assignment or people leadership responsibilities held by the Lead BI Analyst.

You will spend most of your time in Power BI, Microsoft Fabric, SQL, and the underlying data models, partnering with Operations, Supply Chain, Finance, Quality, and Plant leadership, as well as IT's Infrastructure, Cybersecurity, and Applications teams, to connect data from ERP, MES/OT systems, and the warehouse management system (WMS) into governed, reusable BI assets.

• 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 in your area, following the team's data modeling standards.
• Translate business requirements into technical specifications, wireframes, and report designs; run user acceptance testing with business stakeholders before release.

• Act as a go-to resource for other BI analysts on Power BI, DAX, and data modeling questions; review peers' report builds informally when asked.
• Help onboard new BI analysts and contractors to the team's tools, standards, and current 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 the BI assets you build.
• Maintain metric definitions and calculation logic for reports you own in the enterprise metrics library, keeping them accurate and free of duplication.
• Contribute to the data catalog and lineage documentation (e.g., Microsoft Purview or equivalent) for datasets and reports you maintain.
• 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 that build self-service BI adoption.
• Collaborate with the…