Senior Data Engineer: ETL, Warehousing & Cloud

Robotics Technologies LLC; Jersey City (NJ); On-site; USD 95,000 - 135,000; Full time

Job summary

Robotics Technologies LLC in Jersey City, NJ seeks an experienced Data Engineer to design and maintain scalable data pipelines, warehouses, and integration solutions transforming raw data into analytics-ready datasets for BI, reporting, and data science.

You will work with Python, SQL, PySpark, cloud platforms (AWS/Azure/GCP), and modern data platforms like Snowflake, Databricks, Redshift, or BigQuery, while improving data quality and pipeline reliability.

Qualifications

• Bachelor's degree or equivalent experience.
• 5+ years of data engineering or ETL experience.
• Strong proficiency in Python and SQL.
• Experience with cloud data platforms and distributed processing.
• Understanding of relational databases, data warehousing, and data lake architecture.
• Experience with performance tuning, debugging, and production support.

Responsibilities

• Design, develop, and maintain robust ETL/ELT pipelines for structured and semi-structured data.
• Ingest data from APIs, databases, files, and streaming sources.
• Build scalable data transformation workflows using Python, SQL, and Spark.
• Develop and optimize data warehouse tables, data models, and analytical datasets.
• Implement batch and real-time data processing solutions.
• Improve query performance, pipeline reliability, and data processing efficiency.
• Implement data quality checks, validation rules, reconciliation, and error-handling mechanisms.
• Monitor production pipelines and troubleshoot data failures.
• Apply data security, access controls, and governance standards.
• Collaborate with data analysts, data scientists, architects, and business stakeholders.
• Automate deployments and support CI/CD practices.
• Maintain technical documentation and participate in Agile development activities.

Skills

Python

SQL

PySpark

ETL/ELT

Data platforms

Big Data

Databases

Cloud

Data modeling

DevOps

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field

Tools

Informatica

Azure Data Factory

AWS Glue

Snowflake

Databricks

Redshift

BigQuery

Spark

Hadoop

Kafka

PostgreSQL

SQL Server

Oracle

MySQL

AWS

Azure

GCP

Job description

Robotics Technologies LLC in Jersey City, NJ seeks an experienced Data Engineer to design and maintain scalable data pipelines, warehouses, and integration solutions transforming raw data into analytics-ready datasets for BI, reporting, and data science.

You will work with Python, SQL, PySpark, cloud platforms (AWS/Azure/GCP), and modern data platforms like Snowflake, Databricks, Redshift, or BigQuery, while improving data quality and pipeline reliability.