ETL/Data Warehouse Engineer

CTG • United States, United States • 2w ago

CTG is seeking to fill a Data Warehouse ETL Developer opening for our client in New York.

Location: Remote

Duration: 15 months

We are seeking a detail-oriented and technically proficient ETL/Data Warehouse Engineer to design, develop, and maintain robust ETL processes that support our enterprise data warehouse. This role is critical to ensuring the integrity, performance, and scalability of data pipelines that enable analytics, reporting, and decision-making across the organization.

Duties:

Design, develop, and optimize ETL workflows to extract, transform, and load data from multiple sources into the enterprise data warehouse.

Collaborate with data architects and analysts to design and maintain dimensional data models (star/snowflake schemas).

Monitor and tune the performance of ETL jobs and database queries to ensure efficient and timely data processing.

Implement robust data quality, validation, cleansing, and reconciliation processes to ensure accuracy and reliability.

Develop and maintain technical documentation, adhering to established coding standards and best practices.

Partner with business analysts, data scientists, and application teams to understand requirements and deliver scalable solutions.

Diagnose and resolve ETL/data issues, including job failures, anomalies, and performance bottlenecks.

Skills:

Proficiency in ETL development tools and data integration platforms.

Strong SQL development and query optimization skills.

Solid understanding of data warehousing concepts, dimensional modeling, and relational database design.

Experience implementing Apache Spark on Linux environments.

Strong programming experience with Java and the ability to apply software development lifecycle (SDLC) best practices.

Knowledge of data governance and data quality frameworks.

Familiarity with cloud-based data platforms (AWS, Azure, GCP) is a plus.

Experience:

5+ years of professional experience in ETL development and data warehousing.

Demonstrated experience building scalable ETL pipelines and working with large datasets.

Hands-on experience with performance tuning of ETL processes and SQL queries.

Prior experience collaborating with cross-functional teams in data-driven projects.

Education:

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field.

Equivalent combination of education and experience will be considered.

Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services for this role.

To Apply:

To be considered, please apply directly to this requisition using the link provided. For additional information, please contact Nicole Shaw at Nicole.Shaw@ctg.com . Kindly forward this to any other interested parties. Thank you!

The expected base salary for this position ranges from $85,000 to $100,000. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, market factors, and where applicable, licensure or certifications obtained. In addition to salary, a competitive benefit package is also offered.

About CTG

CTG, a Cegeka company, is at the forefront of digital transformation, providing IT and business solutions that accelerate project momentum and deliver desired value. Over nearly 60 years, we have earned a reputation as a faster and more reliable, results-driven partner. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. CTG leverages the expertise of over 9,000 team members in 19 countries to provide innovative solutions. Together, we operate across the Americas, Europe, and India, working in close cooperation with over 3,000 clients in many of today's highest-growth industries. For more information, visit www.ctg.com .

Our culture is a direct result of the people who work at CTG, the values we hold, and the actions we take. In other words, our people define our culture. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. Part of our mission is to cultivate a workplace that attracts and develops the best people, reflected by our recognition as a Great Place to Work Certified company across many of our global operations.

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.

CTG

Go to Apply

Share this job

Similar Jobs

Staff IT Analyst III - Senior IT Systems Analyst, Contact Center Technology & Op

Western Alliance Bank • Grove City, OH • 53min ago

IT & Engineering

Job Title: Staff IT Analyst III - Senior IT Systems Analyst, Contact Center Technology & Operations Location: Block 23 What you'll do: We are seeking a highly skilled and experienced Senior IT Systems Analyst with a...

53min ago

Go to Apply

Software Engineer 2 (Full Stack - Java, Springboot, React, RDBMS)

U.S. Bank • Irving, TX • 54min ago

IT & Engineering

At U.S. Bank, we're on a journey to do our best. Helping the customers and businesses we serve to make better and smarter financial decisions and enabling the communities we support to grow and succeed. We believe it tak...

54min ago

Go to Apply

Software Engineer 2 (Full Stack - Java, Springboot, React, RDBMS)

U.S. Bank • Atlanta, GA • 54min ago

IT & Engineering

54min ago

Go to Apply

Software Engineer 2 (Full Stack - Java, Springboot, React, RDBMS)

U.S. Bank • Hopkins, MN • 57min ago

IT & Engineering

57min ago

Go to Apply

Sr. Strategy & Business Analytics Lead

Northwest Bank • Columbus, OH • 57min ago

IT & Engineering

Job Description As a key member of Commercial Strategy and Effectiveness, the Sr. Strategy & Business Analytics Lead will be a partner to Commercial leadership, responsible for driving strategic and tactical initiati...

57min ago

Go to Apply

Data Engineer III

Old National Bank • Saint Paul, MN • 59min ago

IT & Engineering

59min ago

Go to Apply

Technical Support Specialist - Ventilation

ZOLL MEDICAL CORPORATION • Chelmsford, MA • 2h ago

IT & Engineering

Acute Care Technology At ZOLL, we're passionate about improving patient outcomes and helping save lives. We provide innovative technologies that make a meaningful difference in people's lives. Our medical devices, softwa...

2h ago

Go to Apply

Certified EP Technologist

HCA Healthcare • San Antonio, TX • 2h ago

IT & Engineering

Description Introduction Do you have the career opportunities as a EP Technician Certified you want with your current employer? We have an exciting opportunity for you to join Methodist Hospital which is part of the nati...

2h ago

Go to Apply

CNC Manufacturing Engineer - Richardson, TX

RTX Corporation • Richardson, TX • 2h ago

IT & Engineering

Date Posted: 2025-09-14 Country: United States of America Location: TX231: Richardson 1601 North Plano Road , Richardson, TX, 75081 USA Position Role Type: Onsite U.S. Citizen, U.S. Person, or Immigration Status Requirem...

2h ago

Go to Apply

Civil Engineer I

State of Vermont • Barre, VT • 2h ago

IT & Engineering

This job was posted by https://www.vermontjoblink.com : For more information, please see: https://www.vermontjoblink.com/jobs/1297998 Overview The Agency of Transportation is seeking a Civil Engineer I. The realm of brid...

2h ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.