Overview The Data Engineer, Marketing & Analytics, is a key technical contributor responsible for designing, building, and maintaining robust data pipelines and infrastructure that power VML's digital and media reporting and product analytics for our tier‑one clients. This role focuses on ensuring high‑quality, reliable, and accessible data for analysis, reporting, and advanced analytical initiatives, including feeding platforms like Amplitude. You will leverage a modern data stack including Google Cloud Platform (GCP), Matillion for ETL/ELT, Snowflake as our cloud data warehouse, and Rudderstack for customer data ingestion. Your work will directly enable our analytics and data science teams to derive critical insights, fuel AI/ML applications, and provide robust data to product analytics platforms like Amplitude. Beyond pipeline development, you will also be responsible for monitoring, troubleshooting, and optimizing data workflows. Responsibilities Data Pipeline Development: Design, develop, and implement scalable and reliable ETL/ELT pipelines using Matillion and GCP services (e.g., Cloud Functions, Cloud Storage, BigQuery, Composer/Airflow) to ingest, transform, and load digital and media data into Snowflake. Data Ingestion & Integration: Configure and manage data streams from various sources, including customer data platforms like Rudderstack, APIs (e.g., ad platforms, analytics tools), and other raw data feeds. Integrate data from advanced omnichannel tagging and data collection systems, ensuring readiness for tools like Amplitude. Data Transformation & Modeling: Develop complex SQL transformations within Snowflake to clean, enrich, and model data for optimal performance and usability by reporting tools (e.g., Tableau, Amplitude) and analytical applications. Design and implement data schemas (star, snowflake, data vault) to support business requirements. Infrastructure Management: Monitor, maintain, and optimize the performance, security, and cost‑efficiency of our data infrastructure components across GCP and Snowflake. Quality Assurance & Monitoring: Implement robust data quality checks, validation rules, and automated monitoring solutions for all data pipelines to ensure accuracy, completeness, and timeliness of data delivered to various platforms, including Amplitude. Troubleshoot and resolve data discrepancies and pipeline failures promptly. Reporting & Visualization Support: Collaborate with analytics specialists and data visualization experts (e.g., Tableau, Amplitude) to ensure data models meet reporting needs and are optimized for query performance. Documentation & Governance: Create and maintain comprehensive documentation for data pipelines, data models, schemas, and data dictionaries. Adhere to data governance best practices, including data privacy (GDPR, CCPA) and security standards. Collaboration & Innovation: Work closely with data analysts, data scientists, product managers, solution architects, and client teams to understand data requirements and translate them into technical solutions. Stay informed on emerging data engineering technologies, AI/ML data preparation techniques, and best practices. Automation: Automate routine data management tasks, monitoring, and deployments where possible using scripting languages like Python. Requirements Minimum 5 years’ engineering and development experience. Strong client‑facing skills – responsive, results‑driven, dedicated to customer support, and adept at consulting on complex technical and strategic data challenges. Strong attention to detail, excellent organizational skills, and ability to work independently and manage multiple projects/responsibilities and small teams in a fast‑paced environment. Exposure to enterprise‑level clients and understanding of complex web/app ecosystems, privacy regulations (GDPR, CCPA), and best practices for data governance. In‑depth knowledge of various client websites, mobile apps, their business models, and online marketing/product strategy. Technical & Development Expertise Cloud Platforms: Proven experience with Google Cloud Platform (GCP) – BigQuery, Cloud Storage, Cloud Functions, and orchestration tools like Cloud Composer (Apache Airflow). Data Warehousing: Solid expertise in Snowflake including data loading, SQL querying, performance tuning, and schema design. ETL/ELT Tools: Hands‑on experience designing and building data pipelines with Matillion (or similar tools such as Fivetran, Stitch). Customer Data Platforms (CDPs): Experience with Rudderstack for event collection, data routing, and destination management. Product Analytics Platforms: Familiarity with or experience integrating data with Amplitude (or similar tools like Mixpanel, Pendo). Programming & Scripting: Advanced proficiency in SQL for data manipulation and transformation. Experience with Python for scripting, automation, and API integrations. BI & Reporting: Experience supporting data consumers using BI tools such as Tableau (or Looker Studio, Power BI), understanding dashboarding needs and the data structures required by Amplitude. Data Collection & Integration: Knowledge of API integration (REST, GraphQL), SFTP, and event‑driven data architectures, especially from advanced tagging and data collection systems. Data Modeling: Practical experience with data modelling techniques for analytical databases. Version Control: Proficiency with Git and modern software development practices. Beneficial: Experience with other cloud platforms (AWS, Azure), knowledge of containerization (Docker, Kubernetes), or exposure to streaming data technologies (Kafka). Functional & Domain Expertise Marketing & Product Data: Strong understanding of digital marketing data (e.g., ad impressions, clicks, conversions), media reporting metrics, product usage data (e.g., events, user flows as seen in Amplitude), and customer journey data. Data Governance: Familiarity with data privacy regulations (GDPR, CCPA) and best practices for data security and compliance. Analytics Ecosystem: Understanding of how data engineering supports analytics, reporting, and machine learning initiatives across platforms including Amplitude. Leadership & Interpersonal Skills Client Engagement: Demonstrated experience as a senior consultant, engaging directly with clients to gather requirements, present solutions, and manage expectations. Communication: Exceptional written and oral skills, capable of authoring complex technical specifications, blueprints, and proposals, and confidently leading technical discussions. Problem‑Solving: Proven ability to work collaboratively as part of a team to solve complex problems in varied, fast‑paced environments. Project Management Acumen: Experience working effectively within a project management office framework. Methodologies: Familiarity and experience with best‑practice development methodologies. Adaptability: Ability to instill confidence through maturity, expertise, and impeccable communications. We are an equal‑opportunity employer. Preference in appointment for the role will be in line with the employment equity strategy of our organisation. UK working hours will be required for this role. #J-18808-Ljbffr