Database Analyst / Programmer 3 - Senior Data Analyst - Business Intelligence & Analytics
Job Overview
Caterpillar's VisionLink team within Cat Digital is seeking a Database Analyst / Programmer 3 to support equipment management applications by gathering stakeholder requirements, analyzing large and complex datasets, and delivering actionable insights. The role will help drive application enhancements, improve customer experience, and support go-to-market strategies through data-driven decision-making.
Location & Work Schedule
- Preferred Location: Peoria, IL Also Open To: Chicago, IL and Broomfield, CO
- Work Model: Hybrid
- Duration: 12-month contract
Note: Candidates should be comfortable with a hybrid environment requiring in-office attendance several days per week. The role may eventually transition to a full return-to-office model.
Why Caterpillar?
At Caterpillar, you'll have the opportunity to work on innovative products and solutions that impact customers around the globe. With operations across 150+ locations worldwide, you'll collaborate with industry-leading professionals, contribute to meaningful projects, and continuously develop your skills while helping build technology that matters.
Key Responsibilities
- Assist in the development, testing, and deployment of reports, dashboards, and analytics solutions.
- Analyze existing reporting and data products and recommend enhancements.
- Gather and document business and technical requirements from stakeholders.
- Define technical specifications for reporting and dashboard solutions.
- Prepare technical documentation and communicate requirements to senior analysts and technical teams.
- Support senior analysts by fulfilling data requests and providing analytical insights.
- Analyze large and complex datasets to identify trends, opportunities, and business insights.
- Contribute to production-ready analytics solutions and reporting initiatives.
Team Environment
- Small, collaborative team consisting of 3 core members working closely with a 4th team member.
- Regular interaction with internal Caterpillar stakeholders and business users.
- Opportunity to work on customer usage analytics and equipment management applications within Cat Digital.
Required Qualifications
- Minimum 5+ years of experience in data analysis, reporting, business intelligence, or a related analytical role.
- Bachelor's degree is not required.
- Strong understanding of:
- Business Data Analysis
- Requirements Gathering & Analysis
- Data Accuracy & Quality Assurance
- Technical Documentation
- Stakeholder Communication
Preferred Technical Skills
- 2+ years of experience querying and analyzing large, complex datasets using Snowflake or similar data platforms.
- Strong SQL skills and understanding of data structures.
- 2+ years of experience developing dashboards and visualizations using:
- Experience with AI-related workflows, including:
- Data Pipeline Engineering
- Prompt Engineering
- Experience deploying analytics or reporting solutions into production environments.
- Ability to work independently while collaborating effectively within a team.
Top Candidate Profile
Successful candidates will demonstrate:
- Strong analytical and problem-solving capabilities.
- Exceptional attention to detail and data accuracy.
- Experience working with enterprise-scale datasets.
- Ability to translate business requirements into technical solutions.
- Strong communication and documentation skills.
- Self-motivation and ownership mindset.
Red Flags / Disqualifiers
- Frequent job changes or unstable work history.
- Candidates unwilling to work onsite as required.
- Non-local candidates must clearly indicate willingness to relocate at their own expense and be onsite from Day 1.
- Candidates with 10+ years of highly advanced experience or Master's-level qualifications should understand this is a mid-level role and be comfortable with the scope and level of the position.
Interview Process
- 1 Round Panel Interview
- Virtual/Phone Interview
- Hiring process is expected to be streamlined with a single interview round.
Summary of Must-Have Skills
5+ years of Data Analysis/Reporting experience
Snowflake or similar data platform experience
SQL expertise
Tableau and/or Power BI dashboard development
Requirements gathering and business analysis
Strong communication and documentation skills
Experience working with large, complex datasets
AI workflow exposure (Prompt Engineering/Data Pipelines preferred)
Never miss an opportunity! Create an alert based on the job you applied for.
