Microsoft Fabric & Power BI Architect (Contract)

Position Title: Microsoft Fabric & Power BI Architect (Contract)
Location: Client-Facing Engagement(remote)

Let's Create the Future Together at The AES Group

About The AES Group

The AES Group is a premier technology staffing and services company with over 20 years of experience connecting businesses and talent to deliver transformative technology solutions. We support Fortune 500 enterprises in engaging customers, empowering employees, and modernizing operations through cloud, data, AI, and emerging technologies.

About the Role

We are seeking a senior-level Microsoft Fabric & Power BI Architect on a contract basis to support client-facing financial reporting initiatives. This role partners directly with CFO and FP&A stakeholders to uncover underlying data challenges and deliver scalable, executive-ready reporting solutions.

This is a hands-on architect role requiring both strategic solution design expertise and strong technical execution capability. The ideal candidate can quickly assess complex data environments, architect the right Fabric-based solution, and deliver production-ready reporting outcomes.

Key Responsibilities

Stakeholder Engagement & Requirements Discovery

• Engage directly with CFO, FP&A, and business stakeholders to gather financial reporting and analytics requirements.
• Translate business objectives into scalable data and reporting solutions.
• Identify root-cause data challenges impacting financial insights and decision-making.

Architecture & Solution Design

• Design and implement Microsoft Fabric architectures, including Lakehouse, Warehouse, and semantic models.
• Establish scalable data modeling frameworks and governance standards.
• Architect end-to-end financial analytics solutions aligned with executive reporting needs.

Data Engineering & Transformation

• Assess current data landscape and identify gaps in data quality, structure, and integration.
• Perform hands-on data extraction, transformation, and cleansing using Microsoft Fabric tools, SQL, and PySpark.
• Implement best practices in data modeling, including star schema design and semantic modeling.

Power BI Development & Executive Reporting

• Build and optimize Power BI semantic models and advanced DAX measures.
• Develop executive dashboards and financial performance reporting solutions.
• Ensure performance optimization, scalability, and maintainability of BI solutions.

Qualifications

Experience & Expertise

• Strong hands-on experience with Microsoft Fabric.
• Advanced Power BI expertise, including complex DAX development and semantic modeling.
• Deep understanding of data modeling best practices and star schema design.
• Experience delivering CFO-level or executive financial performance reporting.
• Proven ability to operate independently in a client-facing consulting environment.

Preferred Qualifications

• FP&A domain expertise.
• Experience supporting financial forecasting, budgeting, or variance analysis initiatives.
• Prior consulting or contract delivery experience.
• Relevant Microsoft or data platform certifications (such as Microsoft Fabric, Power BI, Azure Data, or related certifications) are strongly preferred.

Engagement Profile

This is a senior-level contract engagement suited for a practitioner who can rapidly assess data maturity, architect the appropriate Microsoft Fabric solution, and execute hands-on to deliver business-ready financial reporting outcomes.