Solution Architect

We are seeking a seasoned Solution Architect to lead the design and delivery of analytics solutions built on Microsoft Fabric and Power BI. This role is ideal for a strategic thinker with deep experience in business intelligence who can translate complex business questions into actionable insights, architect scalable solutions, and guide clients through the modern Microsoft data stack.

While this is not a hands-on data engineering role, a strong understanding of the Fabric ecosystem and a proven track record of enabling data-driven decision-making through Power BI are essential.

Key Responsibilities: Analytics & Insight Leadership

• Engage with clients to understand business objectives and translate them into high-impact analytics solutions.
• Design semantic data models and reporting strategies that uncover trends, enable KPIs, and drive strategic decisions.
• Apply domain expertise to help clients frame the right questions, select effective visualizations, and craft compelling data narratives.

Solution Architecture & Delivery

• Architect scalable analytics solutions using Microsoft Fabric and modern, cloud-native data architecture principles.
• Optimize Power BI datasets, reports, and dashboards for performance, usability, and alignment with business goals.
• Establish frameworks for reusability, self-service analytics, and governance in enterprise BI environments.

Technical Project Leadership & BI Development

• Lead technical workstreams across multiple BI projects, ensuring adherence to architectural standards and best practices.
• Collaborate with consultants, developers, and data engineers to ensure accurate and efficient implementation.
• Contribute hands-on to BI development as needed, particularly in semantic model design, DAX optimization, workspace management, and performance tuning.
• Own the technical success of projects from kickoff to deployment, managing risks and ensuring high-quality deliverables.

Client Engagement & Thought Leadership

• Facilitate workshops, discovery sessions, and roadmap planning with business and technical stakeholders.
• Provide expert guidance on Power BI adoption and data strategy.
• Educate clients on the evolving Microsoft Fabric ecosystem and how to maximize its business value.

Qualifications:

• 5+ years of experience in analytics and BI roles, with Power BI as the primary delivery tool.
• Deep knowledge of Power BI architecture, including advanced DAX, Power Query, RLS, and semantic modeling.
• Experience leading enterprise BI initiatives and building analytics programs.
• Familiarity with data governance, security models, workspace architecture, and deployment pipelines.
• Strong client-facing skills with the ability to uncover insights, tell data stories, and guide decision-making.
• Understanding of data engineering and modeling principles (hands-on pipeline development not required).
• Microsoft Certification: PL-300 Power BI Data Analyst.
• Microsoft Certification: DP-600 Fabric Analytics Engineer, preferred.
• Strong grasp of Microsoft Fabric concepts — including OneLake, Direct Lake, Lakehouse architecture, Dataflows Gen2, Pipelines, Notebooks, and Power BI integration, preferred.
• Exposure to Azure Synapse, SQL, Data Factory, Azure Data Lake, and Azure SQL Database, preferred.
• Experience with Python and/or R for data analysis, statistical modeling, and automation — including tasks such as data cleaning, exploratory analysis, visualizations, and integrating with BI platforms for advanced analytics, preferred.

Job Types: Full-time, Contractual / Temporary, Freelance

Work Location: In person