• Develop, test, and maintain ETL/ELT pipelines that ingest structured and semi-structured data from third-party sources, including GA4, paid media, social media, and other marketing platforms.
• Build and support API and batch-ingestion workflows, including pagination, rate-limit handling, retries, and incremental loads.
• Integrate web traffic, campaign, engagement, and related business data into the AWS data lake.
• Transform source data into consistent, reusable datasets using established standards for data types, normalization, deduplication, and validation.
• Monitor scheduled pipelines and troubleshoot data-quality, performance, schema, and processing issues.
• Implement data-quality checks and communicate failures, risks, and blockers to the appropriate team members.
• Work with AWS data services such as S3, Glue, Athena, and CloudWatch, or equivalent cloud technologies.
• Use Git-based development practices, including branches, pull requests, peer reviews, and controlled deployments.
• Perform unit testing and source-to-target validation for pipeline changes.
• Maintain technical documentation for data sources, mappings, transformations, business rules, and operational procedures.
• Collaborate with Sr. Engineers, reporting analysts, and business stakeholders to translate requirements into technical tasks.
• Implement established data-governance, privacy, consent, access, and retention requirements.
• Participate in Agile planning, estimation, demonstrations, and retrospectives.
• Responsibly use approved enterprise AI tools while validating generated code and protecting company and customer data.