Data Engineer

Machine Learning Technologies, LLC; Charlotte (NC); In loco; USD 120.000 - 180.000; Tempo pieno

Descrizione del lavoro

Machine Learning Technologies, LLC in Charlotte, NC, seeks an experienced Senior Data Engineer to design, build, and maintain scalable data pipelines and analytics infrastructure. You will work with Python, PySpark, SQL, and cloud-based platforms to deliver reliable data products for stakeholders.

You will implement ETL/ELT pipelines, data lake and data warehouse solutions, and collaborate with analysts and architects to ensure data quality, governance, and scalable performance across the data

Competenze

• Experience designing and building ETL/ELT pipelines into data lakes and warehouses.
• Strong Python and PySpark development skills.
• Advanced SQL and performance tuning for large datasets.
• Hands-on Spark and Databricks experience in cloud environments.
• Experience with AWS services (S3, Glue, Redshift, Lambda).

Mansioni

• 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 DBs.
• 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.

Conoscenze

Python

PySpark

SQL

Airflow

Data modeling

Agile

CI/CD

Git

Data warehousing

Cloud platforms

Strumenti

Apache Spark

Databricks

Snowflake

Redshift

Kafka

Terraform

Docker

Delta Lake

Descrizione del lavoro

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.