IT Systems Engineer - Fabric & Power Platform

Ralliant is seeking a Microsoft 365 Power Platform Engineer to design and deliver analytics solutions with a strong focus on Microsoft Fabric, Power BI, and AI-enabled analytics strategy. This role will play a key part in enabling AI-ready data foundations, supporting Copilot experiences, and operationalizing analytics and insights across the organization in a secure, governed, and scalable manner.

The ideal candidate combines strong BI engineering skills with an understanding of how AI capabilities (Copilot, semantic models, data quality, and governance) depend on well-designed data platforms. You will partner with business stakeholders, security, and platform teams to ensure data products are optimized not only for reporting, but also for AI-driven insights and automation.

Key Responsibilities

Microsoft Fabric & Data Platform Engineering
• Design and implement end-to-end Microsoft Fabric solutions leveraging Lakehouse/Warehouse, Data Pipelines, Dataflows Gen2, and Fabric capacities.
• Build scalable data ingestion, transformation, and modeling pipelines that support analytics, self-service BI, and downstream AI use cases.
• Implement standardized medallion-style data architectures (e.g., bronze/silver/gold) with strong data quality, lineage, and observability.
• Optimize Fabric workloads for performance, reliability, and cost efficiency, including capacity utilization and refresh strategies.
• Develop enterprise-grade Power BI semantic models designed for reuse, performance, and AI-readiness.
• Create and maintain Power BI reports and dashboards with a strong focus on usability, performance, and accessibility.
• Apply advanced DAX and Power Query (M) techniques to optimize large models and complex datasets.
• Implement and manage Power BI deployment pipelines, workspace strategies, and lifecycle management (dev/test/prod).
AI Strategy Enablement
• Design AI-ready data models and semantic layers that support Microsoft Copilot, natural language querying, and generative AI experiences.
• Partner with architecture and AI teams to align Fabric and Power BI assets with the organization’s broader AI and Copilot strategy.
• Ensure datasets are curated, documented, and governed to support trusted AI outputs (certified datasets, promoted models, consistent definitions).
• Identify opportunities to embed AI-driven insights into Power BI, Power Apps, and Microsoft 365 workflows.
• Contribute to enterprise standards for responsible AI enablement, including data quality, security boundaries, and explainability.
Power Platform & M365 Integration
• Build supporting Power Apps and Power Automate flows that extend analytics insights into operational workflows.
• Integrate solutions with Microsoft 365 services (Teams, SharePoint, OneDrive, Outlook) for collaboration, distribution, and automation.
Governance, Security & Operations
• Implement and maintain data security, access controls, and governance policies, including RLS, sensitivity labels, and workspace controls.
• Support Power BI and Fabric administration, including capacity monitoring, usage analysis, audit logs, and environment governance.
• Produce audit-ready documentation: solution architectures, semantic model definitions, AI usage considerations, and operational runbooks.
• Act as a trusted technical advisor to stakeholders during requirements gathering, solution design, and prioritization.

Skills & Experience

• 5+ years of experience delivering BI or analytics solutions using Power BI and Microsoft data platforms.
  • Hands-on experience with Microsoft Fabric, or strong prior experience with Power BI + Azure data services transitioning into Fabric.
  • Dimensional data modeling and semantic layer design
  • DAX optimization and performance tuning
  • Power Query (M) and data transformation best practices
  • Experience designing analytics solutions with AI and Copilot consumption in mind.
  • Solid understanding of data governance, security, and access control concepts.
  • Strong SQL skills for querying, troubleshooting, and performance optimization.
  • Ability to communicate effectively with both technical and non-technical stakeholders.

Qualifications

• BA/BS in Finance, Accounting, Computer Science, Information Systems, Cybersecurity, or a related field
  • Experience with both Commercial and GCCH Microsoft environments.
  • Experience supporting Copilot or AI-assisted analytics scenarios in Microsoft Fabric or Power BI.
  • Familiarity with Fabric capacity planning, cost management, and monitoring.
  • Experience with Purview, data cataloging, lineage, and metadata management.
  • Power Platform experience (Power Apps, Power Automate, Dataverse).