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.
Job Title
Data Engineer