Snowflake Data Engineer

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

ROLE_DESCRIPTION:

Key Responsibilities

• Design, develop, and maintain robust and scalable data pipelines for data ingestion, transformation, and loading.
• Build and optimize data models and transformation workflows using DBT .
• Develop and support ETL/ELT processes using enterprise ETL tools.
• Implement and manage data warehousing solutions using Snowflake .
• Utilize AWS S3 for data storage and data lake architectures.
• Design and develop serverless data processing solutions using AWS Lambda .
• Create and maintain data integration workflows using AWS Glue .
• Work with scheduling and orchestration tools to automate and monitor data pipelines.
• Ensure data quality, consistency, security, and governance across the data platform.
• Troubleshoot data-related issues and optimize system performance.
• Collaborate with data analysts, business stakeholders, architects, and application teams to understand data requirements and deliver effective solutions.
• Prepare technical documentation and present solutions to technical and non-technical audiences.

Required Skills & Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 5+ years of experience in Data Engineering or related roles.
• Hands-on experience with:
  • Snowflake
  • DBT (Data Build Tool)
  • Enterprise ETL/ELT tools
  • Scheduling/Orchestration tools (such as Airflow, Control-M, Autosys, etc.)
  • AWS S3
  • AWS Glue
  • AWS Lambda
• Strong understanding of SQL and data warehousing concepts.
• Experience designing and optimizing large-scale data pipelines.
• Knowledge of data modeling, data governance, and data quality best practices.
• Strong analytical and problem-solving capabilities.
• Excellent verbal and written communication skills.
• Strong presentation and stakeholder management skills.

Preferred Qualifications:

• Experience with cloud-based data platforms and modern data architectures.
• Knowledge of data lake and data warehouse integration patterns.
• Experience with CI/CD and DevOps practices for data engineering.
• AWS or Snowflake certifications are a plus.
• Experience working in Agile environments.