Data Engineer - ETL, SQL & Big Data Specialist

SmartRecruiters, Inc.; Windsor (CT); On-site; USD 63,000 - 89,000; Full time

Job summary

Global Channel Management in Windsor, CT is seeking a Data Engineer with 5+ years of experience to join our analytics team. You will architect and optimize data pipelines, perform ETL using SQL, and integrate data from Salesforce and other big data sources.

Strong SQL, Linux, and SPSS skills are preferred. This role emphasizes data quality, metadata management, and collaboration with cross‑functional teams to deliver reliable analytics for financial services and retirement industry clients.

Qualifications

• BS in Mathematics, Economics, Computer Science, Information Management or Statistics.
• Expert knowledge in SQL query language is required.
• Experience with Getting and Cleansing Data (ETL), including Salesforce and Big Data sources, is highly desirable.
• Experience with IBM's SPSS product is desirable.
• Working knowledge of Linux based client server applications.
• Aptitude for research, organization and structuring of complex problems.
• Strong technical, analytical and problem-solving skills.
• Strong technical writing skills and communication skills.
• Prior experience with metadata management repositories is a plus.
• Prior experience in the financial services, retirement or insurance industry is highly desirable
• Strong team-oriented interpersonal and communication skills are required.
• Create Best Practices and enforce those practices, to optimize the Analytics Data Store data loading and consumption.
• Identify data needs for projects, architect, plan, and execute the extract, transform, and load (ETL) activities, using a combination of 3rd party and open source technologies.

Responsibilities

• Create Best Practices and enforce those practices to optimize the Analytics Data Store data loading and consumption.
• Identify data needs for projects, architect, plan, and execute the extract, transform, and load (ETL) activities, using a combination of 3rd party and open source technologies.

Skills

SQL

ETL

Analytical skills

Communication skills

Teamwork

Education

BS in Mathematics, Economics, Computer Science, Information Management or Statistics

Tools

Salesforce

IBM SPSS

Linux

Job description

Global Channel Management in Windsor, CT is seeking a Data Engineer with 5+ years of experience to join our analytics team. You will architect and optimize data pipelines, perform ETL using SQL, and integrate data from Salesforce and other big data sources.

Strong SQL, Linux, and SPSS skills are preferred. This role emphasizes data quality, metadata management, and collaboration with cross‑functional teams to deliver reliable analytics for financial services and retirement industry clients.