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 and a collaborative team culture.
- Benefits: Up to £70,000 salary, hybrid work model, and opportunities for professional growth.
- Why this job: Make a real impact in a dynamic environment while working with cutting-edge data technologies.
- Qualifications: Strong experience with Azure Data Factory, SQL Data Warehouse, and Power BI.
- Other info: Join a small, agile team with excellent career development opportunities.
The predicted salary is between 42000 - 84000 £ per year.
BI Analyst
Up to £70,000
Hybrid – West Yorkshire (2x days per month)
We are seeking a skilled BI Analyst to take ownership of building and managing a modern data warehouse environment for a market-leading UK business with a strong national presence. This is an opportunity to make a real impact in a small, collaborative team, working closely with stakeholders across the organisation to deliver high-quality data solutions that drive insight and innovation.
The Role
- Partner with stakeholders across the business to gather requirements and design fit-for-purpose solutions
- Build and manage a data warehouse end-to-end, integrating data from multiple core platforms
- Work hands-on with Azure Data Factory for data extraction, transformation, and loading into an Azure SQL Data Warehouse
- Collaborate with Power BI developers to create effective data models and reporting solutions
- Operate within a CI/CD environment, engaging with wider software development teams
- Ensure robust connections and integrations (e.g. gateway setup) to enable seamless data flow
Skills & Experience
- Strong experience with Azure Data Factory and Azure SQL Data Warehouse
- Proven track record of managing a data warehouse lifecycle end-to-end
- Experience with Power BI for data modelling and analytics
- Knowledge of CI/CD pipelines and collaboration with software developers (desirable)
- Comfortable working both independently and in partnership with business stakeholders
- Adaptable and flexible – experience in smaller, agile teams a plus
If you would like to register your interest, send your CV to riversteytler@harnham.com. Please note our client cannot offer sponsorship.
Business Intelligence Analyst employer: Harnham
Contact Detail:
Harnham Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Intelligence Analyst
✨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 put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data projects, especially those involving Azure Data Factory and Power BI. This will give you an edge and demonstrate your hands-on experience to potential employers.
✨Tip Number 3
Prepare for interviews by brushing up on common BI scenarios and case studies. Be ready to discuss how you've tackled challenges in previous roles, particularly around data warehousing and stakeholder collaboration.
✨Tip Number 4
Don't forget to apply through our website! We make it easy for you to find the right opportunities and connect with companies looking for talent like yours. Plus, it shows you're serious about landing that BI Analyst role!
We think you need these skills to ace Business Intelligence Analyst
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 helps us keep track of your application and ensures you don’t miss out on any updates from us!
How to prepare for a job interview at Harnham
✨Know Your Data Inside Out
Before the interview, make sure you’re well-versed in the specifics of data warehousing and Azure technologies. Brush up on your experience with Azure Data Factory and SQL Data Warehouse, as you’ll likely be asked to discuss how you’ve used these tools in past projects.
✨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 situations where you successfully gathered requirements or collaborated on data solutions.
✨Demonstrate Your Problem-Solving Abilities
Be ready to discuss challenges you’ve faced in managing a data warehouse and how you overcame them. This could include issues with data integration or ensuring seamless data flow. Use the STAR method (Situation, Task, Action, Result) to structure your answers.
✨Familiarise Yourself with CI/CD Practices
Even if CI/CD experience is desirable rather than essential, showing that you understand the principles can set you apart. Brush up on how CI/CD pipelines work and think of any relevant experiences where you’ve engaged with software development teams.