Data Engineer

About this role

Job Number: R0245967
Data Engineer


The Opportunity:
We are seeking a Data Engineer to build and maintain cloud-native data ingestion pipelines and analytics infrastructure on AWS. You will develop and support API-driven ingestion feeds, maintain Lambda and Glue-based ETL processes, model and query data in Redshift across landing, staging, core, and mart layers, and monitor production workloads for reliability and data quality. This role sits at the intersection of data engineering and cloud operations, and includes exposure to data visualization and dashboard delivery for business stakeholders.


What You’ll Work On:

• Build and support ingestion pipelines that pull data from external APIs, normalize JSON and CSV payloads, and land data in Amazon S3.
• Develop and maintain AWS Lambda functions supporting ingestion and orchestration workflows.
• Create and maintain AWS Glue jobs, including Visual ETL workflows.
• Support large-volume data loads and batch processing, including ECS or Fargate.
• Write and maintain Redshift SQL organized into properly layered landing, staging, core, and mart structures, including tables and views.
• Develop efficient queries using joins, aggregations, and views against large datasets.
• Implement and maintain SQL-based data quality checks covering null values, duplicates, row counts, and schema change detection.
• Monitor, diagnose, and remediate pipeline and job failures using CloudWatch logs and job run histories.
• Work within supporting AWS services, including VPC, IAM, SSM Parameter Store, Secrets Manager, and KMS.
• Adhere to established AWS naming conventions and follow DEV/STAGE/PROD promotion patterns.
• Build and maintain dashboards and reporting assets in Amazon QuickSight, Tableau, or Power BI to support business stakeholders.
• Ingest and manipulate data in dashboards.

Join us. The world can’t wait.


You Have:

• 2+ years of experience with SQL, including joins, aggregations, views, and quer...