Power BI Front-End Developer

Career Area:

Job Description:

Your Work Shapes the World at Caterpillar Inc.

When you join Caterpillar yourejoining 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 dontjust 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

Bachelors degree in Computer Science Information Technology Data Analytics/ Data Science or related field (Masters 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 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:

Caterpillar is an Equal Opportunity Employer. Qualified applicants of any age are encouraged to apply

Not ready to apply Join our Talent Community.