Architect II - Enterprise Solutions

Tekwissen

Overview:

TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client provider of digital technology and transformation, information technology and services

Position: Architect II - Enterprise Solutions

Location: Frisco TX, Overland Park KS , Atlanta GA

Duration: 7 Months

Job Type: Temporary Assignment

Work Type: Hybrid

Job Description:

Job Summary:

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 Bachelor's 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[RATE REDACTED]yrs Progressive experience in enterprise data architecture, analytics engineering, or BI platform leadership.
[RATE REDACTED]yrs Hands-on experience with Microsoft Fabric including Lakehouses, Direct Lake semantic models, Dataflows Gen2, Data Pipelines, and the Fabric OneLake architecture.
[RATE REDACTED]yrs Power BI semantic model development: DAX authoring, composite models, aggregation tables, incremental refresh, and deployment pipelines.
[RATE REDACTED]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).
[RATE REDACTED]yrs SOX compliance for financial data systems including audit trail design, change management controls, access reviews, and lineage documentation.
[RATE REDACTED]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.
[RATE REDACTED]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.
[RATE REDACTED]yrs Experience leading solution architecture and design reviews across multiple business workstreams with demonstrated executive presence.
X Key Focus Areas Microsoft Fabric & Semantic Model Platform Architect and govern the enterprise semantic layer in Microsoft Fabric, including Direct Lake models on OneLake, composite model strategies, and Power BI Premium/Fabric capacity planning
Define standards for model partitioning, incremental refresh, and aggregation table patterns to meet performance SLAs across diverse workstreams
Own deployment pipeline strategy across Dev / Test / Prod Fabric workspaces, including Git integration, XMLA scripting, and Tabular Editor automation
Establish DAX coding standards, measure naming conventions, and reusable calculation groups shared across workstream models
Workstream Semantic Model Delivery Partner with Finance, Operations, Marketing, HR, and Technology workstream leads to gather requirements and deliver purpose-built certified semantic models
Document business glossary mappings, metric definitions, and lineage for each workstream model to support self-service analytics and reduce shadow
IT Facilitate model reviews and sign-off with data owners, ensuring models meet certification criteria before promotion to production Governance, Certification & SOX Compliance
Define the end-to-end dataset certification process: quality gates, ownership assignment, certification badges, and renewal cadence Implement row-level security (RLS) and object-level security (OLS) patterns aligned to organizational access control policies and RBAC structures
Design SOX-compliant data lineage and change management controls for financial semantic models including audit trails, access reviews, and separation of duties
Integrate with enterprise data catalog and governance tooling (evaluation in progress candidates may include Microsoft Purview, Alation, Collibra, or equivalent) for data lineage, sensitivity labeling, and compliance monitoring across Fabric workspaces Tool Integration: BI Platforms, Anthropic & Other Consumers Architect connectivity between Fabric semantic models and third-party BI and analytics tools (including Tableau, Qlik Sense, MicroStrategy, Grafana, and others) via XMLA endpoints, OData, or direct query APIs optimizing live connection performance, pass-through security, and certified dataset reuse across consumption platforms
Define integration patterns for Anthropic Claude and other LLM-based tools to query semantic layer data safely, including prompt-to-DAX patterns, scoped data access, and output validation
Support Excel, Power BI Desktop, and other BI tools in consuming shared certified models, and document connectivity guides for each consumer type Advise on emerging AI-augmented analytics use cases that leverage the semantic layer as a governed data foundation for natural language interfaces

TekWissen® Group is an equal opportunity employer supporting workforce diversity.

Apply

Vacancy posted 21 hours ago

Similar jobs that could be interesting for youBased on the Architect II - Enterprise Solutions in Overland Park, KS vacancy

