At a Glance
- Tasks: Become the Power BI champion and enhance dashboards for impactful insights.
- Company: Join a fast-growing company in the buy-now-pay-later automotive sector.
- Benefits: Enjoy a competitive salary and the flexibility of 3 days in the office.
- Why this job: Be part of a small, dynamic team driving innovation in data analytics.
- Qualifications: Experience with Power BI, SQL, and data pipeline management is essential.
- Other info: Opportunity to work with cutting-edge technologies like AWS and PostgreSQL.
The predicted salary is between 40000 - 84000 £ per year.
Data & BI Analyst
West London – 3 days in office
£50,000 – £60,000
Company Overview:
This organisation operates in the buy-now-pay-later sector within the automotive industry, providing financing solutions for car servicing and repairs. By partnering with garages and dealerships, they offer interest-free payment plans and other financing options to customers. The company is experiencing rapid growth, expanding into new countries and markets.
The role reports directly to the Head of Data and joins a small team of four.
Technical Environment:
- Reporting Tools: Power BI for internal analytics and reporting.
- Data Infrastructure: AWS, MySQL, and PostgreSQL.
- Data Pipeline Management: Airflow to orchestrate workflows.
- Data Sources: APIs, S3, and other external sources.
Role Overview:
This position focuses on being the Power BI champion, owning and scaling the entire Power BI stack. Key responsibilities include:
- Enhancing Power BI dashboards, implementing features like Incremental Refreshing, ROS, and version control, and improving documentation.
- Optimising SQL data models using joins, window functions, and performance tuning.
- Collaborating with a skilled team to scale operations and modernise reporting.
- Taking an autonomous approach with opportunities to lead new projects and explore other data areas after core duties are met.
Candidate Requirements:
- Expertise in Power BI and SQL, with hands-on experience in advanced features like Incremental Refreshing, Role-based Security (ROS), and version control.
- Proficiency in SQL techniques, including joins and windowing functions, with a focus on performance optimisation.
- A background in financial services is advantageous but not essential, particularly a familiarity with concepts like interest rates.
- An autonomous work style, with the ability to manage tasks independently and innovate in a fast-paced environment.
This is a unique opportunity for a driven professional to lead and elevate a Power BI environment while contributing to the broader data strategy in a rapidly growing organisation.
Data & BI Analyst employer: Harnham
Contact Detail:
Harnham Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data & BI Analyst
✨Tip Number 1
Familiarize yourself with Power BI and its advanced features. Since this role emphasizes being the Power BI champion, showcasing your expertise in enhancing dashboards and implementing features like Incremental Refreshing will set you apart.
✨Tip Number 2
Brush up on your SQL skills, particularly with joins, window functions, and performance tuning. Being able to demonstrate your ability to optimize SQL data models will be crucial for this position.
✨Tip Number 3
Gain a solid understanding of AWS and data pipeline management tools like Airflow. Highlighting any experience you have with these technologies will show that you're ready to contribute to the team from day one.
✨Tip Number 4
Prepare to discuss your experience with data sources such as APIs and S3. Being able to articulate how you've worked with various data sources in the past will demonstrate your versatility and readiness for the role.
We think you need these skills to ace Data & BI Analyst
Some tips for your application 🫡
Understand the Role: Make sure to thoroughly read the job description for the Data & BI Analyst position. Understand the key responsibilities and required skills, especially around Power BI, SQL, and data pipeline management.
Tailor Your CV: Customize your CV to highlight relevant experience and skills that align with the job requirements. Emphasize your expertise in Power BI, SQL optimization, and any experience with AWS or PostgreSQL.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for data analytics and your understanding of the buy-now-pay-later sector. Mention specific projects or achievements that demonstrate your ability to enhance Power BI dashboards and optimize data models.
Highlight Team Collaboration: Since the role involves working closely with a small team, emphasize your teamwork skills. Provide examples of how you've successfully collaborated on data projects in the past, showcasing your ability to contribute to a skilled team.
How to prepare for a job interview at Harnham
✨Showcase Your Power BI Expertise
Since the role emphasizes being the Power BI champion, be prepared to discuss your experience with Power BI in detail. Bring examples of dashboards you've created and enhancements you've implemented, especially features like Incremental Refreshing and version control.
✨Demonstrate SQL Proficiency
The job requires optimizing SQL data models, so brush up on your SQL skills. Be ready to explain how you've used joins, window functions, and performance tuning in past projects. Consider preparing a small SQL challenge to showcase your problem-solving abilities.
✨Familiarize Yourself with the Technical Environment
Understand the tools and technologies mentioned in the job description, such as AWS, MySQL, PostgreSQL, and Airflow. Being able to discuss how these tools fit into your previous work will show that you're well-prepared and knowledgeable about the technical landscape.
✨Highlight Collaboration Skills
This role involves working closely with a small team, so emphasize your ability to collaborate effectively. Share examples of how you've worked with others to achieve common goals, particularly in data-related projects, to demonstrate your teamwork skills.