I

Illuminate USA

Domestic manufacturer of bifacial solar panels

Senior Business Intelligence Analyst

Business IntelligenceConfirmed live in the last 24 hours
Full-timePataskala, OH, USANo salary listedIn-person

About the Job

Requirements

  • A 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, with at least 1 year working directly in Microsoft Fabric.
  • Strong SQL skills and experience with data warehousing, data modeling, and ETL/ELT concepts.
  • Experience with cloud computing platforms such as Azure and Azure-based data engineering tools and services such as Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake Storage.
  • Hands-on expertise with Power BI, including DAX, Power Query, and 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 such as Oracle and, ideally, operational/OT systems such as MES, SCADA, or WMS.
  • Strong analytical and problem-solving skills, and the ability to explain technical concepts to non-technical business users.

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 the role's 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 by designing and building lakehouses, data pipelines, Dataflows Gen2, and semantic models, and setting usage patterns 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 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 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, and informally review peers' 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 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 built.
  • Maintain metric definitions and calculation logic for owned reports in the enterprise metrics library, keeping them accurate and free of duplication.
  • Contribute to data catalog and lineage documentation, such as Microsoft Purview or equivalent, for maintained datasets and reports.
  • 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 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, including Change Request Form and CAB review, for changes affecting reports, datasets, or data platforms.

Desired Qualifications

  • 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.
  • Exposure to data governance concepts, data catalogs, or metadata management tools such as Microsoft Purview, Collibra, or Informatica.
  • Prior experience informally mentoring or reviewing the work of other analysts.

About the Company

Illuminate USA

Domestic manufacturer of bifacial solar panels

Illuminate USA is an American advanced-manufacturing company that produces bifacial solar panels for both residential rooftop and utility-scale projects at a single large facility in Pataskala, Ohio. It assembles panels domestically using American-made materials and components—including solar glass from a domestic supply partnership—and describes its Etna Parkway plant as the largest single-site solar panel manufacturing facility in the United States. The company trains workers for production roles new to American manufacturing and emphasizes a diverse, inclusive workforce. What sets Illuminate USA apart is its focus on onshoring the solar supply chain, pairing advanced bifacial panel technology with domestically sourced inputs. The goal is to develop renewable energy solutions through domestic solar manufacturing while building a durable American clean-energy supply chain and workforce.

Company size
Not listed
Company stage
Not listed
Total funding
Not listed
Headquarters
Not listed
Founded
Not listed

Recently Posted Jobs

Explore more opportunities at Illuminate USA

See more jobs