Data Engineer

Robotics Technologies LLC; Charlotte (NC); On-site; USD 120,000 - 170,000; Full time

Job summary

Robotics Technologies LLC is seeking an experienced Senior Data Engineer to design, develop, and maintain scalable data pipelines and engineering solutions. The role focuses on Python, SQL, Spark, Databricks, and cloud platforms.

Responsibilities include building ETL/ELT pipelines, optimizing data workflows with Airflow, and implementing data lake/warehouse architectures. You will collaborate with analysts, architects, and stakeholders on large-scale data initiatives.

Qualifications

• Strong programming experience in Python and PySpark.
• Advanced SQL skills and database optimization.
• Hands-on experience with Apache Spark and Databricks.
• Experience building ETL/ELT pipelines.
• Knowledge of Apache Airflow and workflow orchestration.
• Experience with AWS services such as S3, Glue, Redshift, and Lambda.
• Strong understanding of data warehousing and data lake architecture.
• Experience with Snowflake or Amazon Redshift.
• Familiarity with Git, CI/CD, and Agile methodologies.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines.
• Build data processing solutions using Python, PySpark, and SQL.
• Develop and optimize data workflows using Apache Airflow.
• Implement data lake and data warehouse solutions.
• Work with large datasets using Apache Spark and Databricks.
• Integrate data from multiple sources, including APIs and databases.
• Develop and maintain data models for analytical reporting.
• Implement data quality checks and validation processes.
• Optimize query performance and pipeline execution.
• Collaborate with data analysts, architects, and business stakeholders.
• Monitor pipeline performance and troubleshoot production issues.

Skills

Python

PySpark

SQL

Apache Spark

Databricks

Airflow

AWS

Snowflake

Redshift

Git

CI/CD

Agile

Terraform

Docker

Tools

Databricks

Airflow

Spark

AWS S3

AWS Glue

AWS Redshift

Lambda

Git

CI/CD tooling

Terraform

Docker

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary:

We are looking for an experienced Senior Data Engineer to design, develop, and maintain scalable data pipelines and data engineering solutions. The ideal candidate should have strong expertise in Python, SQL, Apache Spark, Databricks, and cloud-based data platforms.

Key Responsibilities

Design, develop, and maintain scalable ETL/ELT data pipelines.

Build data processing solutions using Python, PySpark, and SQL.

Develop and optimize data workflows using Apache Airflow.

Implement data lake and data warehouse solutions.

Work with large datasets using Apache Spark and Databricks.

Integrate data from multiple sources, including APIs and databases.

Develop and maintain data models for analytical reporting.

Implement data quality checks and validation processes.

Optimize query performance and pipeline execution.

Collaborate with data analysts, architects, and business stakeholders.

Monitor pipeline performance and troubleshoot production issues.

Required Technical Skills

Strong programming experience in Python and PySpark.

Advanced SQL skills and database optimization.

Hands-on experience with Apache Spark and Databricks.

Experience building ETL/ELT pipelines.

Knowledge of Apache Airflow and workflow orchestration.

Experience with AWS services such as S3, Glue, Redshift, and Lambda.

Strong understanding of data warehousing and data lake architecture.

Experience with Snowflake or Amazon Redshift.

Familiarity with Git, CI/CD, and Agile methodologies.

Preferred Skills

Experience with Kafka or other streaming technologies.

Knowledge of Delta Lake and data lakehouse architecture.

Experience with Terraform and Docker.

Understanding of data governance and data security.

Exposure to Azure or Google Cloud Platform.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.