Junior Power BI Specialist

Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust.

Job Summary:

Challenge Manufacturing is a leading tier 1 supplier of complex metal assemblies for the global automotive industry, committed to operational excellence and employee empowerment. The Power BI Analyst will develop and optimize data reporting and visualization tools, collaborating with cross-functional teams to deliver insights that enhance operational efficiency and support business decision-making.

Responsibilities:

• 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

Qualifications:

Required:

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

Company:

Challenge Manufacturing is an automotive company offering stamped and welded automotive assemblies. Founded in 1981, headquartered in Walker, Michigan, USA, team size 1001-5000 employees, currently Late Stage.