At a Glance
- Tasks: Build and manage a modern data warehouse, collaborating with stakeholders for impactful data solutions.
- Company: Market-leading UK business with a strong national presence.
- Benefits: Up to £70,000 salary, hybrid work, and a collaborative team environment.
- Other info: Opportunity for career growth in a dynamic, agile environment.
- Why this job: Make a real impact in a small team while driving insight and innovation.
- Qualifications: Strong experience with Azure Data Factory, SQL Data Warehouse, and Power BI.
The predicted salary is between 42000 - 84000 £ per year.
BI ANALYST (12 MONTH FTC)
LONDON/HYBRID
UP TO £56,000
This is a highly visible Data & Business Intelligence Analyst role within a purpose-led, data-driven organisation. It offers the opportunity to work at the intersection of business and technology, helping shape how data is governed, structured, and used to support critical decision-making and regulatory reporting.
ROLES AND RESPONSIBILITIES:
The BI Analyst will:
- Gather, analyse, and document business and technical requirements across multiple teams
- Build dashboards and reports using Power BI to support internal and external reporting needs
- Deliver datasets and analytical outputs to support decision-making and regulatory reporting
- Support data governance activities, including data dictionaries, business glossaries, and metadata management
- Lead and contribute to data modelling initiatives, including current and future-state models
- Collaborate with Data Stewards and Data Owners to improve data quality and resolve issues
- Support ETL, data migration, mapping, and data cleansing activities
- Conduct testing, quality assurance, and User Acceptance Testing to ensure accuracy and reliability
- Contribute to wider transformation programmes and continuous improvement across data processes
YOUR SKILLS AND EXPERIENCE:
The ideal candidate will have the following skills and experience:
- Strong SQL skills and experience working with relational data
- Experience building dashboards and reports in Power BI, including use of DAX
- Solid understanding of data modelling principles such as star and snowflake schema
- Experience with ETL processes and data integration
- Strong experience gathering and translating business requirements into technical solutions
- Proven ability to work with stakeholders to improve reporting and data quality
- Experience developing and maintaining data governance artefacts such as data dictionaries and business glossaries
- Strong communication skills, able to engage both technical and non-technical audiences
- Detail-oriented with a focus on data accuracy and quality
APPLY BELOW!
Business Intelligence Analyst in Edinburgh employer: Harnham
Join a dynamic and innovative team as a Business Intelligence Analyst in West Yorkshire, where you will have the opportunity to shape the future of data solutions for a leading UK business. With a strong emphasis on collaboration and employee growth, this role offers a hybrid working model that promotes work-life balance while allowing you to make a significant impact in a supportive environment. Enjoy competitive remuneration, professional development opportunities, and the chance to work with cutting-edge technologies in a company that values your contributions.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Analyst in Edinburgh
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Showcase your skills! Create a portfolio that highlights your experience with Azure Data Factory and Power BI. Use real examples of projects you've worked on to demonstrate your expertise and make it easy for employers to see what you can bring to the table.
✨Tip Number 3
Prepare for interviews by practising common BI Analyst questions. Think about how you would approach building a data warehouse or collaborating with stakeholders. The more prepared you are, the more confident you'll feel when it's time to shine!
✨Tip Number 4
Don't forget to apply through our website! We’ve got loads of opportunities waiting for you, and applying directly can sometimes give you an edge. Plus, it’s super easy to keep track of your applications all in one place.
We think you need these skills to ace Business Intelligence Analyst in Edinburgh
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the BI Analyst role. Highlight your experience with Azure Data Factory and SQL Data Warehouse, as well as any relevant projects that showcase your skills in data management and analytics.
Showcase Your Collaboration Skills:Since this role involves working closely with stakeholders, emphasise your ability to collaborate effectively. Share examples of how you've partnered with others to gather requirements and deliver data solutions in previous roles.
Highlight Your Technical Expertise:Don’t forget to mention your hands-on experience with Power BI and CI/CD environments. We want to see your technical prowess, so include specific tools and technologies you've worked with that relate to the job description.
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and get you on our radar quickly!
How to prepare for a job interview at Harnham
✨Know Your Data Warehousing Inside Out
Make sure you brush up on your knowledge of data warehousing concepts, especially around Azure Data Factory and Azure SQL Data Warehouse. Be ready to discuss your previous experiences managing a data warehouse lifecycle and how you've tackled challenges in the past.
✨Showcase Your Collaboration Skills
Since this role involves working closely with stakeholders and Power BI developers, prepare examples that highlight your teamwork and communication skills. Think of specific instances where you successfully gathered requirements or collaborated on data solutions.
✨Demonstrate Your Technical Proficiency
Be prepared to dive into technical discussions about CI/CD pipelines and how they relate to your work. If you have experience with software development teams, share how you’ve integrated data solutions within those environments.
✨Ask Insightful Questions
Interviews are a two-way street! Prepare thoughtful questions about the company’s data strategy, the team dynamics, and how they measure success in this role. This shows your genuine interest and helps you assess if it’s the right fit for you.
