Sr ETL Architect at QUANTUM TECHNOLOGIES LLC

Job description

body> Job Description Job Overview • Job ID: J51704 • Job Title: Sr ETL Architect • Location: Windsor, CT • Duration: 24 Months + Extension • Hourly Rate: Depending on Experience (DOE) • Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, L2-EAD, GC-EAD • Client: To Be Discussed Later • Employment Type: W-2, 1099, C2C View All Jobs Similar Jobs • AI Architect - Hoboken, NJ • .Net Architect - Little Rock, AR • .NET Architect - Tallahassee, FL • SAP SCM (Supply Chain Management) Architect - Chicago, IL • Dot Net Architect - TALLAHASSEE, FL Job Details Job Description: About the Role We are seeking an experienced ETL Architect with strong expertise in Snowflake and AWS Cloud ecosystem to design, develop, and optimize data integration solutions. The ideal candidate will be responsible for architecting scalable ETL pipelines, enabling efficient data movement, transformation, and integration across enterprise systems to support business intelligence, analytics, and advanced data initiatives. Key Responsibilities Design and implement ETL architecture, frameworks, and best practices for large-scale data integration projects. Architect and optimize Snowflake-based data warehouse solutions including schema design, performance tuning, and query optimization. Lead the migration of existing data platforms to AWS cloud-native solutions. Develop robust data pipelines using ETL/ELT tools, SQL, and Python/Scala. Integrate data from diverse sources (databases, APIs, streaming platforms, flat files, SaaS applications). Implement data governance, metadata management, and security best practices across data pipelines. Collaborate with data engineers, analysts, and business stakeholders to ensure high-quality, reliable data delivery. Drive automation of data workflows, monitoring, and error handling. Provide technical leadership, mentoring, and architectural guidance to engineering teams. Required Skills & Qualifications 10+ years of experience in data engineering, ETL development, or data architecture. Proven expertise with Snowflake (Data Modeling, Virtual Warehouses, Query Performance Tuning, Security & Access Control). Strong knowledge of AWS services such as S3, Redshift, Glue, Lambda, EC2, RDS, CloudFormation, and IAM. Hands-on experience with ETL/ELT design and implementation using tools like Informatica, Talend, Matillion, AWS Glue, or equivalent. Strong programming and scripting skills (SQL, Python, Shell, Scala or Java). Solid understanding of data lake and data warehouse architectures. Experience with streaming technologies (Kafka, Kinesis, Spark Streaming) is a plus. Familiarity with DevOps, CI/CD pipelines, and Infrastructure as Code (IaC) for data deployments. Excellent problem-solving, communication, and leadership skills. Preferred Qualifications Snowflake certification (SnowPro Architect/Advanced). Experience with modern data orchestration frameworks (Airflow, dbt, Step Functions). Background in big data ecosystems (Hadoop, Spark) Apply Now Equal Opportunity Employer QUANTUM TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. QUANTUM TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will QUANTUM TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract

Requirements

Must-haves

Job Overview
Sr ETL Architect
24 Months + Extension
Depending on Experience (DOE)
US Citizen, Green Card, OPT-EAD, CPT, H-1B,
To Be Discussed Later
View All Jobs
Similar Jobs
AI Architect - Hoboken, NJ
.Net Architect - Little Rock, AR
.NET Architect - Tallahassee, FL
SAP SCM (Supply Chain Management) Architect - Chicago, IL
Dot Net Architect - TALLAHASSEE, FL
Design and implement ETL architecture, frameworks, and best practices for large-scale data integration projects.
Architect and optimize Snowflake-based data warehouse solutions including schema design, performance tuning, and query optimization.
Lead the migration of existing data platforms to AWS cloud-native solutions.
Develop robust data pipelines using ETL/ELT tools, SQL, and Python/Scala.
Integrate data from diverse sources (databases, APIs, streaming platforms, flat files, SaaS applications).
Implement data governance, metadata management, and security best practices across data pipelines.
Collaborate with data engineers, analysts, and business stakeholders to ensure high-quality, reliable data delivery.

Nice-to-haves

Experience with streaming technologies (Kafka, Kinesis, Spark Streaming) is a plus.
Snowflake certification (SnowPro Architect/Advanced).
Experience with modern data orchestration frameworks (Airflow, dbt, Step Functions).
Background in big data ecosystems (Hadoop, Spark)

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aiawssqlpythonjavaci/cd

Platform: careers-html
Effort: medium