Microsoft Fabric Power BI Architect

Benefits:

• Competitive salary
• Opportunity for advancement
• Training & development

Let’s Create the Future Together at The AES Group

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

• 100% remote engagement with a senior, high-impact mandate
• Executive visibility partnering with CFO and FP&A leadership
• Opportunity to shape modern analytics architecture using Microsoft Fabric and Power BI
• Fast-paced environment focused on outcomes, scalability, and governance

We are seeking a senior-level Microsoft Fabric & Power BI Architect (contract) to support financial reporting and executive analytics 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 position requiring both strategic solution design expertise and strong technical execution capability. The ideal candidate can rapidly assess complex data environments, architect the right Fabric‑based solution, and deliver production‑ready reporting outcomes.

• Engage 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.

• 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 to executive reporting needs.

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

• 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.

• 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 consulting‑style, stakeholder‑facing environment.

• 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 (Microsoft Fabric, Power BI, Azure Data, or related) strongly preferred.

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

Ready to make an impact? Apply now and join us on our journey!

This is a remote position.