Snowflake Data Engineer - Pipelines & Data Lake

Purple Drive LLC; Detroit (MI); On-site; USD 120,000 - 160,000; Full time

Job summary

Purple Drive LLC in Detroit is seeking a senior Data Engineer to design, build, and maintain scalable data pipelines for ingestion, transformation, and loading.

You will work with Snowflake, DBT, ETL/ELT tools, and AWS services (S3, Glue, Lambda) to deliver governance, quality, and reliable data products for analytics teams.

Strong SQL, data warehousing concepts, and collaboration with analysts and stakeholders are essential for success.

Qualifications

• Bachelor's degree in a related field is required.
• 5+ years of experience in Data Engineering or related roles.
• Hands-on with Snowflake and DBT (Data Build Tool).
• Experience with ETL/ELT tools and scheduling/orchestration (Airflow, etc.).
• Proficient in SQL and data warehousing concepts.
• Strong communication and collaboration with stakeholders.

Responsibilities

• Design, develop, and maintain scalable data pipelines for ingestion, transformation, and loading.
• Build and optimize data models and transformation workflows using DBT.
• Develop and support ETL/ELT processes using enterprise tools.
• Implement and manage data warehousing with Snowflake.
• Use AWS S3 for data storage and data lake architectures.
• Develop serverless data processing with AWS Lambda.
• Create data integration workflows with AWS Glue.
• Automate and monitor data pipelines with scheduling tools.
• Ensure data quality, governance, and security across the platform.
• Troubleshoot data issues and optimize performance.
• Collaborate with analysts and stakeholders to meet data needs.
• Prepare technical documentation and present solutions.

Skills

SQL

Data warehousing concepts

Data modeling

Data governance

Analytical problem-solving

Communication

Education

Bachelor's degree in Computer Science, Information Technology, Engineering

Tools

Snowflake

DBT

ETL/ELT tools

Airflow

AWS S3

AWS Glue

AWS Lambda

Job description

Purple Drive LLC in Detroit is seeking a senior Data Engineer to design, build, and maintain scalable data pipelines for ingestion, transformation, and loading.

You will work with Snowflake, DBT, ETL/ELT tools, and AWS services (S3, Glue, Lambda) to deliver governance, quality, and reliable data products for analytics teams.

Strong SQL, data warehousing concepts, and collaboration with analysts and stakeholders are essential for success.