Senior Big Data Engineer: ETL, Cloud & Pipelines

AAA Northeast; Village of Garden City (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

AAA Northeast in New York is seeking a Big Data Engineer III to design, build, and maintain large-scale data processing systems. You will architect ETL processes, create advanced data models, and optimize data pipelines to deliver actionable insights for analysts and data scientists.

Collaborate with data teams, implement cloud-based data solutions using Snowflake, DBT, and Airflow, and mentor junior engineers while advancing our data architecture and performance.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering or a related field.
• 6-8 years of additional relevant experience required
• Master's Degree Computer science, Information Technology, Engineering, or a related field or 5+ YOE of direct experience. preferred

Responsibilities

• Data Engineering: Architect and optimize ETL processes for complex data requirements. Design advanced data models to support sophisticated data processing needs. Design and manage robust, scalable data pipelines.
• Database Management: Oversee the management and optimization of databases. Utilize advanced SQL techniques for complex data operations. Oversee the implementation and management of NoSQL databases. Architect and manage data warehousing solutions.
• Big Data and Cloud Technologies: Lead the implementation and optimization of big data technologies. Manage and optimize distributed computing resources for large-scale data processing. Build, maintain, and manage data pipelines using cloud technologies, Snowflake, Fivetran, DBT, Airflow. Utilize cloud platforms for scalable data processing and storage.
• DevOps and Security: Apply DevOps practices to automate and streamline data engineering workflows. Implement containerization solutions for data processing jobs. Implement data security measures to protect sensitive information. Optimize the performance of data processing and storage systems.
• Leadership: Mentor and guide junior engineers, fostering a collaborative and innovative work environment.

Skills

ETL

SQL

NoSQL

Data warehousing

Cloud

Snowflake

Airflow

DBT

Education

Bachelor's degree in CS/IT/Engineering

Master's degree or 5+ years experience

Tools

Snowflake

DBT

Airflow

Azure

Job description

AAA Northeast in New York is seeking a Big Data Engineer III to design, build, and maintain large-scale data processing systems. You will architect ETL processes, create advanced data models, and optimize data pipelines to deliver actionable insights for analysts and data scientists.

Collaborate with data teams, implement cloud-based data solutions using Snowflake, DBT, and Airflow, and mentor junior engineers while advancing our data architecture and performance.