At a Glance
- Tasks: Transform data into insights using SQL and Python, and create dashboards in Looker.
- Company: Join a fast-paced media streaming company with a collaborative analytics team.
- Benefits: Competitive salary, share options, 27 days holiday, and fully remote work.
- Other info: Work autonomously in a dynamic environment with opportunities for growth.
- Why this job: Make an impact by owning data end-to-end and automating processes.
- Qualifications: 2+ years as a Data Analyst with strong SQL and Python skills.
The predicted salary is between 37000 - 50000 £ per year.
Job Description
Data Analyst| Fully Remote (UK-based) | Permanent | SQL, Python, Looker, AWS
We are looking for a confident Data Analyst who’s experienced in writing complex SQL and Python scripts, building lightweight pipelines and presenting insights to business stakeholders using Looker Studio. You’ll be joining a fast-moving company in the Media Streaming sector and sit within a small, collaborative analytics function where there’s no separate data engineering team. You’ll own your data end-to-end, from extraction and validation through to automation and insight delivery. We are looking for someone who gets their hands dirty with the data, produces actionable insights, and automates everything they can.
WHAT YOU’LL DO
- Use SQL and Python (pandas, NumPy) daily to clean, join and transform data into analysis-ready tables.
- Build and maintain lightweight automated pipelines to refresh reports and validate data with minimal manual intervention.
- Create and update dashboards in Looker (experience with Power BI or Tableau also welcome).
- Implement automated data validation checks to ensure data accuracy and reliability.
- Translate complex data into clear, concise insights and visual narratives.
- Produce customer-ready insight reports used by internal and external teams.
- Document everything you build and apply version control (Git) for reproducibility.
WHAT WE’RE LOOKING FOR
Technical Skills – Must Have
- Strong SQL: confident writing complex queries, joining large datasets, and optimising performance.
- Strong Python: comfortable with pandas, NumPy, and writing automation scripts.
- Looker (or similar BI tool): able to create and maintain dashboards; happy to cross-train if experienced in Tableau or Power BI.
- Understanding of data validation and quality assurance techniques.
- Familiar with Git/version control and collaborative data practices.
Nice to Have
- Exposure to cloud environments (AWS preferred).
DATA ENGINEERING / AUTOMATION
- Able to design lightweight pipelines and automated processes (we are not expecting skills at the level of a Data Engineer).
- Experience scheduling data refreshes and monitoring job reliability.
- Understands the importance of automation - “no manual reporting.”
- Enthusiastic about the engineering side of analytics and eager to streamline workflows.
COMMUNICATION & PRESENTATION
- Excellent communication skills and confident presenting insights to non-technical audiences.
- Capable of producing customer-facing presentations and collaborating with Customer Success teams.
- Understands how to tell the story behind the numbers.
EXPERIENCE LEVEL
- Minimum 2 years’ experience as a Data Analyst.
- Should have worked in a business environment, ideally within a SaaS, startup or fast-paced setting.
- Comfortable operating autonomously as part of a small team.
Fully remote (UK-based only) – they meet up roughly twice a year.
N.B. They do not offer visa sponsorship and won’t consider those on short term visas.
SALARY & PACKAGE
- £37,000 – £50,000, depending on experience
- Permanent, full-time position.
- Share options available.
- 27 days holiday.
- Start date: ASAP
APPLY NOW for immediate consideration and interview in the next week.
Data Analyst| Fully Remote (UK-based) | Permanent | SQL, Python, Looker, AWS in Manchester employer: Avanti
Join a dynamic and innovative company in the Media Streaming sector, where you will thrive in a fully remote environment that fosters collaboration and autonomy. With a strong emphasis on employee growth, you will have the opportunity to take ownership of your data projects while enjoying a generous benefits package, including 27 days of holiday and share options. Our culture encourages hands-on engagement with data, ensuring that your contributions lead to meaningful insights and impactful decisions.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst| Fully Remote (UK-based) | Permanent | SQL, Python, Looker, AWS in Manchester
✨Tip Number 1
Get your networking game on! Reach out to people in the industry, especially those who work at companies you're interested in. A friendly chat can sometimes lead to job opportunities that aren't even advertised.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL queries, Python scripts, and any dashboards you've built in Looker or similar tools. This gives potential employers a taste of what you can do before they even meet you.
✨Tip Number 3
Prepare for interviews by brushing up on common data analysis scenarios. Be ready to discuss how you've tackled data challenges in the past and how you can automate processes to save time and improve accuracy.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Data Analyst| Fully Remote (UK-based) | Permanent | SQL, Python, Looker, AWS in Manchester
Some tips for your application 🫡
Show Off Your SQL Skills:Make sure to highlight your experience with SQL in your application. We want to see how you've tackled complex queries and optimised performance in your past roles. Don't be shy—give us examples of the datasets you've worked with!
Python is Key:Since Python is a big part of the role, let us know about your experience with libraries like pandas and NumPy. Share any automation scripts you've written and how they've helped streamline processes. We love seeing hands-on experience!
Dashboards Matter:If you've created dashboards in Looker or similar tools, make sure to mention that! Tell us about the insights you've presented and how they impacted decision-making. Visual storytelling is crucial for this role, so show us what you've got!
Apply Through Our Website:We encourage you to apply directly through our website for the best chance of getting noticed. Make your application stand out by tailoring it to the job description and showcasing your passion for data analytics. We can't wait to hear from you!
How to prepare for a job interview at Avanti
✨Know Your SQL and Python Inside Out
Make sure you brush up on your SQL and Python skills before the interview. Be ready to discuss complex queries you've written and how you've used libraries like pandas and NumPy in your projects. They’ll want to see that you can not only write code but also understand the logic behind it.
✨Showcase Your Dashboard Skills
Prepare to talk about your experience with Looker or any other BI tools like Power BI or Tableau. Bring examples of dashboards you've created and be ready to explain how they helped stakeholders make informed decisions. Visual storytelling is key, so think about how you can present your insights clearly.
✨Demonstrate Your Automation Mindset
Since this role emphasises automation, come prepared with examples of how you've built lightweight pipelines or automated processes in the past. Discuss any challenges you faced and how you overcame them. They’ll appreciate your enthusiasm for streamlining workflows and reducing manual reporting.
✨Communicate Clearly and Confidently
Practice explaining complex data concepts in simple terms, as you'll need to present insights to non-technical audiences. Think about how you can tell a compelling story with your data. Good communication skills are essential, so don’t shy away from showcasing your presentation abilities during the interview.
