It Analyst Applications (bi/data Modelling Engineer)

Caterpillar Caterpillar · Industrial · Bangalore, Karnataka

Seeking a BI/Data Modelling Engineer to join the Applications Development & Intelligence Automation team at Caterpillar. The role focuses on creating high-impact semantic models and reports using tools like Power BI and Snowflake to empower business users with data-driven decision-making. Responsibilities include delivering data models and reports, assisting with documentation, providing flowcharts, ensuring quality deliverables through testing, and engaging with users for support and feedback.

What you'd actually do

  1. Deliver data, semantic models, and reports in Snowflake, Power BI, and Sigma tailored to business customer needs
  2. Assist in preparing technical and procedural documentation required in application system development
  3. Provide detailed flowcharts to show processing logic for simple application programs
  4. Follow team standards and practices to ensure high-quality and sustainable deliverables
  5. Testing and ensuring quality deliverables
  6. Engage directly with users to address questions and support training, testing, and feedback loops to improve deliverables

Skills

Required

  • Expertise in dimensional modeling, semantic layer design, and data architecture
  • Experience with SQL, data modeling, and BI tools (Power BI preferred)
  • Ability to translate business needs into scalable data models
  • Understanding of data governance, performance optimization, and metadata management
  • Strong collaboration and communication skills
  • Innovative mindset with a passion for enabling self-service analytics
  • Knowledge of major production application systems used for delivery of services to internal and external clients
  • Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems
  • Knowledge of application design and architecture principles and practices

Nice to have

  • Experience with Snowflake and dbt
  • Experience supporting enterprise data applications
  • Experience in financial services or regulated industries