Data Engineer

Key Responsibilities

• Architect and maintain our Amazon Redshift Serverless data warehouse.
• Design and implement ETL pipelines from operational Redshift to staging (DSA), landing (DLA), and TDW layers.
• Model data using star schema and fact / dimension tables.
• Integrate third-party sources including Google Analytics 4 (GA4) and BigQuery.
• Write, optimize, and maintain advanced SQL scripts for data modeling and transformations.
• Build automation and QA checks in Python to ensure pipeline reliability.
• Connect to and manage API-based data ingestion.
• Collaborate with BI and product teams to ensure modeled data is optimized for reporting.
• Provide technical leadership, mentoring, and establish data engineering best practices.