Sr.Data Engineer -- PYspark,SQL

Acunor; Erie (Erie County); On-site; USD 120,000 - 160,000; Full time

Job summary

Acunor seeks a Senior Full-Stack Data Engineer to design and optimize large-scale cloud data platforms using AWS, SQL, PySpark, and Python. You will build ETL/ELT pipelines and work with petabyte-scale datasets across Snowflake, Redshift, Athena and Glue services.

The role emphasizes technical leadership, architecture guidance, and mentoring, with a focus on scalable data architectures and robust data quality practices in a fast-paced environment.

Qualifications

• 10–15 years of Data Engineering / Data Architecture experience
• Strong AWS – S3, IAM, VPC
• Advanced SQL, PySpark, and Python
• AWS Glue & Glue Catalog
• Talend & dbt Core
• AWS Streaming Services & Splunk
• Strong ETL/ELT and cloud data platform experience

Responsibilities

• Design and develop scalable AWS cloud data platforms
• Build and optimize ETL/ELT pipelines using SQL, PySpark, and Python
• Work with large/petabyte-scale data environments
• Develop solutions using AWS Glue, S3, Iceberg, Snowflake, Redshift, and Athena
• Support data integration, streaming, metadata management, and data quality
• Implement CI/CD and version control using Git
• Provide technical leadership, architecture guidance, and mentoring

Skills

Data engineering experience

Cloud data platforms

Mentoring

Tools

AWS

SQL

PySpark

Python

AWS Glue

Glue Catalog

Talend

dbt Core

S3

IAM

VPC

Snowflake

Redshift

Athena

Iceberg

Splunk

ETL/ELT

Job description

Employment Type: Contract

Experience: 10–15 Years

We are looking for a highly experienced Senior Full-Stack Data Engineer with strong hands‑on expertise in AWS, SQL, PySpark, and Python to build and optimize large‑scale cloud data platforms.

• Design and develop scalable AWS cloud data platforms
• Build and optimize ETL/ELT pipelines using SQL, PySpark, and Python
• Work with large/petabyte‑scale data environments
• Develop solutions using AWS Glue, S3, Iceberg, Snowflake, Redshift, and Athena
• Support data integration, streaming, metadata management, and data quality
• Implement CI/CD and version control using Git
• Provide technical leadership, architecture guidance, and mentoring

Must-Have Skills

• 10–15 years of Data Engineering / Data Architecture experience
• Strong AWS – S3, IAM, VPC
• Advanced SQL, PySpark, and Python
• AWS Glue & Glue Catalog
• Talend & dbt Core
• AWS Streaming Services & Splunk
• Strong ETL/ELT and cloud data platform experience

Nice to Have

• Insurance industry experience
• Technical leadership and mentoring experience