Technical Lead
Overview:
In this role you will help build AI-assisted engineering capabilities across 31 production dbt projects within the Marketing Analytics portfolio. You will integrate AI-powered workflows with dbt, Snowflake, and collaboration tools to accelerate delivery while preserving governance and human oversight. You will design reusable AI skills and automation across data engineering tasks, from model generation to deployment readiness. You will work closely with cross-functional teams to scale AI across the analytics estate and ensure reliable production operations.
Responsibilities:
- Design and build reusable AI skills, prompts, agents, and instruction files for dbt and data engineering workflows
- Develop AI capabilities for Jira story intake, impact analysis, technical design, dbt model generation, testing, and code review
- Build automation for CTM configuration validation, dependency sequencing, scheduling alignment, and deployment-readiness checks
- Develop deployment skills covering GitLab merge requests, CI/CD pipelines, dbt Cloud execution, release runbooks, and change evidence
- Build automated regression-testing and data-reconciliation capabilities across development, pre-production, and production environments
- Apply strong hands-on knowledge of dbt models, macros, materializations, incremental strategies, tests, documentation, lineage, and dbt FusionUse Snowflake metadata, dbt manifests, GitLab repositories, and lineage information to identify upstream and downstream change impacts
- Develop Python-based automation for API integration, metadata processing, validation, structured outputs, and workflow orchestration
- Create reusable engineering standards for SQL, dbt, testing, data modeling, error handling, observability, and repository structure
- Build AI-assisted support for pipeline monitoring, data freshness, anomaly analysis, defect investigation, and production reconciliation
- Integrate AI-assisted workflows with GitHub Copilot, Jira, Confluence, GitLab, Snowflake, dbt Cloud, CTM, and approved MCP servers
- Create golden datasets and evaluation scenarios to measure AI-draft acceptance, accuracy, rework, test coverage, and edge-case handling
- Review AI-generated artifacts for business-logic accuracy, maintainability, security, performance, and compliance with project standards
- Support pilot implementation, developer enablement, troubleshooting, and scaled adoption across the dbt project estate
- Collaborate with developers, technical leads, architects, QA teams, platform teams, and deployment stakeholders throughout the lifecycle
Key requirements:
DBTSnowflakePythonAIUSAA experience is mandatory Experience with AI-driven engineering solutions covering requirements analysis, impact assessment, development, automated testing, deployment orchestration, reconciliation, and production supportcross-functional collaborationproblem-solvingcommunicationDBTSnowflakePython