Title: ETL Test Lead
Skills: Data Warehousing, ETL processes, Snowflake, Power BI, SQL Queries, ETL testing, Cloud Data Platforms, Data Modeling, etc
Experience: 10 + years
Hiring Type: Video Interview
Location: Windsor CT (Onsite Job)
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 in data 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.
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.
ETL Test Lead • Windsor, CT, United States
Location: Remote or Hartford, CT.Must Have Technical/Functional Skills.Must have at least 10 years work experience in Guidewire testing.Must have experience in Property and Casualty Insurance domai... Show more
Integrated Product Team Leader.Ensign-Bickford Aerospace and Defense Company.This role is based on site in one of our facilities.The Integrated Product Team Leader is responsible for leading cross ... Show more
Integrated Product Team Leader.This opportunity is located within our Ensign-Bickford Aerospace & Defense Company business, a global leader of mission-critical hardware and systems solutions includ... Show more
Engineering Manager / Delivery LeadHartford, CT OR Eden Prairie, MNHybrid RoleABOUT THE ROLEOur client is seeking an experienced Engineering Manager / Delivery Lead to oversee Agile teams in delive... Show more
Quest Global delivers world-class end-to-end engineering solutions by leveraging our deep industry knowledge and digital expertise.By bringing together technologies and industries, alongside the co... Show more
The Business Analyst shall develop the Business Requirements and test plans, conduct Business Data Analysis, prepare and maintain requirement traceability matrix, develop source 2- target mapping,... Show more
The Quality Assurance Manager is responsible for managing and enforcing all quality assurance and (QA) operations at GTI's production facilities.Specifically, the Quality Assurance Manager will pla... Show more
TestRequirementsTest Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test TestTest Test Test Test Test Test Test Test Test Test Test TestTes... Show more
Earn up to $400/week, depending on the number and type of studies you complete.Share honest feedback on products and services from independent brands.Assignments include short online surveys (10–20... Show more
Director of Quality Assurance (QAD).Reports to: CSO Location: New Britain, CT & Holyoke, MA Work Location: In person, with travel between both sites.Compensation: $90,000 $140,000 per year (depend... Show more
Encore Fire Protection is a leading full-service fire protection company serving the Northeast from Maine to Louisiana.With over 2,000 employees and 50,000+ customers, our mission is to save lives ... Show more
Senior Principal Integrated Product Team Lead (IPTL)Pratt & Whitney is working to once again transform the future of flightdesigning, building and servicing engines unlike any the world has eve... Show more
Overall 8-9 years relevant experience in Wintel & Virtualization technologies and 1-2 years Azure Cloud hands on experience.Job requires managing & supporting VDI Infrastructure hosted on Azure pub... Show more
High level Azure Cloud infrastructure PM who is focused on delivering Cloud Solutions.Needs people who have energy and resolve to drive things forward - someone who can drive progress and has stron... Show more
This is a test job, pls do not apply.This is a test job, pls do not apply.This is a test job, pls do not apply.This is a test job, pls do not apply.This is a test job, pls do not apply.This is a te... Show more
Pratt & Whitney is working to transform the future of flightdesigning, building and servicing engines unlike any the world has ever seen.And because transformation begins from within, we're seeking... Show more
Ayr Wellness Inventory Lead Position.AYR Wellness is a publicly traded, multi-state cannabis company with more than 85 dispensaries.We are one of the largest scale producers of high-quality cannabi... Show more
Strong communication, solid L2/L3 exposure, leadership-level client engagement, and a proven ability to identify improvement areas in existing applications.Experience in engaging with senior client... Show more
Deloitte is committed to providing reasonable accommodations for people with disabilities.If you require a reasonable accommodation to participate in the recruiting process, please direct your inqu... Show more
Technology Lead | Infrastructure Testing | Operational Readiness Testing (ORT).Business Readiness Lead will be responsible for planning, coordinating, and executing a variety of business and operat... Show more
