Data Specialist at Aperture

, , Turkey -

Full Time

Start Date

Immediate

Expiry Date

08 Jan, 26

Salary

0.0

Posted On

10 Oct, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Pipelines, Attribution, Dashboard Design, Data Quality, Performance Marketing, Google Tag Manager, Data Visualisation, APIs, ETL Workflows, Automation, Signal Engineering, Event Tracking, Data Governance, Creative Strategy, Analytics Tools, Mobile Measurement Partners

Industry

Business Consulting and Services

Description

Meet Aperture At Aperture, we create value and drive growth by delivering exceptional product consultancy and advertising services to our global partners. Through data-driven strategies, we harness our expertise in performance marketing, creative strategy, and product optimisation to achieve outstanding results. Founded in 2022 by industry visionary Hannah Parvaz, we’ve quickly made waves. Already recognised as Business Consultant of the Year and named 2024’s Most Innovative Growth Agency, our trajectory is nothing short of extraordinary. Now, as we prepare to scale new heights in 2025, we’re building a dream team to fuel our ambitions. This is your chance to join us and be part of our incredible growth story. Are you ready to make an impact? Our Culture: Growth mindset. We're hungry to learn and improve. Take full responsibility for every outcome—no excuses. Obsess over results. We're here to make a measurable impact. We’re data-obsessed. We let numbers, not opinions, guide our decisions. Client success is our success. Period. No ego. The best idea wins, regardless of who it comes from. Radical candour. We give and receive honest feedback to fuel growth. Work from anywhere Embrace our remote-first culture that prioritises impact over location. Work from wherever you're most productive, while enjoying meaningful connections with the team in London from time to time. We bring everyone together regularly for inspiring sessions and great conversations over amazing food—because the best ideas often start with "what if?". You must be able to work in a UK timezone. Role overview: Are you ready to shape the foundation of how we use data? We’re looking for a Data Specialist to take ownership of our dashboards, pipelines, and attribution infrastructure - transforming how we capture, interpret, and act on data. You’ll be responsible for maintaining and improving Aperture’s live reporting ecosystem across Meta, TikTok, GA4, and mobile measurement partners like AppsFlyer, Singular, and Adjust. You’ll collaborate with Performance, Creative, and Strategy teams to deliver insight-rich dashboards, automate reporting, and ensure attribution accuracy across every platform. This role is both technical and strategic. You’ll roll up your sleeves to build and refine data pipelines, but also think critically about how we can extract smarter insights, measure performance better, and engineer stronger signals. For the right person, this role will evolve into Data Lead - shaping the agency’s data vision, leading automation projects, and driving the next generation of growth intelligence across our clients and internal systems. Key Responsibilities: Dashboard ownership & evolution Take full ownership of all live dashboards (Performance, Creative, CRM, Paywall, SKAN). Audit and maintain existing dashboards for accuracy, freshness, and usability. Implement consistent naming conventions, version control, and documentation. Define and standardise core performance metrics (CAC, Trial CVR, LTV/CAC, EMQ). Continuously improve dashboard design, usability, and storytelling. Pipeline management & pptimisation Maintain and evolve data pipelines integrating Meta, TikTok, GA4, and MMPs (AppsFlyer, Singular, Adjust). Build reliability into all data processes with freshness checks, alerting, and automated retries. Optimise ETL workflows, schemas, and modular data structures. Manage orchestration tools (Airflow / Prefect) and transformation frameworks (dbt). Scale the stack to onboard new clients quickly and efficiently. Attribution & signal engineering Set up, manage, and QA attribution across MMPs (AppsFlyer, Singular, Adjust). Ensure correct event mapping and schema consistency across in-app, web, and server-side tracking. Lead configuration and monitoring of Google Tag Manager for server-side and web tracking. Troubleshoot discrepancies between Ads Manager, MMP, and analytics tools. Improve Meta Event Match Quality (EMQ) and Aggregated Event Measurement (AEM) accuracy. Manage SKAdNetwork implementation: conversion mapping, lock windows, postback decoding, and reporting. Collaborate with dev and product teams to improve event instrumentation and data flow. Data quality, governance & QA Define and monitor data quality metrics: freshness, completeness, and EMQ. Run QA and reconciliation checks across Meta CAPI, TikTok events, SKAN postbacks, and MMP conversions. Implement data tests, versioning, and documentation within dbt. Maintain a shared, well-documented Data Dictionary accessible across teams. Insight automation & enablement Automate reporting and anomaly detection (Slack/Email summaries, creative trend alerts, data drift warnings). Use AI tools to surface insights automatically and generate concise weekly narratives. Build processes that reduce manual reporting time for performance managers. Coach the team on how to interpret data and make evidence-based decisions. Strategic contribution Partner with Growth and Creative Leads to develop data-informed testing frameworks. Design attribution and incrementality methodologies for client campaigns. Support forecasting and LTV/CAC modelling using first-party and MMP data. Translate complex datasets into actionable insights and recommendations. The experience you need Proven experience building, maintaining, and optimising data pipelines across marketing and analytics tools. Skilled in working with APIs to connect platforms like Meta, TikTok, GA4, and mobile measurement partners (AppsFlyer, Singular, Adjust). Deep understanding of how to design and manage data warehouses, including structuring, modelling, and ensuring cost-efficient scalability. Confident in setting up automated reporting workflows and ensuring dashboards stay accurate, consistent, and up to date. Experienced in building and maintaining performance dashboards that blend ad, web, and app data for clear visibility into spend, CAC, trial CVR, and LTV. Capable of creating data testing and validation systems that catch discrepancies and ensure teams can trust what they see. Comfortable working with orchestration and transformation frameworks to schedule, automate, and monitor data tasks. Confident using data visualisation tools to present insights that guide decision-making and creative strategy. Adept at implementing attribution and event tracking setups, including server-side and client-side configuration through Google Tag Manager and MMPs. Able to debug and improve attribution flows, fix tracking inconsistencies, and ensure event integrity across web and app environments. Familiar with privacy-first data practices, attribution models, and signal engineering (CAPI, EMQ, SKAN, AEM). Desirables Strong grasp of mobile attribution and iOS tracking frameworks, including SKAdNetwork and postback decoding. Experience running MMP implementations end-to-end, including event schema design, testing, and rollout. Knowledge of cross-channel attribution, cohort analysis, and lifetime value modelling. Understanding of creative performance data, testing structures, and how to measure the impact of ad creative. Interest in emerging tools for automation, AI-driven insight generation, and creative intelligence reporting.

Responsibilities

The Data Specialist will take ownership of dashboards, pipelines, and attribution infrastructure, transforming how data is captured and interpreted. Responsibilities include maintaining live reporting ecosystems and collaborating with various teams to deliver insights and automate reporting.