Business Intelligence Analyst Senior

About the role

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.

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 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.
• 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 how the team uses Fabric as adoption expands.
• 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 reports and datasets you own, escalating systemic issues to the Application Manager.
• Own end-to-end ELT (Extract, Load, Transform) 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 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.