Microsoft Fabric Solution Specialist

Career Area: Technology, Digital and Data

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.

As a MS Fabric Solution Specialist within Caterpillar’s Intelligent Automation and Business Intelligence Center of Excellence (COE), you will be the enterprise’s trusted advisor on Microsoft Fabric — helping business units decide when Fabric is the right platform, how to adopt it well, and why it fits (or doesn’t fit) a given use case. This is a player‑coach role: you set the standards, build the reusable patterns, and coach teams across the enterprise — and you roll up your sleeves on the most complex or strategic builds, migrations, and proofs of concept.

Rather than delivering isolated analytics solutions, you raise the capability of every team you touch, ensuring a scalable, governed, and high‑performing analytics ecosystem.

Advise & Enable (the core of the role)

• Serve as the go‑to advisor for Fabric adoption — run intake consultations with business units, assess use‑case fit, and recommend the right approach (including steering teams away from Fabric when another platform is the better choice).
• Build decision frameworks and reference guidance: when to use Fabric vs. existing platforms, migration‑readiness criteria, and cost/capacity trade‑offs.
• Drive enablement through workshops, office hours, and an internal Fabric community of practice; define adoption maturity models and COE success metrics.
• Coach analytics, BI, and data engineering teams on best practices, lifting their capability rather than building for them.

Build & Set Standards (hands‑on)

• Partner on complex/strategic use cases — performance tuning, troubleshooting, and proof‑of‑concept development — alongside the teams that own them.
• Develop and maintain reusable assets: templates, reference architectures, semantic‑model patterns, data pipelines, and governance documentation for enterprise‑wide modernization.
• Provide deep SME guidance on Fabric Lakehouse, Data Factory pipelines, Dataflows Gen2, notebooks, medallion architectures, and Power BI modeling/DAX/workspace design.
• Create monitoring approaches, standards, and operational practices that uplift data quality, platform health, and BI performance.

Partner & Align

• Work with central infrastructure, platform engineering, and cybersecurity to keep Fabric, Power BI, and related services secure, scalable, reliable, and well‑governed.
• Align enterprise analytics strategy with Caterpillar’s broader digital and data transformation roadmap.
• Support incident/problem management and communicate findings to business and technical stakeholders.

• Value Realization (Microsoft Fabric & BI Focus): Demonstrated ability to define, track, and deliver measurable business value through Microsoft Fabric and BI initiatives. Skilled in aligning Fabric workloads (e.g., Data Engineering, Data Warehouse, Power BI, Real‑Time Analytics) to business cases, establishing KPIs, and leveraging tools such as Power BI dashboards, Fabric metrics, and data pipelines to monitor adoption, performance, and ROI.
• Communicating Complex Concepts (Business Requirements & BI Solutions): Strong ability to elicit and understand business requirements, translating stakeholder needs into effective Microsoft Fabric and BI solutions. Skilled in evaluating and articulating the trade‑offs between different approaches (e.g., Power BI reports vs. paginated reports, Direct Lake vs. Import, Lakehouse vs. Warehouse) and clearly communicating why specific architectures or tools best align to business goals, data needs, performance expectations, and user experience.
  
  Adept at bridging business and technical teams by simplifying complex analytics concepts into actionable insights and solution…