Data Engineer

Cloud Analytics Technologies, LLC; Charlotte (NC); On-site; USD 110,000 - 160,000; Full time

Job summary

Cloud Analytics Technologies, LLC is seeking an experienced Senior Data Engineer in Charlotte, NC to design, develop, and maintain scalable data pipelines and data engineering solutions. The role emphasizes Python, SQL, Apache Spark, Databricks, and cloud-based platforms.

Responsibilities include building ETL/ELT pipelines, optimizing data workflows with Airflow, and implementing data lake and data warehouse models.

Qualifications

• Strong Python and PySpark programming experience.
• Advanced SQL and database optimization skills.
• Hands-on Apache Spark and Databricks experience.
• Experience building ETL/ELT pipelines.
• Knowledge of Airflow and workflow orchestration.
• Experience with AWS services (S3, Glue, Redshift, Lambda).
• Understanding of data warehousing and data lake architecture.
• Experience with Snowflake or 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 Spark and Databricks.
• Integrate data from multiple sources (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 (S3/Glue/Redshift/Lambda)

Data warehousing

Snowflake/Redshift

Git/CI/CD/Agile

Tools

Databricks

Airflow

Snowflake

Redshift

AWS

Git

CI/CD

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.

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: