RPS North America

Data Engineer

New York, New York, United States

Not SpecifiedCompensation
Mid-level (3 to 4 years), Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Data Engineering, Information TechnologyIndustries

Job Title

Data Engineer

Reporting Structure

  • Reports to: Client Services Supervisor, Client Services Manager, or equivalent leadership.

Job Overview

SPS is seeking a skilled and collaborative Data Engineer to design, develop, and maintain robust data solutions that support business decision-making. This role involves close collaboration with software engineers and business stakeholders to translate requirements into efficient ETL pipelines, data models, and scalable architectures. The ideal candidate will have strong programming skills (Python, PySpark, SQL), hands-on experience with modern data platforms (Snowflake, Spark, Airflow, Azure/AWS), and a solid understanding of data modeling, performance optimization, and CI/CD practices. Experience with front-end technologies and API development is a plus.

Responsibilities

  • Collaborate with software engineers, business stakeholders, and/or domain experts to translate business requirements into product features, tools, projects.
  • Develop, implement, and deploy ETL solutions.
  • Preprocess and analyze large datasets to identify patterns, trends, and insights.
  • Evaluate, validate, and optimize data models to ensure efficiency and generalizability.
  • Monitor and maintain the performance of data pipelines and data models in production environments, identifying opportunities for improvement and updating as needed.
  • Document development processes, results, and lessons learned to facilitate knowledge sharing and continuous improvement.

Required Skills

  • Education: Bachelor's or master’s degree in computer science, Engineering, or a related field.
  • Programming: Strong programming skills in languages such as Python, PySpark, SQL.
  • ETL & Data Platforms: Experience in building and optimizing ETL workflows using tools/technologies such as Spark, Snowflake, Airflow, and/or Azure Data Factory, Glue, Redshift.
  • SQL: Craft and optimize complex SQL queries and stored procedures for data transformation, aggregation, and analysis.
  • Data Modeling: Develop and maintain data models ensuring scalability and optimal performance.
  • Snowflake: Utilize Snowpark for data processing within the Snowflake platform. Integrate Snowflake for efficient data storage and retrieval.
  • API Integrations: Exposure to API integrations to facilitate data workflows.
  • CI/CD: Experience in implementing CI/CD pipelines through DevOps platforms.
  • Cloud Infrastructure: Good experience in cloud infrastructure such as Azure, AWS, or GCP.

Desired Skills (Good to Have)

  • Experience with Docker, Kubernetes.
  • Exposure to HTML, CSS, Javascript/JQuery, Node.js, Angular/React.
  • Experience in API development, Flask/Django is a bonus.

Compensation

  • Pay Range: $64 - $75 USD

What We Offer

  • Career Growth: An opportunity to enter a job that allows you to learn new skills or use a variety of them that may lead you to uncover other career opportunities!
  • Learning & Development: At SPS, we promote a work culture of learning so that you can develop to be the best at what you do!
  • Talent Recognition: We offer a variety of recognition programs for all levels of employees!
  • Benefit Offerings: Medical, Dental, Vision, HCFSA, DCFSA, HSA, Commuter Transit and Parking, Supplemental Life Insurance, Accident Insurance, Critical Illness, Hospital Indemnity, Legal Program, Identity Theft Protection, Pet Discounts, Pet Insurance, Group Home and Auto Insurance, EAP, Short Term Disability, Life Insurance, Education Discounts, 401k w/ matching, Entertainment Discounts, & Paid Time Off.
    • Note: Please inquire with the Human Resources team for benefit offerings per role as regular positions that routinely are under 30 hours/week may have a different benefit offering.

About SPS

SPS is an award-winning employer of choice offering outsourcing solutions that leverage Intelligent Automation (Artificial Intelligence & Robotic Process Automation) in more than 22 countries across the globe. In North America, our services include Mailroom Management (both physical and digital), Office Services such as Reception, Lobby Concierge, and Conference Room Management, in addition to Document Management.

Skills

Python
PySpark
SQL
ETL
Data Modeling
Spark
Snowflake
Airflow
Azure Data Factory
AWS Glue
Redshift
CI/CD
API Development

RPS North America

Global consulting firm for diverse sectors

About RPS North America

RPS North America provides consulting and advisory services across various sectors, including property, energy, transport, defense, government services, and water resources. The company helps clients, which range from large corporations to non-profits, navigate complex challenges and achieve regulatory compliance through a wide array of services. These services include management consulting, environmental consulting, project management, and digital solutions, among others. RPS North America stands out from its competitors by leveraging its deep expertise and global presence to deliver tailored solutions that meet specific client needs. The company's goal is to drive sustainable growth and address critical issues such as infrastructure development and risk management, ensuring a consistent demand for its high-value services.

Delft, NetherlandsHeadquarters
1970Year Founded
$31.5KTotal Funding
ACQUISITIONCompany Stage
Consulting, Energy, Enterprise SoftwareIndustries
5,001-10,000Employees

Risks

Increased competition from AECOM with new regional director.
Acquisition by Tetra Tech may impact client relationships.
Internal competition from NEO Material Development Kit could cause brand confusion.

Differentiation

RPS Group offers a wide range of consulting and advisory services.
The company has a strong focus on sustainability and environmental consulting.
RPS leverages its global presence and multidisciplinary teams for tailored solutions.

Upsides

Increased demand for environmental consulting due to global sustainability focus.
Growing interest in digital transformation aligns with RPS's expertise.
Expansion of green finance offers new project opportunities for RPS.

Land your dream remote job 3x faster with AI