Power BI Specialist

Challenge Manufacturing
Grand Rapids, MI
Who We Are

Challenge Manufacturing’s mission is to manufacture with operational excellence by empowering our employee-owners. As a leading tier 1 supplier of complex metal assemblies for the global automotive industry, we drive innovative solutions for future mobility. We believe the best ideas come from individual unique perspectives. These ideas combined with the teamwork of industry leaders allow us to accomplish any challenge. Our team members take pride in the work we do and embody our core values of safety, ownership, and teamwork every day; they are the true driving force in our operations.

Challenge is proud to be one of the largest employee-owned automotive companies in North America. One of the many benefits of joining the Challenge team is the ESOP program. This program allows Challenge to give shares of the Company to all employee-owners annually. These shares are an additional retirement benefit that will continue to grow during your time at Challenge. Being part of an ESOP means our employee-owners share in Challenge’s success!

Challenge is #QualityDriven and #PeoplePowered!

Who We Want

The Power BI Analyst will play a key role in developing and optimizing data reporting and visualization tools to support critical manufacturing, productivity, and business processes. This position requires a strong foundation in data analytics, reporting, and cross-functional collaboration to deliver actionable insights that drive operational efficiency and informed decision-making.

What You'll Do

  • Design, develop, and maintain Power BI dashboards and reports based on stakeholder requirements
  • Collaborate with cross-functional teams (e.g., operations, finance, IT) to understand data needs and reporting objectives
  • Gather, clean, and integrate data from various sources, ensuring high data quality and integrity
  • Write and optimize SQL queries to retrieve data efficiently from relational databases
  • Conduct data analysis and interpret trends or patterns to inform business decisions
  • Develop and document standardized reporting processes and best practices
  • Monitor and audit existing BI solutions to ensure accuracy, performance, and scalability
  • Provide support and training to users on Power BI dashboards and tools
  • Perform ad hoc analysis and reporting requests as needed
  • Support data governance initiatives and help ensure compliance with data security standards
  • Other duties may be assigned by management

When And Where

This will be a 1st Shift / 830AM-5PM M-F position located at our Plant in Walker, MI.

Occasionally, this may require you to arrive early, stay late, or work on weekends, outside of our regular hours, to ensure we successfully meet customer needs, deadlines, or urgent requests.

What You Need To Have

  • Experience in a manufacturing or industrial environment
  • Familiarity with DAX (Data Analysis Expressions) and Power Query
  • Knowledge of cloud-based data platforms such as Azure Synapse or Data Lake
  • Experience with Python or R for data analysis or automation
  • Certification in Power BI, SQL, or data analytics (e.g., Microsoft Certified: Data Analyst Associate)
  • Bachelor’s degree in Computer Science, Information Systems, Business Analytics, or a related field
  • Minimum of 2 years of experience in a data analyst or BI role
  • Hands-on experience with Power BI (building reports, dashboards, DAX formulas)
  • Strong proficiency in Microsoft Excel (including advanced formulas, pivot tables, macros)
  • Experience with SQL Server and writing SQL queries, stored procedures, and views
  • Understanding of data modeling, ETL processes, and relational databases
  • Familiarity with data warehousing concepts and performance optimization
  • Excellent problem-solving, analytical, and communication skills
  • Must be authorized to work in the U.S. without sponsorship
  • Must have excellent problem solving and analytical skills to resolve complex tactical, technical, and business-related issues.
  • Must have superior verbal and written communication skills.

What We Offer

We’re excited to offer a range of awesome benefits, including medical, dental, and vision insurance, a Health Savings Account with annual employer contributions, Flexible Spending Accounts, company-paid Short-Term Disability and Basic Life Insurance, Voluntary Life and Long-Term Disability options, an Employer 401k Match, ESOP shares, tuition reimbursement, a Referral Bonus Program, Challenge Incentive Program, and paid time off.

Please note, while these benefits are part of what we offer, they may not all apply to this specific role. The details shared in this job description are intended to give you a general idea, but duties and responsibilities may evolve over time, with or without notice. And of course, we’re happy to provide reasonable accommodations to help individuals with disabilities succeed in their role.
Posted 2025-09-05

Recommended Jobs

Software Quality Assurance Engineer

Ontheclock
Clinton, MI

Reports to: Development Manager We’re looking for a motivated, self-starting Software Quality Assurance Engineer to be the first internal QA resource at OnTheClock, a growing SaaS company focusi…

View Details
Posted 2025-08-23

Project Coordinator

Orrum
Plymouth, MI

Job Description Job Description   JOB PURPOSE AND PRIMARY RESPONSIBILITIES Reporting to the Project Manager, the Project Coordinator is responsible for the implementation of projects across t…

View Details
Posted 2025-07-29

Journeyman Electrician

Service Professor
Grand Rapids, MI

Up to a $5,000 Signing Bonus for qualified candidates! Are you ready for a fulfilling career as an Electrical Install Lead with West Michigan's premier HVAC Plumbing & Electrical employer? Service …

View Details
Posted 2025-07-31

Solo Owner Operator - Dedicated

Pure Freight Lines, LTD.
Michigan Center, MI

CDL-A OWNER OPERATORS WANTED! Bring your own truck (2015 or newer) and earn $6,000-$8,000/week! We're looking for experienced owner-operators to join our team. Enjoy steady regional freight, to…

View Details
Posted 2025-08-28

Medical Assistant

Haller & Hug, PC
Farmington Hills, MI

Job Description Job Description Motivated cheerful individual to join our team of healthcare providers. Previous experience in medical field required. Position requires computer skills, customer …

View Details
Posted 2025-07-23

Food Service Team

Vangeloff Management Inc
Trenton, MI

Job Description Job Description Build a strong Foundation both professionally and personally with a career at KFC! We’re looking for people who love serving customers, have experience in the r…

View Details
Posted 2025-08-31

Full-time Cleaners- Battle Creek

Marsden Services
Battle Creek, MI

" Are you looking for a full-time 2nd shift position with benefits and daily pay? If so, this job is for you! Shift: Monday - Friday: 2nd shift (Start time could be anytime between 3-6p, still TBD…

View Details
Posted 2025-08-31

Bartender

Applebee's
Kalamazoo, MI

Applebee's started with the same philosophy we follow today - focused on serving good food to good people! TEAM Schostak Applebee’s has been voted by our Team Members as a recipient of the Detroit Fr…

View Details
Posted 2025-07-29

Automotive Sales Representative

Legend Motors Of Waterford Inc
Waterford, MI

Job Description Job Description Benefits: Bonus based on performance Company parties Competitive salary Employee discounts Flexible schedule Company car Free food & snacks …

View Details
Posted 2025-08-06

Camp Harvest - Prep Cook

Cultivate Churches
Newaygo, MI

Job Description Job Description Salary: 12.50 Prep Cook is an essential role of Camp Harvest and Cultivate Churches Ministry whose mission is to create life-changing experiences through extende…

View Details
Posted 2025-07-23