Lead Data Engineer – ETL, AWS Redshift & Data Lakes

Hirerising; Phoenix (AZ); On-site; USD 110,000 - 160,000; Full time

Job summary

Hirerising in Phoenix, AZ is seeking a Data Engineer with 5–7 years of experience in data integration, ETL/ELT development, reverse ETL, and SQL. The ideal candidate will have hands‑on experience with AWS data services, data lakes, data warehouses, and data connectors.

The successful candidate will help develop and maintain reliable data pipelines, integrate data from multiple sources, and support reporting and analytics requirements.

Qualifications

• 5–7 years of experience in data engineering and ETL development.
• Hands-on experience with ETL/ELT, reverse ETL, and data integration/connectors.
• Experience with AWS data services, including Redshift, RDS, and Glue.
• Hands-on with data lakes and data warehousing.

Responsibilities

• Develop, maintain, and troubleshoot ETL/ELT and reverse ETL pipelines.
• Configure and maintain data connectors using Fivetran or similar tools.
• Work with AWS services including Redshift, RDS, and Glue.
• Build and maintain data lake and data warehouse solutions.
• Write and optimize SQL queries for data extraction, transformation, and reporting.
• Integrate data from multiple systems and ensure accurate delivery.
• Monitor pipeline performance, resolve data issues, and maintain quality.
• Collaborate with analysts and stakeholders to support data requirements.
• Document data workflows and integration processes.
• Follow best practices for data security, reliability, and maintainability.

Skills

Data engineering

ETL development

SQL

AWS

Data integration

Tools

Fivetran

Amazon Redshift

AWS Glue

RDS

Job description

Hirerising in Phoenix, AZ is seeking a Data Engineer with 5–7 years of experience in data integration, ETL/ELT development, reverse ETL, and SQL. The ideal candidate will have hands‑on experience with AWS data services, data lakes, data warehouses, and data connectors.

The successful candidate will help develop and maintain reliable data pipelines, integrate data from multiple sources, and support reporting and analytics requirements.