BI Analyst Jobs in Illinois

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.

Req ID

11981BR

Work Location Options

LaGrange, IL

City

La Grange

State:

Illinois

Company Description

Progress Rail stands at the intersection of legacy and innovation—driving the future of rail with a pioneering spirit. Since its founding in 1983, the company has grown to become one of the world’s largest and most trusted providers of railroad products, services, and technologies. Today, Progress Rail delivers a comprehensive portfolio of cost-effective solutions to railway customers around the globe. From the rails themselves to the EMD® locomotives that ride them, the company’s products are in operation across more than 100 countries—powering progress and connecting communities. In 2006, Progress Rail joined Caterpillar Inc., further strengthening its ability to lead the rail industry with cutting-edge technology, unmatched expertise, and a commitment to excellence. At Progress Rail, the team is not just building the future of rail—they are making history every day.

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

EEO

Progress Rail is an Equal Opportunity Employer, including Veterans and Individuals with Disabilities.

Job Category

Transportation, Logistics, Supply Chain and Purchasing

PRS Facility Location

EMD HQ LaGrange, IL - 400

Summary Pay Range

$88,683 - $160,783