Business Intelligence Analyst

Caterpillar•Peoria, IL

12d•Onsite

About The Position

Our Product Support and Logistics Division (PSLD) is one of the most innovative divisions within Caterpillar. In PSLD, as within all of Caterpillar, our priority is our customers and helping them build a better world. We touch nearly every element of the services value stream. PSLD is responsible for Aftermarket Parts Distribution of Cat Parts, Integrated Logistics and Global Services supporting Caterpillar dealers and customers. Our teams work together in critical areas that leverage digital capabilities, technology and operational excellence. The Technical Information Solutions (TIS) team, within Global Service creates and delivers the technical parts and service information critical for the repair and service of Caterpillar products. Not a part gets sold, nor a machine or engine repaired, without the use of the information created, managed, and delivered by this team. This is an exciting opportunity to join the TIS Innovation team as a Business Intelligence Analyst. This role is responsible for bringing insights on usage of the service platforms and programs that dealers and customers use to service Caterpillar equipment globally. This includes visualization, through Power Bi, data analysis in Snowflake involving usage or transactional data from across the enterprise.

Requirements

Bachelor's degree
Accuracy and Attention to Detail: Understanding the necessity and value of accuracy; ability to complete tasks with high levels of precision.
Effective Communications: Understanding of effective communication concepts, tools and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.
Business Data Analysis: Knowledge of business data analysis; ability to collect, identify, analyze and interpret business data using various kinds of techniques to meet business needs and requirements.
Business Assessment: Knowledge of the activities, tasks, practices and deliverables for assessing and documenting business opportunities; ability to assess the benefits, risks, and success factors of potential applications.
Requirements Analysis: Knowledge of tools, methods, and techniques of requirement analysis; ability to elicit, analyze and record required business functionality and non-functionality requirements to ensure the success of a system or software development project.
Technical Writing/Documentation: Knowledge of technical writing; ability to write technical documents such as manuals, reports, guidelines or documents on standards, processes and applications.
Research Analysis: Knowledge of the concepts, methodologies and methods of research analysis; ability to locate, interpret and evaluate research findings compiled and documented by others.

Nice To Haves

2+ years of data analysis or data visualization experience
Working knowledge and experience with Power BI, Snowflake and SQL
2+ years of experience in design and prototyping dynamic views and visualizations for large and complex data sets in Tableau and/or Power BI
Good communication skills
Self-starter and driven while working well in team environment
Create innovative solutions to solve business problems
Strong attention to detail to spot inaccuracies in coding or data
Experience with data structures using SQL
Strong knowledge of Microsoft Management studio, R, SQL, DevOps, Excel, Alteryx, Snowflake is a plus

Responsibilities

Works directly with business partners to understand informational needs of end users and create reporting/visualization solutions that turn data into critical information to ultimately drive sound business decisions
Present insights outputs to Senior leaders and advisors
Prototype, develop, iterate, test, and deploy into production automated reporting solutions
Incorporate statistical methods and/or digital methods to solve business problems
Prototype, develop, iterate, test, and deploy into production automated reporting solutions
Coach and mentor other business intelligence analysts in the creation, validation, and application of digital solutions and Insights projects.
Participate on cross-functional project teams