UI Architect - .NET, React & Enterprise Banking Solutions
...Job Description Job Description Job Title: UI Architect – .NET, React & Enterprise Banking Solutions Location: Kansas City, Missouri Responsibilities Lead the architecture, design, development, and modernization of a large-scale SaaS platform built on .NET...
Suggested
Local area
System One
Kansas City, KS
a month ago
Enterprise Solutions Architect
$150k - $200k
## Enterprise Solutions ArchitectApplylocations: Saint Louis, MOtime type: Full timeposted on: Posted Todayjob requisition id: JR1041115**We... ...**We are seeking an experienced Enterprise Solutions Architect with proven oracle expertise and a strong azure and experience...
Suggested
Temporary work
Shift work
Synechron
Kansas City, MO
2 days ago
Enterprise Solutions Architect
...10/2026 Job Description OTSI (Object Technology Solutions, Inc) has an immediate opening for a Solutions Architect Solutions Architect - Kansas City We are seeking... ...high‑value customer opportunities and modernize enterprise data and AI ecosystems. Key Responsibilities Design...
Suggested
Immediate start
Premier Inn Hotels LLC (UAE)
Kansas City, MO
2 days ago
Solution Architect
...As the Solution Architect , you will be responsible for designing, implementing, and governing robust, scalable cloud solutions that align... ...ensuring that both logical and physical architectures align with enterprise standards. Leveraging your knowledge of current technologies...
Suggested
Immediate start
Quality Technology Services, LLC
Overland Park, KS
2 days ago
Solutions Architect
$114.1k - $163.13k
...educators, and employers with outcomes-based, data-driven solutions across the lifecycle of learning. From testing to... ...on to learn more. WHAT YOU\'LL DO The Solution Architect role is a critical member of the Enterprise Applications team, creating the overall technical...
Suggested
Full time
Work experience placement
Work at office
Local area
Remote work
Flexible hours
Laudio LLC
Leawood, KS
7 hours ago
Solutions Architect
...LightEdge Solutions is developing the IT solutions that will propel... ...a customer-focused Solutions Architect to design and deliver scalable... ...solutions for mid-market and enterprise customers. In this role, you’... ...3.2, and SSAE 18 SOC 1 Type II, SOC 2 Type II and SOC 3. We...
Light Edge
Kansas City, MO
5 days ago
Solution Architect
$114.1k - $163.13k
...Solution Architect Location: Leawood, KS, US, 66211 Burlington, MA, US, 01803 We Impact Lives Through Purpose-Driven Work in A People First... ...DO The Solution Architect role is a critical member of the Enterprise Applications team, creating the overall technical vision for...
Full time
Work experience placement
Work at office
Local area
Remote work
Flexible hours
Ascend Learning
Leawood, KS
5 days ago
Solutions Architect
...Type: Full-Time About the Role We are seeking a hands-on Solutions Architect to join our team and help modernize our Nursing education platform... ...Strong understanding of software design patterns, enterprise integration, and cloud architecture Excellent communication...
Full time
Work at office
1 day per week
AppleOne Employment Services
Leawood, KS
1 day ago
Solution Manager
## Solution ManagerApplyremote type: Onsitelocations: Overland Park, KStime type: Full timeposted on: Posted Yesterdayjob requisition... ...deliver best-in-class solutions to clients.This role is for our Enterprise team and will play a key role in transforming healthcare...
Full time
Work experience placement
WellSky
Overland Park, KS
5 days ago
Solutions Architect - Media/Broadcast Enterprise Systems
...Reporting to the Director of File Based Solutions, you work between Evertz clients,... ...and executive management to completely architect, design and document the requirements and... ...implementation approach for Evertz end-to-end enterprise solutions for broadcast and media...
Full time
Evertz Microsystems Limited
Kansas City, KS
more than 2 months ago
Solutions Architect
...Accenture in Overland Park, Kansas is seeking a Specialist to develop Google GECX CCaaS solutions. This role requires experience in technology transformations and a strong knowledge of CCaaS strategies. The candidate will work closely with clients to design and implement...
Flagship Kansas
Overland Park, KS
7 hours ago
Solutions Architect
$250k - $350k
...cybersecurity, automation, and AI-driven solutions. Backed by leading investors, we are... ...MDR landscape. As a Staff AI Solutions Architect at TENEX, you will be a critical technical... ..., building, and deploying large-scale, enterprise-grade AI/ML systems in a production...
Full time
TenEx
Kansas City, KS
7 hours ago
Solutions Architect
...Join HarvestROI as a Solutions Architect to design scalable, data-driven solutions that transform businesses. Apply now to make a lasting impact. The Solutions Architect is responsible for designing scalable, data-driven solutions that align business objectives with technical...
Full time
Harvest ROI
Mission, KS
3 days ago
Solution Architect
$116.5k - $150.5k
...through innovative business architecture, solution architecture, and process optimization;... .... Role Description As a Solution Architect, you will play a key role in designing scalable... ...into solution designs that align with enterprise architecture standards while supporting...
Full time
Work at office
Work from home
Flexible hours
3 days per week
Safety National
Kansas City, MO
19 hours ago
Cloud Solution Architect
...Quality Technology Services, LLC in Overland Park, Kansas is looking for a Solution Architect to design, implement, and govern scalable cloud solutions that align with business objectives. In this pivotal role, you will connect business strategy with technical execution...
Quality Technology Services, LLC
Overland Park, KS
7 hours ago
Principal Integration Solution Architect - Energy & Utilities
...oil & gas, and heavy industry. Our Technology Solutions team is at the forefront of innovation across Grid... ...systems. We are seeking a Principal Integration Architect to help lead this evolution by connecting enterprise platforms with industrial and operational environments...
Work experience placement
Flexible hours
Black & Veatch Family of Companies
Overland Park, KS
7 days ago
Enterprise Architect
$117.1k - $152.65k
...day. To learn more, please see What you'll do here: As an Enterprise Architect in our Cengage Digital organization, you will be responsible... ...and strategic state architectures. Evaluate and present solutions including how to apply them to market group business needs...
Work experience placement
Live in
Local area
Worldwide
Cengage Group
Kansas City, MO
3 days ago
Enterprise Architect
...McKesson is seeking an Engagement Strategist to design and execute member engagement strategies across healthcare solutions. You will partner with Product, Engineering, Analytics, Operations, and Commercial teams to drive awareness, adoption, and behavior change throughout...
McKesson’s Corporate
Overland Park, KS
7 hours ago
Enterprise Architect
$100k - $230k
...cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and expert strategic counsel in... ...more information, visit WPP.com. Enterprise Architect The delivery Enterprise Architect (EA) serves...
Work at office
VML South Africa
Kansas City, MO
7 hours ago
SharePoint Architect
...Worked extensively on Pre-sales activities, solutioning, project planning etc 6. Should be able... ...7. Having very good confidence on architecting / designing projects in SharePoint 2010... ...Having .Net background and knowledge of IIS, different versions of .net, sound database...
Work at office
Avance Consulting
Overland Park, KS
1 day ago
Test Automation Architect
$125k - $140k
...removal, is looking for a Test Automation Architect in Vancouver (also open to Kansas City... ...vision, architect, and govern the enterprise-wide automated testing framework, including... ...ecosystems. Ownership: Drives solutions with strong technical accountability....
Contract work
Work at office
Remote work
RBDS Rubbish Boys Disposal Service Inc.
Mission, KS
4 days ago
Client Solutions Manager
$100k
...card processing company that has over a decade of industry experience. Slice Merchant Services offers innovative payment processing solutions to merchants. Slice has put together a comprehensive package of products and services. Slice delivers a consultative approach on...
Local area
Slice Merchant Services
Prairie Village, KS
4 days ago
Enterprise Architect, Commercial IT/CRM
$117.1k - $187.3k
...every day. To learn more, please see SUMMARY As a Senior Enterprise Architect within Commercial IT, you will help shape the future of Cengage... ...CRM capability rather than a collection of disconnected solutions. You will partner closely with Commercial IT leadership, Technology...
Local area
Worldwide
Cengage Group
Kansas City, MO
2 days ago
Principal Architect
$152.07k - $202.76k
...across cloud, edge, and AI workloads for enterprises, governments, and communities. At... ...for a strategic and technical Principal Architect to design the new architecture evolution... ...scalable, secure, and high-performing solutions on AWS. This Engineer also understands...
Full time
Temporary work
Remote work
Lumen
Overland Park, KS
2 days ago
Process Architect
$75k - $120k
...Life Sciences Facilities. At GBA, we’re a collaborative team of architects, engineers, and technical specialists dedicated to creating... ...workflows and help translate process narratives into spatial planning solutions. Develop planning-driven layouts that integrate process flow,...
Work at office
Flexible hours
GBA
Lenexa, KS
3 days ago
Architectural Designer II
...Catheters, Incontinence, Ostomy, and Wound Care Products. Prospect new leads and reach out to educate them on Numotion’s mobility solutions Develop relationships with the decision makers of clinical accounts Make product recommendations to the client that best suite their...
Base plus commission
Work experience placement
Johnson, Mirmiran & Thompson
Kansas City, MO
2 days ago
Project Architect
$45 - $53 per hour
...Job Title: Project ArchitectJob Description The Project Architect leads complex, large-scale educational projects from concept through... ...global leader in engineering and sciences services and talent solutions. We help visionary companies advance their engineering and...
Contract work
Temporary work
Casual work
Work at office
Actalent
Overland Park, KS
3 days ago
Solutions Engineer
$200k - $240k
...Ironclad Inc. is seeking a Solutions Engineer to work closely with prospects in Mission, Kansas. The role involves listening to client... ...prospects in selecting Ironclad. Ideal candidates have 5+ years of Enterprise Solution Engineering experience and strong communication...
Ironclad Inc
Mission, KS
1 day ago
Principal Solutions Architect
...Allied OneSource is seeking a Principal Solutions Architect to lead the design and delivery of AI‑driven solutions in a regulated environment. The role combines hands‑on architecture with strategic influence—owning end‑to‑end solution design, identifying high‑impact AI...
Allied OneSource
Kansas City, MO
7 hours ago
AWS Solution Architect
...A leading technology solutions provider seeks a Python and AWS Technical Architect to partner with stakeholders and teams. This role involves leading technical design, creating scalable solutions, and ensuring code quality. Key responsibilities include requirements analysis...
Softcom Systems
Kansas City, MO
7 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Architect II - Enterprise Solutions. Be the first to apply!