Senior Technical Lead

We have a strategic opportunity within EDAO to build and implement AI-assisted engineering capabilities across 31 production dbt projects in the Marketing Analytics portfolio. The initiative will integrate GitHub Copilot with dbt, Snowflake, GitLab, Jira, Confluence, dbt Cloud, and CTM workflows to accelerate delivery while maintaining governance and human oversight.

Key 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 Fusion.
• Use 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.

Skill Requirements

• Skill set: DBT, Snowflake, Python, and AI
• USAA experience is mandatory

Other Requirements

The selected resources will contribute to AI-driven engineering solutions covering requirements analysis, impact assessment, development, automated testing, deployment orchestration, reconciliation, and production support.

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026totaled $14.8billion.

Compensation and Benefits

A candidate’s pay within the range will depend on their skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year.