BI Systems Analyst - Supply Chain Solutions

Job Purpose The Business Intelligence Analyst supports enterprise reporting and analytics with a strong focus on supply chain, operations, and quality performance. This role partners closely with business stakeholders to design, build, and maintain Power BI reports, datasets, and data models that deliver actionable insights for decision‑making across manufacturing and operational environments. The analyst supports BI platforms, resolves data and reporting issues, and responds to both recurring and ad‑hoc analytical needs. Location LaGrange, IL Key Job Elements Design, develop, and maintain Power BI reports and dashboards for supply chain, manufacturing operations, quality, and management reporting. Create, publish, and maintain Power BI datasets, including data models, measures, relationships, and metadata to ensure accuracy, performance, and usability. Utilize Power Query for data extraction, transformation, and loading (ETL) from financial, operational, quality, and HR‑related systems. Develop and optimize SQL‑based queries to support Power BI reporting, data analysis, and performance optimization. Perform data analysis across multiple in‑house systems, with emphasis on operational efficiency, supply chain performance, and quality metrics. Partner with business users to gather, document, and translate reporting requirements into effective Power BI solutions; provide guidance on best practices and data interpretation. Troubleshoot and resolve data, reporting, and Power BI application issues, including refresh failures, performance issues, and data integrity concerns. Diagnose, document, and resolve BI software and reporting system issues identified by the business; elevate production‑critical issues as appropriate. Support and prioritize ad‑hoc data analysis requests; determine appropriate solutions while managing workload effectively. Assist with administration and maintenance of servers and workstations that support BI and reporting tools. Proactively identify opportunities to improve data quality, reporting efficiency, and insight delivery; recommend solutions and process improvements. Perform other job‑related duties as assigned. Education / Training Bachelor’s degree in Information Systems, Business Analytics, Supply Chain, Operations Management, or a related field, or equivalent experience. Qualifications and Experience Hands‑on experience with Power BI, including report and dashboard development, dataset creation and maintenance, data modeling and relationships, DAX measures and calculations, and Power Query (M) for data transformation. Workspace management, data refreshes, gateways, and security. Strong SQL skills and experience working with relational databases. Experience analyzing and reporting on supply chain, manufacturing data strongly preferred. Proven ability to work with business stakeholders to gather requirements, troubleshoot issues, and deliver reliable reporting solutions. Strong analytical, problem‑solving, documentation, and organizational skills. Ability to manage multiple priorities independently while collaborating effectively across technical and business teams. Strong communication skills. Travel for this position is very limited and may include occasional visits to manufacturing facilities. Essential Physical Activities Functions Strength – Position typically involves work in a standard office environment. Motion – Constant sitting; occasional standing and walking. Vision/Hearing Requirements – Constant verbal communications, including both talking and hearing. Work Environment – Position is consistent with standard office environment. Emotional Demands – High focus on communications and organizational skills; requires ability to work with a team to accomplish mission success. Safety – Position includes safety requirements consistent primarily with a standard office environment. Benefits Compensation and benefits offered may vary depending on multiple individualized factors, job level, market location, job‑related knowledge, skills, individual performance, and experience. Please note that salary is only one component of total compensation at Progress Rail. Competitive Salary 401(k) plan with up to 6% company match (no waiting period with immediate vesting) Medical/Dental/Vision/Life/Disability Insurance Supplemental Accident, Critical Care, and Hospital Insurance available along with an HDHP and HSA with seed money Flexible Spending Accounts Paid Vacation Paid Holidays Paid Time‑Off (PTO) Employee Assistance Plan Education Assistance Program Employee Recognition Programs Site specific Production and Incentive Plans Site specific Step and Skill Level Wage Adjustment Plans Site Specific Relocation and Sign‑on Bonus Programs Benefits eligibility varies by job position, full‑time/part‑time and regular/temporary status. The provisions of the plan documents control such benefits. Subject to position, eligibility, and plan guidelines. EEO Progress Rail is an Equal Opportunity Employer, including Veterans and Individuals with Disabilities. Job Category Transportation, Logistics, Supply Chain and Purchasing Summary Pay Range $88,683 - $160,783 #J-18808-Ljbffr Progress Rail Services