Career Area:
Engineering
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.
Role Definition
Develops and maintains scalable backend data queries and front-end Power BI dashboards to monitor various worksites & IoT/ Telematics devices. Ensures backend data models are reusable across dashboards, establishing a governed data layer that improves consistency while minimizing Data usage costs. Translates operational data into reliable insights that enable monitoring, diagnostics, and decision-making.
Responsibilities
• Develop backend SQL/Snowflake queries that act as a shared data layer across all dashboards. • Build interactive, user-friendly Power BI dashboards for monitoring monitor various worksites & IoT/ Telematics devices. • Optimize backend queries and data models to reduce Snowflake compute and storage costs. • Establish reusable datasets and eliminate redundant data pipelines across reports. • Translate business requirements into scalable data models, metrics, and visual insights. • Define KPIs, DAX measures, and calculated metrics aligned with operational goals. • Analyse historical and current data to identify trends, anomalies, and performance gaps. • Ensure dashboards are accurate, performant, and aligned with backend logic. • Apply best practices in Power BI (data modelling, DAX optimisation, usability, navigation). • Collaborate with Product Service Engineers for failure analysis, insights, and reporting. • Perform validation and testing of dashboards against backend data sources. • Troubleshoot and resolve issues across data pipelines, queries, and visualisations. • Build and maintain documentation for data models, dashboards, and KPI definitions. • Create ad-hoc reports and executive dashboards for management visibility. • Integrate data from multiple systems (Snowflake, SQL Server, cloud platforms). • Continuously improve analytics solutions for performance, scalability, and usability.
Degree Requirement
Bachelor’s degree in Computer Science, Information Technology, Data Analytics/ Data Science, or related field (Master’s preferred).
Skill Descriptors
Industry Knowledge
Level: Working Knowledge
• Understands site performance, telematics, and product service analytics use cases. • Interprets KPIs such as uptime, utilisation, performance trends, and failure patterns. • Applies domain context to design meaningful dashboards and insights.
Problem Solving
Level: Extensive Experience
• Identifies inefficiencies in queries, data models, and dashboards. • Diagnoses inconsistencies between backend data and visualisations. • Resolves performance bottlenecks in Power BI and Snowflake queries. • Improves data accuracy and usability through structured analysis.
Software Development Life Cycle
Level: Working Knowledge
• Translates business requirements into technical implementations. • Works with DevOps pipelines and version control for BI solutions. • Supports iterative enhancements based on user feedback.
Software Product Testing
Level: Working Knowledge
• Validates dashboard outputs against backend data sources. • Ensures KPI calculations are correct across scenarios. • Supports testing for usability and decision accuracy.
Application Development Tools
Level: Extensive Experience
• Expert in Power BI (visualisation, DAX, data modelling, performance tuning). • Strong SQL expertise (Snowflake, SQL Server, Azure/AWS SQL). • Experience with BI deployment pipelines and DevOps practices. • Familiarity with cloud-based data platforms and integrations.
Programming
Level: Working Knowledge
• Writes efficient and optimized SQL queries. • Understands data transformation and pipeline logic. • Exposure to Python or scripting for automation is preferred.
Technical Troubleshooting
Level: Extensive Experience
• Identifies root causes of dashboard inaccuracies or failures. • Troubleshoots issues across backend queries and visual layers. • Optimizes Snowflake usage by eliminating inefficient query patterns. • Ensures reliability and performance of analytics solutions in production.
Required Experience
• 3+ years of experience in Power BI, SQL, and BI/analytics development. • Hands-on experience with Snowflake and cost-efficient query design. • Experience building reusable enterprise data models and dashboards. • Strong analytical skills working with large datasets. • Experience working with cross-functional engineering/support teams.
Desired Experience
• Experience with Python, .NET, Java, or Angular. • Exposure to IoT, Telematics, Manufacturing, or Site Operations domains. • Experience with AI-driven analytics or predictive modelling.
• Interfacing with Stakeholders to deliver commitments.
Success Criteria
• Establish a reusable backend data layer used across dashboards. • Reduce Snowflake consumption through optimized data models and queries. • Deliver high-quality dashboards for Site and Technology monitoring. • Improve data consistency, reliability, and stakeholder adoption. • Enable faster operational insights and failure analysis.
Posting Dates:
June 5, 2026 - June 11, 2026
Caterpillar is an Equal Opportunity Employer. Qualified applicants of any age are encouraged to apply
Not ready to apply? Join our Talent Community.