AWS & Snowflake Data Engineer

Robotic Process Automation LLC

Auburn Hills (MI)

On-site

USD 93,000 - 133,000

Full time

36 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Robotic Technologies Automation is seeking an AWS & Snowflake Data Engineer to design and deliver scalable data pipelines in Auburn Hills, MI.

You will build ETL/ELT processes with Airflow and AWS services, implement star/snowflake schemas, and partner with data scientists to produce actionable insights. Strong SQL, PySpark, Python skills and hands-on experience with Snowflake, Redshift, Databricks are required; mentoring junior engineers and enforcing governance complete the role.

Qualifications

  • SQL, PySpark, Python proficiency.
  • ETL/ELT pipelines with Airflow and AWS services.
  • Snowflake/Redshift/Databricks data warehousing.
  • AWS cloud platforms knowledge.
  • Star/snowflake data modeling.
  • Data governance, encryption, masking, and RBAC.
  • Problem-solving and scalable solutions.
  • Collaborate with data scientists and analysts.
  • Git version control for pipelines.
  • End-to-end data architecture strategy.

Responsibilities

  • Design, develop and maintain end-to-end data pipelines.
  • Build data models and schemas for analytics.
  • Collaborate with data scientists to deliver business insights.
  • Implement data governance and security controls.
  • Troubleshoot performance bottlenecks and optimize workloads.
  • Mentor junior engineers and enforce coding standards.
  • Ensure version control of pipelines with Git.
  • Deliver robust, scalable data solutions.

Skills

SQL
PySpark
Python
Data pipelines
ETL/ELT
Data modeling
Data governance
Security controls
Troubleshooting
Client relationship

Tools

Airflow
AWS EC2
EMR
S3
DBT
Azure Data Factory
Snowflake
Redshift
Databricks
Git

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: AWS & Snowflake Data Engineer

Location: Auburn Hills, MI

Duration: 8 Months + Extension

Bill Rate: $82/hour (C2C)

Job Type: W-2, 1099, C2C

Client: To Be Discussed Later

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description:
Must Have Technical/Functional Skills:
  • Programming Languages: Proficient in SQL, Pyspark, Python
  • Data Pipeline & ETL: Proficiency in building ETL/ELT pipelines using tools like Apache Airflow, AWS EC2, EMR, S3, DBT, Azure Data factory
  • Database Management: Expertise in data warehousing solutions like Snowflake or Redshift, Databricks
  • Cloud Platforms: Working knowledge of cloud providers (AWS) is essential.
  • Data Modeling: Designing efficient schemas (star/snowflake) for dimensional modelling and semantic models for Visualization tools
  • Data Governance & Security: Implementing data encryption, masking, and role- based access control.
  • Problem-Solving & Troubleshooting: Identifying bottlenecks in data workflows and creating scalable, robust solutions.
  • Collaboration: Working with data scientists and analysts to understand business needs and deliver actionable data.
  • Version Control: Using tools like Git for managing code for data pipelines.
  • Designing and implementing through data architecture strategies
  • Analyzing complex issues to create innovative solutions
  • Upholding standards in project deliverables
  • Developing a thorough understanding of the business environment
  • Building and maintaining excellent client relationship
  • Enhancing personal brand and technical skills
  • Mentoring and guiding junior team members
  • Implementing end to end solutions catering to the business requirements
Managerial Skills:
  • Track the deliverables assigned and deliver on time with great quality
  • Participation in Scrum calls and sprint planning and agile ceremonies

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

AWS & Snowflake Data Engineer
AWS & Snowflake Data Engineer

Robotics Technologies LLC • Auburn Hills (MI)

On-site
USD 93,000 - 133,000
AWS & Snowflake Data Engineer
AWS & Snowflake Data Engineer

Quantum Technologies LLC • Auburn Hills (MI)

On-site
USD 93,000 - 133,000
AWS & Snowflake Data Engineer
AWS & Snowflake Data Engineer

Ethereum Technologies LLC • Auburn Hills (MI)

On-site
USD 93,000 - 133,000
AWS & Snowflake Data Engineer
AWS & Snowflake Data Engineer

CloudBigD • Auburn Hills (MI)

On-site
USD 93,000 - 133,000
AWS & Snowflake Data Engineer
AWS & Snowflake Data Engineer

Valiant Technologies LLC • Auburn Hills (MI)

On-site
USD 93,000 - 133,000
Snowflake Data Engineer
Snowflake Data Engineer

Ethereum Technologies LLC • Atlanta (GA)

On-site
USD 90,000 - 124,000
Snowflake Data Engineer
Snowflake Data Engineer

Valiant Technologies LLC • Atlanta (GA)

On-site
USD 83,000 - 124,000
Snowflake Data Engineer
Snowflake Data Engineer

Quantum Technologies LLC • Atlanta (GA)

On-site
USD 77,000 - 110,000
Snowflake Data Engineer
Snowflake Data Engineer

Valiant Technologies LLC • Chicago (IL)

On-site
USD 88,000 - 125,000
Snowflake Data Engineer
Snowflake Data Engineer

Robotic Process Automation LLC • Chicago (IL)

On-site
USD 96,000 - 117,000