ETL Test Engineer / Lead contract jobs Windsor, CT

Tech Mirrors; Windsor (CT); On-site; USD 110,000 - 150,000; Full time

Job summary

Tech Mirrors in Windsor, CT, is seeking an experienced ETL Test Engineer / Lead to own end-to-end data flows from Source Systems through Data Warehouse to dashboards. The role emphasizes leadership, data modeling, cloud data platforms, and strong SQL skills.

The ideal candidate will lead ETL testing teams, validate complex transformations, and collaborate with stakeholders to ensure accurate reporting in Power BI/Tableau. Onsite engagement required.

Qualifications

• Bachelor's or higher in CS, IS, or related field.
• Strong experience in ETL testing and data validation.
• Proven leadership and project delivery experience.

Responsibilities

• Lead end-to-end delivery of data integration projects from requirements to production deployment.
• Define project plans, milestones, risks, dependencies, and resources.
• Document data lineage across Source Systems to Dashboards.
• Perform impact analysis and trace data flow from source to dashboard.
• Analyze and validate transformation logic, mappings, and aggregations.
• Create source-to-target mappings and data validation strategies.
• Mentor ETL testing and data validation teams.
• Drive Agile ceremonies and release management.
• Provide status updates to leadership.
• Validate dashboards from source tables and data reconciliation.

Skills

ETL Testing

SQL

Data Lineage

Data Governance

Stakeholder Management

Leadership

Education

Bachelor's degree in CS/IS or related

Master's degree (preferred)

Tools

Snowflake

Matillion

DBT

Power BI

Tableau

SQL Server

Job description

Job Title: ETL Test Engineer / Lead
Location: Windsor, CT (Onsite)
Contract

Role Summary

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 indata warehousing, ETL processes, cloud data platforms, data modeling, and stakeholder management

Key Responsibilities

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

Technical Skills

• 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.

Management Skills

• Strong stakeholder management and communication skills.
• Ability to manage distributed offshore teams.
• Risk management, estimation, planning, and budget tracking expertise.

Preferred Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, or related field.
• Certifications in Snowflake, Mattilion, Advanced SQL, DBT
• Experience in Logistics, Supply Chain, Enterprise Data Transformation programs.