Tableau Architect

Emergere Technologies
Dallas, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Dallas, United States of America

Tech stack

Query Performance
API
Artificial Intelligence
Data analysis
Business Logic
Computing Platforms
User Authentication
Azure
Cloud Computing
Code Generation
Data Governance
Data Migration
Python
Metadata
Microsoft SQL Server
Open Database Connectivity
Performance Tuning
SQL Databases
SQL Server Analysis Services
Tableau
Prompt Engineering
HybridCloud
Microsoft Fabric
Kubernetes
Data Lineage
Virtual Agents
REST
Data Pipelines

Job description

We are seeking an experienced Tableau Architect to lead a critical data migration and discovery engagement involving 600+ enterprise Tableau dashboards transitioning from on-premises SQL Server to Microsoft Fabric. This role combines deep Tableau platform architecture expertise with extensive Microsoft Fabric knowledge to architect the strategy, design Fabric Semantic Models, analyze existing dashboard infrastructure, and deliver comprehensive discovery documentation with optimization recommendations. You will work with Agentic AI systems leveraging Tableau MCP and SQL Server MCP to automate discovery workflows, generate migration scripts, and produce data lineage mappings. The ideal candidate brings extensive Tableau architecture experience, proven implementation expertise, strong data analysis capabilities, and a track record leading large-scale BI migration projects., 1. Lead discovery engagement to inventory and analyze 600+ Tableau dashboards, mapping all data source connections from SQL Server/excels/files to Tableau.

  1. Design Tableau-to-Fabric connection strategy including authentication methods, connector selection (SQL endpoint, XMLA, ODBC), and Live vs Extract architecture decisions
  2. Architect Fabric Semantic Models optimized for Tableau consumption, defining measures, relationships, row-level security, and aggregation strategies to maximize performance
  3. Perform comprehensive data lineage analysis to map Data Sources including Excels/Files/SQL Server databases, tables, and views to Fabric Lakehouse, Warehouse, or Semantic Model equivalents
  4. Develop optimization recommendations including query performance improvements, semantic model consolidation, extract refresh strategies, and dashboard redesign opportunities
  5. Leverage Agentic AI with Tableau MCP and SQL Server MCP to automate metadata extraction, inventory, and dashboard dependency analysis
  6. Analyze Direct SQL/custom SQL queries, calculated fields, LODs and business logic within dashboards to identify migration complexities and transformation requirements
  7. Create migration wave recommendations with priority-based phasing strategy, risk assessment, rollback plans, and detailed effort estimates for execution, Tableau Server · Tableau MCP · SQL Server · SQL Server MCP · SQL Server Analysis Services · Microsoft Fabric · Fabric Semantic Models · Fabric Lakehouse · Agentic AI · Python · Tableau REST API · Azure

Requirements

  1. 14+ years of experience with Tableau administration, architecture, and performance tuning in enterprise environments
  2. Deep expertise with Tableau Server, Tableau Cloud, Tableau REST API, and Tableau Metadata API for programmatic dashboard analysis
  3. Proven experience leading Tableau migration projects including connection redirection, data source consolidation, or platform upgrades affecting 200+ dashboards
  4. Hands-on experience with Tableau MCP and SQL Server MCP integration for AI-driven automation and metadata extraction workflows
  5. Extensive hands-on experience with Microsoft Fabric including Lakehouse, Warehouse, Semantic Models, data pipelines, and Direct Lake mode configurations
  6. Proven experience designing and implementing Fabric Semantic Models with optimized measures, relationships, and security for enterprise analytics consumption
  7. Strong background in data analysis, SQL Server Analysis Services (SSAS), and translating complex data models across platforms
  8. Experience with Agentic AI systems and designing workflows that leverage AI agents for discovery, analysis, and code generation tasks, 17. Tableau Certified Architect certification
  9. Microsoft Fabric Analytics Engineer Associate or Data Engineer Associate certification
  10. Experience with AI agent orchestration frameworks and prompt engineering for technical automation workflows
  11. Knowledge of data governance frameworks, row-level security migration, and enterprise authentication strategies
  12. Familiarity with Fabric data pipelines, incremental refresh patterns, and hybrid cloud-to-on-premises connectivity

Apply for this position