Senior Data Engineer - SQL, ETL & PySpark | Hybrid

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

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.