Data Engineer, SQL, ETL, PySpark & Spark

Rose International; Rutherford (NJ); Hybrid; USD 90,000 - 102,000; Full time

Job summary

Rose International seeks a Data Engineer to design, develop, and optimize scalable data pipelines using SQL, PySpark, and ETL frameworks in a hybrid work environment in Rutherford, NJ.

You will collaborate with analytics, engineering, and QE teams to ensure data quality, governance, and timely delivery across platforms, balancing performance and reliability while supporting business analytics and reporting needs.

Qualifications

• 5-8 years of experience in data engineering, SQL development, data analysis, or related field
• Strong proficiency in SQL and experience with relational databases and data warehousing concepts
• Experience with ETL tools, data pipeline frameworks, and big data technologies (preferred)
• Knowledge of QE fundamentals, including data validation, testing frameworks, and automation
• Strong problem-solving, analytical, and troubleshooting skills
• Excellent communication and stakeholder management abilities
• Experience working in complex, cross-functional environments

Responsibilities

• Design, build, and maintain scalable data pipelines and ETL processes to support analytics and operational use cases
• Develop and optimize complex SQL queries for data extraction, transformation, and validation
• Implement data quality checks, validation rules, and QE practices to ensure accuracy, consistency, and reliability of data
• Partner with business and technology teams to translate requirements into technical data solutions
• Analyze and troubleshoot data issues, performing root cause analysis and implementing fixes
• Drive data governance and standardization efforts across systems and platforms
• Support system integration and data flow across multiple applications and environments
• Lead data-related aspects of system changes, from requirements through development, testing (QE), and deployment
• Collaborate with QE teams to define test strategies, automate data validation, and ensure end-to-end system quality
• Communicate risks, dependencies, and impacts of data solutions to stakeholders
• Ensure compliance with data governance policies, regulatory requirements, and best practices

Skills

Agile

Analytical Skills

Data Scientist

Python

Education

Bachelor's Degree

Master's Degree

Job description

Date Posted: 08/19/2026

Hiring Organization: Rose International

Position Number: 505952

Industry: Financial Services

Job Title: Data Engineer, SQL, ETL, PySpark & Spark

Job Location: Rutherford, NJ, USA, 07070

Work Model: Hybrid

Work Model Details: 3 days onsite and 2 days remote

Employment Type: Temp to Hire

FT/PT: Full-Time

Estimated Duration (In months): 6

Min Hourly Rate($): 65.00

Max Hourly Rate($): 74.00

Must Have Skills/Attributes: Agile, Analytical Skills, Data Scientist, Python

Experience Desired: Experience in Python Development (5-8 yrs); Experience in SQL (5-8 yrs); Experience in Pyspark (5-8 yrs); Experience in ETL (5-8 yrs)

Required Minimum Education: Bachelor's Degree

Preferred Education: Master's Degree

C2C is not available

Job Description

Required Education

Bachelor's degree in computer science, Information Systems, Engineering, or equivalent experience

Required Qualifications:

• 5-8 years of experience in data engineering, SQL development, data analysis, or related field
• Strong proficiency in SQL and experience with relational databases and data warehousing concepts
• Experience with ETL tools, data pipeline frameworks, and big data technologies (preferred)
• Knowledge of Quality Engineering (QE) fundamentals, including data validation, testing frameworks, and automation
• Strong problem-solving, analytical, and troubleshooting skills
• Excellent communication and stakeholder management abilities
• Experience working in complex, cross-functional environments

The Senior Data Engineer Analyst is a seasoned technical professional responsible for building, optimizing, and maintaining scalable data pipelines and ensuring data quality across platforms. This role applies in-depth knowledge of data engineering principles, SQL development, and quality engineering (QE) fundamentals to improve data processes, workflows, and system reliability. Applies strong expertise in data engineering, contributing to the design and enhancement of data pipelines, architectures, and data quality frameworks. Demonstrates a deep understanding of how data systems integrate across functions, enabling efficient data flow and alignment with business objectives. Evaluates moderately complex data challenges, balancing performance, scalability, and data integrity considerations using multiple data sources. Utilizes advanced SQL skills to design, optimize, and troubleshoot queries, stored procedures, and data transformations. Strong analytical, communication, and collaboration skills are required to work across technical and business teams. Influences technical decisions through advisory support and contributes to large-scale data initiatives with regional or global impact.

Required Responsibilities

• Design, build, and maintain scalable data pipelines and ETL processes to support analytics and operational use cases
• Develop and optimize complex SQL queries for data extraction, transformation, and validation
• Implement data quality checks, validation rules, and QE practices to ensure accuracy, consistency, and reliability of data
• Partner with business and technology teams to translate requirements into technical data solutions
• Analyze and troubleshoot data issues, performing root cause analysis and implementing fixes
• Drive data governance and standardization efforts across systems and platforms
• Support system integration and data flow across multiple applications and environments
• Lead data-related aspects of system changes, from requirements through development, testing (QE), and deployment
• Collaborate with QE teams to define test strategies, automate data validation, and ensure end-to-end system quality
• Communicate risks, dependencies, and impacts of data solutions to stakeholders
• Ensure compliance with data governance policies, regulatory requirements, and best practices

#CT1

• Only those lawfully authorized to work in the designated country associated with the position will be considered.

• Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).