02 Aug
|
Caterpillar
|
Bengaluru
02 Aug
Caterpillar
Bengaluru
Job Summary
We are seeking a skilled IT Analyst Applications to join India CoE-Integration & Engg CAT IT Division. We are seeking a mid-level to senior Power BI Developer with strong dashboard UI/UX expertise to design and deliver high-impact, intuitive analytics experiences for business stakeholders within Caterpillar Financial Insurance Services (CFIS). This role sits within the BI, Data, and AI team and is responsible for end-to-end dashboard development from business requirements and wireframing through semantic model alignment, DAX measures, Power Query transformations, and performance optimization. The developer will play a key role in maintaining and expanding our library of 18+ key dashboards and 100+ governed reports that drive financial, operational, and strategic decision-making across the insurance division.
The preference for this role is to be based out of Bangalore.
What you will do
- End-to-End Dashboard Development: Own the full lifecycle of Power BI report and dashboard development requirements gathering, wireframe/mockup creation, data model alignment, DAX measure authoring, Power Query transformations, visual design, user acceptance testing, and production deployment. Ensure every deliverable is accurate, fast, and easy to consume.
- Financial & Operational Reporting: Build and maintain dashboards that support key insurance business functions including policy administration, claims analysis, premium reporting, loss ratios, dealer solutions metrics, pricing analytics, and operational KPIs. Understand the business context behind the data and translate it into actionable, self-explanatory visualizations.
- Semantic Model & Certified Data Source Alignment: Work closely with data modelers and the ETL team to consume governed, business-friendly semantic views published from Snowflake. Ensure Power BI semantic models (formerly datasets) are properly aligned with certified definitions consistent field naming, correct relationships, and optimized for DirectQuery or Import mode depending on the use case.
- UI/UX Design & Visualization Best Practices: Apply a user-centered design mindset to produce accessible, consistent, and visually compelling dashboards that drive adoption. Follow established CFIS design standards for layout, color schemes, navigation (drill-through, drill-down, bookmarks, tabs), and accessibility.
Create reusable templates and visual patterns that raise the quality bar across the entire report portfolio.
- Row-Level Security & Governance: Implement and maintain row-level security (RLS) to enforce data access policies across reports. Support deployment governance practices including environment management (Dev Pre-Prod Prod), version control, change advisory board (CAB) review processes, and release notes documentation.
- Performance Tuning & Optimization: Monitor and optimize report performance identifying slow-loading visuals, inefficient DAX, bloated models, or excessive data volume and implement best practices such as aggregations, query folding, incremental refresh, and model size reduction.
- Collaboration & Knowledge Sharing: Work closely with onshore team leads, data modelers, ETL developers, business analysts, and project managers to align report deliverables with business priorities. Participate in CAB reviews, weekly release notes, maintain user guides, and support business user onboarding to Power BI.
What you will have
- 5+ years of experience in business intelligence, data analytics, or report development
- 3+ years hands-on experience with Power BI Desktop and Power BI Service (report authoring, publishing, workspace management, app distribution)
- Strong proficiency in DAX (calculated measures, time intelligence, complex aggregations) and Power Query / M (data transformations, query folding, parameterized queries)
- Experience designing and optimizing semantic models (relationships, star schemas, Import vs. DirectQuery mode selection)
- Demonstrated UI/UX design skills ability to create intuitive, accessible, visually polished dashboards
- Experience implementing row-level security (RLS) and environment-based deployment governance (Dev/Test/Prod)
- Solid SQL proficiency for data validation, troubleshooting, and ad hoc analysis
- Excellent communication and collaboration skills; ability to work effectively in a distributed, global team
- This position requires candidate to work a 5-day -a -week schedule in the office.
Preferred
- Power BI Paginated Report Builder for our standard accounting and financial reporting
- Experience connecting Power BI to Snowflake (SSO, DirectQuery, Import)
- Familiarity with Snowflake semantic views or governed data layers as a consumption source
- Experience with Streamlit or other lightweight data application frameworks
- Exposure to self-service analytics platforms or natural language query tools (e.g., Polaris AI / Snowflake Intelligence)
- Insurance, financial services, or regulated industry domain experience
- Experience with Power BI REST APIs, deployment pipelines, or CI/CD for BI assets
- Power BI certifications (PL-300 or equivalent)
Skills
- Core Application Systems: Knowledge of major production application systems used for delivery of services to internal and external clients; ability to leverage major production application systems in diverse situations.
- Problem Solving: Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems; ability to apply knowledge of problem solving appropriately to diverse situations. Level Working Knowledge: Identifies and documents specific problems and resolution alternatives. Examines a specific problem and understands the perspective of each involved stakeholder. Develops alternative techniques for assessing accuracy and relevance of information. Helps to analyze risks and benefits of alternative approaches and obtain decision on resolution. Uses fact-finding techniques and diagnostic tools to identify problems.
- Application Design, Architecture: Knowledge of application design and architecture principles and practices; ability to utilize application design methodologies, tools, and techniques to convert business requirements and logical models into a technical application design. Level Extensive Experience: Analyzes system requirements and translates them into detailed design specifications.
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
📌 IT Analyst Applications - Power BI Developer (Bengaluru)
🏢 Caterpillar
📍 Bengaluru