At a Glance
- Tasks: Transform complex data into actionable insights and deliver high-quality reporting.
- Company: A data-driven organisation focused on leveraging data as a strategic asset.
- Benefits: Competitive salary up to £56,000 and opportunities for professional growth.
- Other info: Collaborative culture with a focus on continuous improvement and data governance.
- Why this job: Shape key business decisions and make a measurable impact with your data skills.
- Qualifications: Strong SQL experience, Power BI dashboard creation, and analytical mindset.
The predicted salary is between 56000 - 56000 £ per year.
This is an opportunity to join a data-driven organisation where your work will directly shape how key decisions are made. You will play a central role in transforming complex data into clear, actionable insights, working across multiple teams to improve reporting, governance, and data quality.
The Company
They are a well-established organisation with a strong focus on data as a strategic asset. Their Data and Analytics function is at the core of business performance, supporting a wide range of stakeholders with critical insights. They are investing in modern data tooling and best practices, creating an environment where analysts can develop and make a measurable impact. Collaboration and continuous improvement are central to their culture.
The Role
You will work closely with stakeholders to understand business needs and deliver high-quality data solutions and reporting. Key responsibilities include:
- Partnering with stakeholders to gather, analyse, and document data and reporting requirements
- Building and delivering dashboards and visualisations using Power BI
- Writing complex SQL queries to extract and manipulate data
- Supporting data modelling and contributing to the development of scalable data structures
- Collaborating with data engineers on ETL processes and pipeline development
- Ensuring data quality through testing, validation, and issue resolution
- Supporting data governance by maintaining data dictionaries, metadata, and KPI definitions
- Leading data-related initiatives such as data cleansing, migration, and transformation
Your Skills & Experience
- Strong commercial experience with SQL and relational databases
- Hands-on experience building dashboards in Power BI, including DAX
- Solid understanding of data modelling concepts such as star and snowflake schemas
- Experience working with ETL processes and data integration
- Ability to translate business requirements into technical solutions
- Strong analytical mindset with attention to detail and data accuracy
- Experience working with stakeholders across different levels of an organisation
- Knowledge of data governance practices and documentation standards
Data and BI Analyst in York employer: Harnham
Join a forward-thinking organisation in London that prioritises data as a strategic asset, offering you the chance to make a significant impact through your analytical skills. With a strong emphasis on collaboration and continuous improvement, you'll benefit from a supportive work culture that encourages professional growth and the use of modern data tools. This role not only allows you to develop your expertise in data analytics but also positions you at the heart of decision-making processes, ensuring your contributions are valued and recognised.
StudySmarter Expert Advice🤫
We think this is how you could land Data and BI Analyst in York
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. The more you engage, the better your chances of landing that Data and BI Analyst role.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI dashboards and SQL projects. This gives you a chance to demonstrate your expertise and makes you stand out when applying through our website.
✨Tip Number 3
Prepare for interviews by brushing up on common data-related questions and scenarios. Practice explaining your thought process when tackling data challenges, as this will show your analytical mindset and problem-solving skills.
✨Tip Number 4
Follow up after interviews! A quick thank-you email can leave a lasting impression and shows your enthusiasm for the role. Plus, it keeps you on their radar as they make their decision.
We think you need these skills to ace Data and BI Analyst in York
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the Data and BI Analyst role. Highlight your SQL expertise, Power BI projects, and any relevant data governance experience to catch our eye!
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're passionate about data and how you can contribute to our team. Share specific examples of how you've transformed data into actionable insights in previous roles.
Showcase Your Analytical Skills:In your application, don’t just list your skills—demonstrate them! Include examples of complex SQL queries you've written or dashboards you've built. We love seeing how you’ve tackled real-world data challenges.
Apply Through Our Website:We encourage you to apply directly through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensure it reaches the right people!
How to prepare for a job interview at Harnham
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss complex queries you've written and how they helped solve business problems. Practising some common SQL questions can really help you stand out.
✨Show Off Your Power BI Skills
Since you'll be building dashboards in Power BI, it’s crucial to showcase your experience. Bring examples of dashboards you've created, and be ready to explain your design choices and how they provided actionable insights for stakeholders.
✨Understand Data Modelling Concepts
Familiarise yourself with data modelling concepts like star and snowflake schemas. Be prepared to discuss how these models can impact data quality and reporting. This shows that you not only know the tools but also the theory behind them.
✨Emphasise Collaboration and Communication
This role involves working closely with various stakeholders, so highlight your experience in collaborating across teams. Share specific examples of how you’ve gathered requirements and translated them into technical solutions, demonstrating your ability to bridge the gap between technical and non-technical teams.
