Senior Solutions Architect – Data & AI Platforms-Dallas, TX

Top Tempo Technical; Dallas (TX); On-site; USD 160,000 - 220,000; Full time

Job summary

Top Tempo Technical is seeking a Senior Solutions Architect to lead enterprise data platform modernization and governance from Dallas, TX. You will drive Snowflake, Microsoft Fabric, and lakehouse architectures, shaping data products for BI and AI initiatives.

The role blends strategic leadership with hands-on implementation, including data modeling, governance, and MDM principles, collaborating with stakeholders across technology and business to deliver scalable, reliable data foundations.

Qualifications

• 15+ years in data engineering, architecture, or analytics.
• 5+ years hands-on Snowflake experience.
• Experience with Microsoft Fabric or Azure Synapse Analytics.
• Proven ability to design enterprise-scale data lakehouse architectures.
• Hands-on data modeling, ETL/ELT, and data warehouse concepts.
• Strong communication with technical and business teams.

Responsibilities

• Lead enterprise architecture and modernization for Snowflake and Fabric.
• Review production Snowflake implementations and dbt models.
• Design scalable data lakehouse architectures and data products.
• Ensure governance, data quality, and lineage across BI/AI.
• Collaborate with stakeholders and vendors to deliver plans.
• Translate complex choices into actionable roadmaps.

Skills

Data engineering

Data architecture

Snowflake

dbt

ETL/ELT

MDM

Data governance

AI/ML

Communication

Tools

Snowflake

Microsoft Fabric

Azure Synapse Analytics

dbt

Power BI

Job description

TOP TEMPO TECHNICAL | TALENT SOLUTIONS

Senior Solutions Architect – Data & AI Platforms

Location: Dallas, TX
Salary: $160,000–$220,000 annually
Type: Full-time

Position Overview

We are seeking an accomplished Senior Solutions Architect to lead enterprise data platform modernization, architecture, and governance for an established organization. This highly visible role combines strategic leadership with hands‑on technical expertise across Snowflake, Microsoft Fabric, enterprise data engineering, modern data lakehouse architectures, and AI-ready infrastructure.

The successful candidate will play a key role in advancing the organization's enterprise data strategy, guiding the transition to a modern Snowflake-based ecosystem while establishing scalable, governed data foundations that support business intelligence, advanced analytics, and AI initiatives. This is a hands‑on technical leadership position, not a purely advisory role.

Key Responsibilities

• Lead enterprise architecture and modernization initiatives across Snowflake and Microsoft Fabric, with attention to scalability, performance, reliability, and continuity.
• Review and validate production‑grade Snowflake implementations, dbt transformation models, semantic models, and data integration processes.
• Design enterprise‑scale data lakehouse architectures, reusable data products, and effective data modeling standards.
• Evaluate integration and interoperability between Microsoft Fabric and Snowflake; troubleshoot complex data movement and platform reliability issues.
• Lead technical evaluations of semantic layers, master data management (MDM), and data governance technologies; recommend cohesive, practical solutions.
• Establish consistent business definitions, data quality standards, lineage, and governance practices across BI and AI consumers.
• Design governed data foundations for AI/ML, natural‑language analytics, and emerging AI applications.
• Collaborate with business stakeholders, leadership, engineering teams, vendors, and implementation partners; challenge assumptions and validate technical deliverables.
• Translate complex architectural choices into clear recommendations and actionable plans.

Required Qualifications

• 15+ years of experience in data engineering, data architecture, analytics, or related disciplines.
• 5+ years of in‑depth, hands‑on Snowflake experience, including architecture and production implementation.
• Experience architecting and delivering production‑grade data platforms using Microsoft Fabric or Azure Synapse Analytics.
• Proven experience designing and delivering enterprise‑scale data lakehouse architectures and data products.
• Experience architecting data infrastructure supporting AI/ML applications.
• Hands‑on knowledge of dbt, enterprise data modeling, ETL/ELT, integration, and data warehouse architecture.
• Strong understanding of semantic modeling, data governance, data quality, and MDM principles.
• Ability to independently assess implementations, solve complex technical problems, and communicate effectively with technical and business audiences.

Preferred Qualifications

• Snowflake and Microsoft Fabric interoperability, Apache Iceberg, or catalog integrations.
• Snowflake Semantic Views, Snowflake Cortex, or AI‑powered analytics.
• Power BI, Direct Lake, and enterprise reporting architectures.
• Ontology‑based semantic technologies and enterprise semantic layers.
• MDM tools such as Profisee; Microsoft Dynamics 365 or Dataverse.
• Experience with third‑party implementation partners and complex multi‑entity data models.

Why Consider This Opportunity

Influence major enterprise data architecture decisions while working with modern cloud, analytics, and AI technologies.

Partner closely with technology leadership and help establish trusted, governed foundations for the next generation of enterprise data products.

Compensation & Location

Annual salary range: $160,000–$220,000, depending on qualifications and experience.

Dallas, Texas