Microsoft Fabric & Power BI Architect
Full Time • Fully Remote - US
Benefits:
- Competitive salary
- Opportunity for advancement
- Training & development
Role: Microsoft Fabric & Power BI Architect
Location: Remote (External Stakeholder Engagement)
What We Offer (Position Engagement Highlights)
- 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
About the Role
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.
Key Responsibilities
Stakeholder Engagement & Requirements Discovery
- 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.
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 to executive reporting needs.
Data Engineering & Transformation
- 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.
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.
Required 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 consulting-style, stakeholder-facing 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 (Microsoft Fabric, Power BI, Azure Data, or related) strongly preferred.
Engagement Profile
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.
Compensation: $80.00 - $90.00 per hour
AES is a premier technology consulting company that brings together businesses and talent to deliver the most innovative technology solutions that create the most positive impact to society.
In the last 20 years, we have developed innovative best-in-class technology solutions to the world’s forward-thinking companies on four key service areas:
- Customer Experience: engaging customers with differentiating digital experiences to sustain
business relevance
- Employee Experience: enabling employees to learn, collaborate, and grow to sustain business
performance
- Business Solutions: transforming and optimizing business operations to sustain business resilience
- Emerging Technology: exploring and adopting emerging technology to transform business model
Our team ensures that your favorite coffee shop has the right amount of people serving you at any given time. Our team ensures that the governance board of a global company has the right ESG insights to make the most sensible actions for the world. The list goes on and on. At the core of
what we do is creating the future that is right for everyone, with the right technology, and with the right talent.
In the last 20 years, we have developed innovative best-in-class technology solutions to the world’s forward-thinking companies on four key service areas:
- Customer Experience: engaging customers with differentiating digital experiences to sustain
business relevance
- Employee Experience: enabling employees to learn, collaborate, and grow to sustain business
performance
- Business Solutions: transforming and optimizing business operations to sustain business resilience
- Emerging Technology: exploring and adopting emerging technology to transform business model
Our team ensures that your favorite coffee shop has the right amount of people serving you at any given time. Our team ensures that the governance board of a global company has the right ESG insights to make the most sensible actions for the world. The list goes on and on. At the core of
what we do is creating the future that is right for everyone, with the right technology, and with the right talent.
(if you already have a resume on Indeed)