Description
Role Title: Senior Analytics Engineer
Reports to: Data Analytics Lead
Location: Hybrid (Paddington, London)
Role Type: Permanent, Full-time
Company Overview:
How do we say our name, well it sounds like 'view'. It's also a lot shorter than saying 'Viewed Impressions for Out Of Home'. VIOOH is a fast-growing startup that is defining the future of out-of-home advertising. We are a dynamic team building a global platform which automates the buying and selling of outdoor advertising, enables programmatic trading and delivers dynamic, data-driven content to screens in locations and moments to better resonate with and influence consumers. We've recently redesigned our people strategy to create a future-proof, hybrid and flexible workplace approach. Employees can work in the office (Paddington, London) and from home, empowering all VIOOHers to thrive regardless of location and ensuring we can attract diverse talent to support our global expansion.
Role Overview:
VIOOH is hiring a senior Analytics Engineer in its Analytics team. This is an exciting opportunity for an experienced Analytics Engineer to help build an end-to-end analytics platform from scratch. You will have the opportunity to work with multidisciplinary teams closely, create a data centric culture, and help colleagues understand their metrics by enabling the power of our data. As a "full-stack analyst", we expect you to own the end-to-end analytics process (from semi-raw data to charts) fully, have an outstanding intellectual curiosity to learn new technologies and excel in your domain. If you follow the current global developments in the analytics field, if you can adopt new technologies and implement them into our growing analytics function, if you're not afraid of challenging ideas, we'd like to hear from you.
Key Responsibilities:
- Working closely with the Data Analytics Lead to shape the future of our end-to-end analytics strategy
- Working closely with our data architects to maintain high standards of reliability, performance, and reusability of assets in our data warehouse
- Working closely with the data engineering team to build analytics data pipelines
- Creating analytics ready data models using software engineering best practices (version control, testing, continuous integration), supporting internal/external reporting as well as predictive modelling
- Creating a single source of truth and enabling a self-serve analytics culture
- Optimising our data warehouse to reduce cost and complexity
- Creating metrics; designing effective charts; developing user journeys for embedded analytics products
- Collaborating with product & commercial teams; understanding their analytical needs; transforming semi-raw data into insightful metrics/dashboards
Tools & Technologies Used:
- AWS S3 & AWS Athena for storage/queries
- Airflow for orchestration/ETL/ELT
- dbt for transformation
- Snowflake for warehousing
- Thoughtspot for visualisation
- Python & R for predictive modelling/automation
- GitHub for version control
What We Expect From You:
Extensive hands-on experience (ideally min. 3–5 years) in creating:
- Data models (strong dbt experience required)
- ETL/ELT pipelines for analytical applications.
Excellent SQL knowledge; ability writing complex queries answering business questions while creating efficient models enhancing user experiences.
Solid understanding of warehouse design principles.
Great attention detail.
Experience using visualisation tools (e.g., Thoughtspot Power BI Tableau Looker QuickSight); ability generating simple yet insightful visuals non-tech audiences.
Good understanding Git.
Experience collaborating engineering teams delivering solutions spanning systems users while working product/commercial teams providing clear reporting insights.
Experience handling JSON files since most company’s datasets require flattening processes.
Experience integrating multiple sources’ datasets.
Additional Qualifications:
Familiarity AWS environment (S3 Athena Redshift).
Experience Python frameworks/tools such as Airflow dbt pySpark Pandas.
Familiarity Snowflake or Thoughtspot platforms preferred but not mandatory.
Basic command line proficiency desired along some Kafka understanding would be beneficial too..
Master's degree/equivalent quantitative field preferred alongside previous Programmatic / AdTech experience.
Application Process at VIOOH:
Our recruitment team will work hard giving candidates positive experiences throughout processes regardless outcomes achieved during assessments/interviews leading up onboarding phases thereafter.VIOOH equal opportunities employer welcoming applications across society sections without discrimination based race religion belief ethnic/national origin disability age citizenship marital/domestic/civil partnership status sexual orientation gender identity any other basis protected applicable law.