Senior Data Engineer (Remote)

ZipRecruiter; Madison Heights (MI); Remote; USD 100,000 - 130,000; Full time

Job summary

A leading company is seeking a Data Engineer to design and maintain ETL/ELT pipelines across various platforms. This role involves automating workflows, ensuring data quality, and mentoring team members. The ideal candidate will have strong experience in AWS, PostgreSQL, and data modeling, and will collaborate with business stakeholders to refine data requirements and troubleshoot issues.

Qualifications

• 5+ years of data or BI engineering experience required.
• Hands-on experience with AWS Glue and PySpark/Python needed.
• Strong SQL proficiency expected.

Responsibilities

• Design and maintain robust ETL/ELT pipelines.
• Model scalable data warehouse schemas optimized for Power BI.
• Mentor team members and improve the data stack.

Skills

AWS Glue

Python

SQL

Data modeling

Problem-solving

Education

Bachelor’s in Computer Science

Tools

PostgreSQL

Redshift

Snowflake

Power BI

Airflow

Job description

Job DescriptionJob DescriptionDescription:

• Design and maintain robust ETL/ELT pipelines across Amazon, NetSuite, PostgreSQL, and more
• Automate workflows using AWS Glue, Airflow, or similar orchestration tools
• Model scalable data warehouse schemas optimized for Power BI
• Ensure data quality through validation, alerting, and anomaly detection
• Develop integrations with external APIs (Amazon SP-API, NetSuite, etc.)
• Collaborate with BI to prepare clean datasets and performance-optimized views
• Implement data backup and governance policies
• Mentor team members and recommend improvements to the data stack
• Partner with stakeholders to refine data requirements and troubleshoot issues

Requirements:

• Bachelor’s in Computer Science or equivalent experience
• 5+ years of data engineering or BI engineering experience
• Hands-on experience with AWS Glue and PySpark/Python
• Proficiency in SQL and Python for data workflows
• Experience with PostgreSQL, Redshift, or Snowflake
• Knowledge of NetSuite APIs and Amazon Seller Central data
• Strong understanding of data modeling and warehouse design
• Experience structuring data for Power BI and writing DAX queries
• Familiarity with orchestration tools (Airflow, Step Functions, etc.)
• Excellent remote communication and problem-solving skills