> Markdown version of [/jobs/ext/2606391-etl-test-lead](https://www.wearedevelopers.com/jobs/ext/2606391-etl-test-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ETL Test Lead

- **Company:** IT Minds LLC
- **Location:** Windsor, CT, United States
- **Experience:** Expert
- **Salary:** $140,712.0
- **Contract:** Permanent contract
- **Skills:** Artificial Intelligence, Data Analysis, Profiling, Data Validation, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Mart, Data Systems, Data Warehousing, Dimensional Modeling, Microsoft SQL Server, Scrum Methodology, Query Optimization, Release Management, Power BI, Cloud Services, Standard Sql, Software Deployment, SQL Stored Procedures, SQL Databases, Data Streaming, Tableau (Software), Freeform SQL, Sql Optimization, Snowflake, Data Lineage, Star Schema, Looker Analytics
- **Published:** August 29, 2026
- **Apply:** https://www.careerjet.com/jobad/usbe223e5f0838ffb77a5f821dfe5a2d7e

## About the Role

Cloud Data Platforms: Snowflake
ETL/ELT Tools: Matillion, DBT
Databases: SQL Server
SQL Expertise: Advanced SQL, Advanced Stored Procedures, CTEs, Window Functions, Query Optimization,
BI & Reporting: Power BI,
Data Modeling: Star Schema, Snowflake Schema, Dimensional Modeling
Data Engineering Concepts: Data Lineage, Data Governance, Data Quality, Data Reconciliation
Strong understanding of Data Modeling concepts (Star Schema, Snowflake Schema, Dimensional Modeling).
Hands-on experience with BI & Reporting tools such as Power BI, Tableau, or Looker.
Familiarity with AI-enabled data solutions and automation frameworks.
Management Skills
Strong stakeholder management and communication skills.
Ability to manage distributed offshore teams.
Risk management, estimation, planning, and budget tracking expertise.

## Description

We are looking for an experienced ETL & SQL Lead with strong expertise in understanding and analyzing complex end-to-end data flows from Source Systems through Data Warehouse/Data Mart layers to Reporting and Dashboard platforms, drive the end-to-end project execution and lead the team in the project delivery.
The ideal candidate will possess strong expertise in data warehousing, ETL processes, cloud data platforms, data modeling, and stakeholder management, Project & Delivery Management
Lead end-to-end delivery of elements projects from requirements understanding through production deployment.
Define project plans, milestones, risks, dependencies, and resource allocations.
Understand and document complex data lineage across multiple layers (Source Systems, Landing/Staging Layers, Integration/Transform Layers, Data Warehouse, Data Marts, Semantic/Reporting Layer, Power BI/Tableau dashboards)
Perform impact analysis and trace data flow from source to dashboard.
Analyze and validate business rules, transformation logic, mappings, and aggregations across layers.
Create source-to-target mappings and data validation strategies.
Lead ETL testing teams, data reconciliation, and root cause analysis activities.
Write complex SQL queries and understand existing code base in the form Stored procedures for data analysis, profiling, and defect investigation.
Mentor team members on SQL, ETL testing, and data validation techniques.
Drive Agile ceremonies, sprint planning, and release management activities.
Provide regular status updates to leadership and stakeholders.
Define strategies for validating dashboards from source tables, data reconciliation, validation of the data between layers and Dashboards Automation solutioning.
Stakeholder Management
Understand data requirements from business and translate them into testable requirements
Act as the primary point of contact between QE , Business and Dev Team


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Profiling Symfony & PHP apps with Blackfire](https://www.wearedevelopers.com/videos/265-profiling-symfony-php-apps-with-blackfire)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Enhancing Workload Security in Kubernetes](https://www.wearedevelopers.com/videos/356-enhancing-workload-security-in-kubernetes)
- [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)