Senior Data & AI Architect, Technology, Data and AI Advisory

Leo Berwick

3d•$180,000 - $210,000

About The Position

Leo Berwick is hiring a Senior Data Architect for its Technology, Data and AI Advisory practice. This is a permanent, full-time, senior hands-on leadership role focused on designing, building, and scaling modern data platforms for private equity-backed companies. The role owns data architecture across platforms, integration, modeling, and governance, powering analytics and AI from client discovery through deployment and adoption. The successful candidate will lead and mentor a cross-functional team of data engineers, analysts, and visualization specialists, while remaining hands-on with pipelines, transformations, SQL, Python, platform configuration, and code review. The role also contributes to practice development, reusable architectures, commercial and strategic initiatives, and internal AI enablement. It offers work across industries, deal stages, and problem types, with direct interaction with C-suite portfolio-company leaders and private equity sponsors.

Requirements

At least 8 years of experience in data engineering or architecture, including at least 3 years in an architect or technical lead role.
Proven track record designing and delivering enterprise data platforms with clear business impact.
Deep expertise in data architecture and modeling, including dimensional modeling, Data Vault, and lakehouse/medallion approaches.
Expertise in data governance and the ability to drive client adoption.
Hands-on experience with modern cloud data platforms such as Snowflake, Databricks, Microsoft Fabric, or dbt.
Familiarity with applied AI use cases such as RAG and agent workflows.
Experience leading and developing technical teams and enabling people with diverse skill sets.
Experience writing production-grade SQL and Python and building data pipelines at scale.
Genuine curiosity about AI and sound judgment about where it applies.

Responsibilities

Define target-state data architectures and deliver scalable, pragmatic data platforms that support analytics and AI.
Lead delivery across the full project lifecycle, including discovery, design, development, testing and validation, deployment, hypercare, and monitoring and observability.
Design and build clean, well-documented conceptual, logical, and physical enterprise data models that represent the business.
Lead a cross-functional team of data engineers, analysts, and visualization specialists.
Mentor data engineers, analysts, and specialists, and set architecture, modeling, and engineering standards.
Translate complex technical concepts for non-technical clients and stakeholders.
Build data foundations for AI use cases, including quality, governance, lineage, and access, and assess where AI creates value and how repeatable solutions can scale.
Build pipelines and transformations, write SQL and Python, configure platforms, and review team code.
Present architectural recommendations and roadmaps to client leadership, including CIOs, CTOs, and private equity deal teams, and participate in engagement steering committees.
Contribute to firm-wide commercial and strategic initiatives, including reusable reference architectures and delivery accelerators.
Help shape practice offerings and contribute to business development, commercial strategy, and internal AI enablement initiatives.