Skip to content

Open nowPosted 6 days ago

Business Intelligence Analyst Senior

Illuminate USA44 open roles

Where
OH - Pataskala
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowBusiness Intelligence Analyst SeniorIlluminate USA · OH - Pataskala
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Illuminate USA's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

8.5% of postings close within 7 days. Measured by our own scanner across the market. Illuminate USA postings stay open a median of 29 days.

Share of postings closed within
  1. 1.8%1 day
  2. 4.0%3 days
  3. 8.5%7 days
  4. 15.4%14 days
  5. 34.1%30 days
This job: posted 6 days ago

Illuminate USA median: 29 days open

The posting

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.

Key Responsibilities

BI Development & Delivery

  • 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.

Peer Support & Knowledge Sharing

  • 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.

Data Governance Support

  • 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.

Collaboration & Stakeholder Engagement

  • 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 (Change Request Form, CAB review) for changes affecting reports, datasets, or data platforms.

Qualifications

Required

  • 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, 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 (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) and, ideally, operational/OT systems such as MES, SCADA, or WMS.
  • Strong analytical, problem-solving, and communication skills, with the ability to explain technical concepts to non-technical business users.

Preferred

  • 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.

At Illuminate USA, we are committed to fostering an inclusive and diverse workplace. We proudly embrace equal opportunity for all, ensuring that all qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by law. Your unique background and experiences are valued here, as we believe they strengthen our team and drive our mission forward.

Illuminate is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Illuminate USA's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on Illuminate USA's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    Illuminate USA's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.