Solution Architect

Job Title: Solution Architect

Location: Frisco TX Overland Park KS and Atlanta GA

Duration: / Term: Contract

Experience Desired: 8 Years

Job Description:

• This role develops and owns end-to-end solution design strategies for the enterprise Semantic Layer program built on Microsoft Fabric and Power BI.
• The Solutions Architect leads semantic model design across business workstreams ensuring models are governed certified and compliant with SOX and enterprise data standards.
• The role bridges technical implementation (Microsoft Fabric Power BI third-party BI platforms and Anthropic/AI tooling) with stakeholder alignment across Finance Operations Marketing and Technology.
• Success is measured by the delivery of certified trusted semantic models that enable self-service analytics across the organization.
• The work directly enables data-driven decision-making by establishing a governed reusable and interoperable semantic layer.

Main Responsibilities

• Responsibility % of Time Semantic Model Architecture & Workstream Enablement Design build and own semantic models in Microsoft Fabric (Direct Lake composite models and import mode) for each business workstream including Finance Operations Marketing HR and Technology.
• Establish workstream-specific model standards certified dataset patterns and reusable measure libraries. 30% Governance Certification & SOX Compliance Define and enforce semantic layer governance frameworks including dataset certification workflows row-level security (RLS) object-level security (OLS) and sensitivity label policies.
• Partner with Audit and Finance to ensure SOX-compliant lineage access controls and change management processes for financial reporting models. 25% Tool Integration: BI Platforms Anthropic & Downstream Consumers Architect interoperability between Microsoft Fabric semantic models and downstream consumption tools including third-party BI platforms (Tableau Qlik Sense MicroStrategy Grafana and others) Anthropic-based AI/LLM applications (Claude) and Excel.
• Define connectivity patterns query optimization strategies and security passthrough standards for each integration channel. 20% Stakeholder Alignment & Technical Advisory Engage workstream leads data owners and senior management to translate business requirements into semantic model designs. Lead architectural trade-off discussions and present options for data modeling approaches (star schema composite models aggregation tables).
• Serve as the primary point of escalation for semantic layer design decisions. 15% Other Duties Other duties/projects as assigned by business management.
• Qualifications Education Equivalent Experience Required Preferred Bachelors Degree 7 years related experience or equivalent combination. Acceptable fields: Computer Science IT Computer Engineering Data Engineering or related.

Required & Preferred

• Experience Years Experience Required Preferred 7-10 yrs Progressive experience in enterprise data architecture analytics engineering or BI platform leadership.
• 7-10 yrs Hands-on experience with Microsoft Fabric including Lakehouses Direct Lake semantic models Dataflows Gen2 Data Pipelines and the Fabric OneLake architecture.
• 5-7 yrs Power BI semantic model development: DAX authoring composite models aggregation tables incremental refresh and deployment pipelines.
• 5-7 yrs Governance experience: dataset certification workspace governance RLS/OLS implementation sensitivity labels and data catalog/governance tooling integration (e.g. Microsoft Purview Alation Collibra or equivalent).
• 3-5 yrs SOX compliance for financial data systems including audit trail design change management controls access reviews and lineage documentation.
• 3-5 yrs Experience connecting third-party BI and analytics tools (e.g. Tableau Qlik Sense MicroStrategy Grafana) to XMLA-compatible semantic models including live connection architecture security passthrough and performance tuning.
• 2-4 yrs Experience integrating AI/LLM tools (e.g. Anthropic Claude Azure OpenAI) with structured data sources or semantic layer APIs for natural language querying or embedded analytics.
• 5-7 yrs Experience leading solution architecture and design reviews across multiple business workstreams with demonstrated executive presence.

Key Skills:

Data Solutions Architect Semantic Layer Microsoft Fabric PowerBI Data Modeling Sox Compliance