Job Information
Caterpillar, Inc. Senior Business Intelligence Analyst in Peoria, Illinois
Career Area:
Business Technologies, Digital and Data
Job Description:
Your Work Shapes the World at Caterpillar Inc.
When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it.
Our Americas Distribution Services Division (ADSD) provides governance and administration of Cat® dealers across the U.S., Canada, and Latin America.
We’re committed to our customers, who build a better world with our products, services, and solutions. We understand and show the value of why they should always choose us. We’re exploring new ideas and opportunities – innovating to discover the breakthroughs necessary for tomorrow’s growth.
Through it all, we are one team (https://www.youtube.com/watch?v=mYIDne7Q5ek&list=PLwAXbfivFg0jmiNqqgFLeQJpRB_i-UVln&index=39) – creating and delivering world-class components and solutions superior to the competition. Learn more about the Caterpillar Experience (https://www.youtube.com/watch?v=GvCYWtWARlk&list=PLwAXbfivFg0jmiNqqgFLeQJpRB_i-UVln&index=25) .
Job Summary
You will aid in the development of operational excellence, service capacity and capability, and services growth. The Service Excellence team optimizes the useability and reliability of service events data, activates this information, and enables the enterprise to understand, measure, and improve dealer performance.
This role will be focused on activating information through efficient reporting and effective visualization. It will include heavy use of SQL within Snowflake environments and common visualization tools such as Power BI and Tableau.
Additional Info :
This is a hybrid position located in Peoria, IL or Singapore.
Our team embraces flexibility through a hybrid work model. In addition to working onsite at our facility in Peoria, IL, our hybrid work model allows employees the flexibility to work from home based on business need.
Relocation assistance is not available for this position.
What You Will Do:
This role gathers, organizes, and reports on data from across the organization with the purpose of provide information and insights that lead to action.
Focus will be on Service Events and Information data domain and will include work order, inspection, fluid analysis, warranty and other related data sets.
What You Have:
Query and Database Access Tools: Knowledge of data management systems; ability to use, support and access facilities for searching, extracting and formatting data for further use.
• Writes, debugs and implements complex queries involving multiple tables or databases.
• Works with aggregate functions, complex joins, groupings, dynamic and embedded SQL's (Structured Query Languages).
• Consults on query optimization, interactive queries, testing and verification.
Visualization and Reporting: knowledge of techniques and tools for visualization and communication
• Creates visualizations for data sets using common tools and platforms (Power BI, Tableau, etc.)
• Create and modify database structure to support consumption for reporting
• Modify and evolve previous created reports and visualization
• Manage access to and security to created reports
Accuracy and Attention to Detail: Understanding the necessity and value of accuracy; ability to complete tasks with high levels of precision.
• Processes large quantities of detailed information with high levels of accuracy.
• Productively balances speed and accuracy.
• Implements a variety of cross-checking approaches and mechanisms.
Analytical Thinking: Knowledge of techniques and tools that promote effective analysis; ability to determine the root cause of organizational problems and create alternative solutions that resolve these problems.
• Approaches a situation or problem by defining the problem or issue and determining its significance.
• Makes a systematic comparison of two or more alternative solutions.
• Uses flow charts, Pareto charts, fish diagrams, etc. to disclose meaningful data patterns.
• Identifies the major forces, events and people impacting and impacted by the situation at hand.
• Uses logic and intuition to make inferences about the meaning of the data and arrive at conclusions.
What Will Set You Apart:
Experience using PowerBI or Tableau
Experience using SQL
Experience with large data sets; including visualization, querying
What You Will Get:
We look forward to welcoming the successful candidate to our dynamic, diverse, and friendly team. We have a culture of openness, autonomy, support, personal development as well as a continuous drive for improvement.
About Caterpillar
Caterpillar Inc. is the world’s leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. For nearly 100 years, we’ve been helping customers build a better, more sustainable world and are committed and contributing to a reduced-carbon future. Our innovative products and services, backed by our global dealer network, provide exceptional value that helps customers succeed.
Visa Sponsorship is not available for this position. This employer is not currently hiring foreign national applicants that require or will require sponsorship tied to a specific employer, such as, H, L, TN, F, J, E, O. As a global company, Caterpillar offers many job opportunities outside of the U.S which can be found through our employment website at www.caterpillar.com/careers.
Posting Dates:
May 16, 2024 - June 5, 2024
Any offer of employment is conditioned upon the successful completion of a drug screen.
EEO/AA Employer. All qualified individuals - Including minorities, females, veterans and individuals with disabilities - are encouraged to apply.
Not ready to apply? Join our Talent Community (http://flows.beamery.com/caterpillarinc/talcom) .
There’s more to work at Caterpillar than just the work itself. We hire smart, friendly people and it shows in our culture. We hold ourselves to high standards and make sure our values of integrity, excellence, teamwork, commitment and sustainability come to life in the way we work. We make sure our employees feel continuously challenged while also supported. We provide professional growth opportunities, including leadership programs. We celebrate the diversity of our team, while also working together as one Caterpillar.
Our culture, like everything at our company, is made possible by each employee’s contribution. Person by person, we create the environment we work in, and we are proud of the Caterpillar we’ve built.