Analyst I, Business Data

Progress Rail

La Grange, Illinois

Apply

JOB DETAILS

SKILLS

Analysis Skills, Best Practices, Business Analysis, Business Intelligence, Business Intelligence Software, Caterpillar Equipment, Communication Skills, Data Analysis, Data Modeling, Data Quality, Data Sets, Database Extract Transform and Load (ETL), Establish Priorities, Financial Operations, Identify Issues, Information Technology & Information Systems, Leadership, Leading Edge Technology, Management Reporting, Manufacturing, Manufacturing Operations, Metadata, Multitasking, People Management, Performance Metrics, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Process Improvement, Quality Management, Quality Metrics, Relational Databases (RDBMS), Reporting Dashboards, Requirements Management, SQL (Structured Query Language), Server Maintenance, Supply Chain, Supply Chain Management, Supply Chain Operations, Systems Administration/Management, Systems Analysis, Training Data Sets, Usability Engineering

LOCATION

La Grange, Illinois

POSTED

3 days ago

PRS Facility Location
EMD HQ LaGrange, IL - 400
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
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.
Education / Training
Bachelor's degree in Information Systems, Business Analytics, Supply Chain, Operations Management, or a related field, or equivalent experience.

Job Title
BI Systems Analyst - Supply Chain Solutions
City
La Grange
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.
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;
• Vis

About the Company

Progress Rail

Resume Resources

Free Resume Templates Free Resume Builder