At a Glance
- Tasks: Develop data products and optimise analytics for ITV's Insights Group.
- Company: Join ITV, a leading media company shaping the future of television.
- Benefits: Competitive salary, flexible work, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on innovation and career advancement.
- Why this job: Make a real impact in the TV industry with your data skills.
- Qualifications: 2+ years in data analytics or engineering, advanced SQL skills required.
The predicted salary is between 63000 - 77000 £ per year.
Workplace: London, White City. Expectation is 2 days in the office.
12 Month Fixed-Term Contract
Main purpose of the role: The ITV Insights Group will lead the business in putting insight in every key decision. For example; What content should we commission? Which audience is most commercially attractive for us? How do we optimise our product to improve view through rates? The answers to these questions and more will enable ITV to succeed in the future.
This role will be line managed by the Lead Analytics Developer, with the primary aim to develop data products to enable the analytics priorities of the Insights Group. The role will also work closely with the Head of Analytics and collaboratively with the analytics function within the Insights Group, as well as Central Insights and Data Science.
Specific responsibilities:
- Champion analytics engineering best practices within the Insights team by designing and structuring robust, SQL-based analytical pipelines.
- Maintain the M&E KPI pipeline, iterating on metrics as business needs evolve.
- Embed best practices by connecting Dataform to GitHub for seamless code sharing and version control.
- Design and implement rigorous data quality checks and automated tests, configuring proactive Slack notifications to alert the team to pipeline issues.
- Support the Central Data team to conduct thorough User Acceptance Testing (UAT) on newly developed data products.
- Collaborate closely with analysts and insights managers to design, build, and optimise tables that serve as the foundation for fast, efficient dashboards.
- Drive the migration of legacy processes over to BigQuery notebooks and pipelines, simultaneously reducing operational costs and improving query efficiency.
- Assist in rebuilding and maintaining ITVX streaming data as a robust dimensional model using dbt. This involves integrating complex datasets, such as content metadata, broadcast schedules, VOD windows, content contracts, and user demographics.
- Ensure all data products are comprehensively documented for the wider business.
- Explore and integrate new data sources to empower the Insights team. This includes building automated API connections (e.g. Barb) and proactively auditing varied sources (such as FAST schedule feeds) to guarantee our pipelines run on the most accurate data available.
- Bridge data and business value by acting as the link between source data and actionable insight.
- Help standardise data models, core metrics, and processes across the Insights team.
Experience Required:
- 2+ years of experience in data analytics, data engineering, or analytics engineering
- Advanced SQL proficiency: Ability to write complex, performant, and clean code
- Data Pipeline Development: Ability to design, build, and automate robust ELT/ETL pipelines to turn raw data into clean, reliable data products
- Transformation & Version Control: Experience using frameworks like dbt or Dataform, alongside Git for code management, collaboration, and version control
- Cloud Data Warehouse experience: Hands-on experience with GCP (BigQuery) or similar cloud platforms
- Data Modeling expertise: Understanding of data engineering principles and dimensional modelling (star schema, snowflake schema)
- Data Profiling: Strong ability to explore, compare, and validate different data sources to fully understand their structure and quirks
- A passion for TV Content, and ITV, with an excellent understanding and interest in television
Senior Analytics Engineer in London employer: ITV
ITV is an exceptional employer, offering a dynamic work culture that fosters collaboration and innovation in the heart of London. As a Data Insights Analyst, you will have access to cutting-edge tools and resources, alongside opportunities for professional growth and development within a leading media organisation. With a focus on employee well-being and a commitment to diversity, ITV provides a rewarding environment where your contributions directly impact audience engagement and content strategy.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Analytics Engineer in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like ITV!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Senior Analytics Engineer at ITV.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like ITV.
✨Apply Directly through Our Website
When you find a suitable opening like Senior Analytics Engineer at ITV, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Senior Analytics Engineer in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at ITV, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at ITV. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at ITV
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at ITV!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.