Data engineer

грейд
senior
формат
гибрид Лондон
язык
Английский B1
опубликована
сегодня

описание

AKA London, hybrid. 3 days a week in the office

AKA is a full-service marketing and advertising agency for theatre and live entertainment, with offices in London and New York. We work with shows and their producers, and we use data, creativity and behavioural insight to get people to go places. We are looking for a Data Engineer to join our Data & Insights team in London and take primary responsibility for the data infrastructure behind our US business. You will report to Jonathan Courtney and work closely with analysts, data scientists and developers in both offices.

задачи

  • Lead the alignment of UK and US media and ticketing pipelines to serve Atlas, while keeping the existing structure for client services.
  • Help align our internal and client-facing data visualisation solutions, including Sigma, the platform of choice in our US team.
  • Move our orchestration and ingestion from managed services to self-hosted Dagster and open source Airbyte.
  • Design and deliver a common structure for UK and US media and ticketing data, including shared schemas, naming conventions and quality checks.
  • Migrate pipelines in stages, keeping existing client reporting stable throughout. No big-bang cutovers.
  • Onboard new clients and data sources in both regions, from sales and ticketing files to media platform connections.
  • Build and maintain ingestion of market activity data, including competitor sales and inventory from ticketing provider APIs and public booking sources, to benchmark client performance.
  • Work with the Data Scientist to productionise the matching, forecasting and modelling workflows that Atlas depends on.
  • Lead the move from cloud-hosted Dagster to a self-hosted deployment, including monitoring, upgrades, access control and run history.
  • Replace our managed ingestion service with self-hosted open source Airbyte on containers, using Docker and Kubernetes where appropriate. Migrate connectors in priority order and build custom connectors where none exist.
  • Maintain our Snowflake warehouse and dbt transformation layer and help retire legacy components such as our older sales data warehouse.
  • Run CI/CD, secrets management and cost monitoring for the platforms you own, and record tool decisions so the team knows why we chose what we chose.
  • Support the consolidation of our dashboard and reporting platforms around Sigma in the US, with a consistent data layer behind every tool.
  • Help build reusable templates and automated reporting that cut bespoke work for new clients.
  • Set and enforce data quality, security and documentation standards, with attention to UK and US privacy requirements. Build monitoring, alerting and runbooks.
  • Work with Sales & Ticketing, Digital Media, analysts and our digital product team. Explain technical trade-offs clearly to non-technical colleagues.
  • Use AI-assisted development tools in your daily work to move quickly without cutting corners.
  • Other Duties As Assigned AKA is a fluid and rapidly changing organisation. This position profile reflects the general nature and level of work assigned to the role. It does not restrict management's right to reassign duties or responsibilities at any time based on business needs if the work is similar, related, or a logical assignment

требования

  • 3+ years as a Data Engineer, with strong Python and SQL.
  • Production orchestration experience, such as Dagster, Airflow or Prefect, including self-hosted deployments.
  • Hands-on Docker, and working knowledge of Kubernetes or container hosting on a cloud virtual machine.
  • ETL tooling such as Fivetran or Airbyte, including API-based ingestion and custom connectors.
  • dbt and a cloud data warehouse, ideally Snowflake.
  • Strong fundamentals in version control, testing, CI/CD, monitoring and documentation.
  • Confident using AI coding assistants. Claude is available to everyone at AKA.
  • Clear writing for technical and non-technical readers.
  • Будет плюсом: Experience on Azure, which we use for storage and hosting; Experience with ticketing, CRM or media platform APIs; Sigma, Tableau, Power BI or open source reporting tools; Identity resolution, CDP or event streaming experience; Entertainment, media or ticketing sector experience; Asana or similar project management tools

условия

  • 25 days holiday
  • ‘Telus Health’ EAP scheme for you and your family. Giving you access to free independent advice on Life, Health, Family, Money and Work matters
  • Holiday Buy Back
  • Friends & Family Theatre Ticket
  • New Business Incentives
  • Recruitment Incentives
  • Pension Scheme*
  • Interest Free Travel Loan*
  • Ride to Work Scheme*
  • Childcare Vouchers*
  • Death in Service
  • Flexible/Hybrid Working
  • Critical Illness
  • Enhanced Parental Leave

навыки

похожие вакансии

статьи для разработчиков