Senior Data & AI Architect, Data and AI Advisory

Leo Berwick

. Define target-state data architectures and deliver scalable data platforms supporting analytics and AI .

Posted 11/9/2026full-timeRemote • United StatesSenior💰 $180,000 - $210,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive expertise in data architecture and modeling, with a strong focus on building scalable data platforms and pipelines for analytics and AI. Proven ability to lead cross-functional teams and mentor technical members while ensuring data governance and quality.

Highest-signal resume keywords

Data ArchitectureData GovernanceSQLPythonCloud Data Platforms

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ModelingDimensional ModelingData VaultLakehouse ApproachBuilding Data PipelinesData TransformationsData QualityData LineageAI Use CasesTechnical Leadership

Soft Skills

MentoringCommunicationCollaborationCuriosityJudgment

Tools & Technologies

SnowflakeDatabricksMicrosoft FabricDbt

Industry Keywords

AnalyticsAIData EngineeringTechnical LeadCross-Functional Team

Tech Stack

Tools & technologies

CloudPythonSnowflakeSQLVault

About the role

Key responsibilities & impact

Define target-state data architectures and deliver scalable data platforms supporting analytics and AI
Lead delivery across discovery, design, development, testing and validation, deployment, hypercare, and monitoring and observability
Design and build conceptual, logical, and physical enterprise data models
Lead a cross-functional team of data engineers, analysts, and visualization specialists
Mentor technical team members and establish architecture, modeling, and engineering standards
Translate complex technical concepts for non-technical clients and stakeholders
Build data quality, governance, lineage, and access foundations for AI use cases
Build pipelines and transformations, write SQL and Python, configure platforms, and review code
Present architectural recommendations and roadmaps to CIOs, CTOs, PE deal teams, and client leadership
Participate in steering committees throughout engagements
Contribute to firm-wide commercial and strategic initiatives, including reusable reference architectures and delivery accelerators

Requirements

What you’ll need

8+ years in data engineering or architecture, including 3+ years in an architect or technical lead role
Deep expertise in data architecture and modeling, including dimensional, Data Vault, and lakehouse/medallion approaches
Expertise in data governance and ability to drive adoption with clients
Hands-on experience with modern cloud data platforms such as Snowflake, Databricks, Microsoft Fabric, and dbt
Familiarity with applied AI use cases such as RAG and agent workflows
Experience leading and developing technical teams
Production-grade SQL and Python experience
Experience building data pipelines at scale
Genuine curiosity about AI and strong judgment on where it applies

Benefits

Comp & perks

Bonus eligibility
Comprehensive health benefits
Medical insurance
Dental insurance
Paid time off
Equity participation tied to the value created