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.
- 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.
- Other info: Opportunity for career growth in a dynamic, agile environment.
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 your connections in the industry, attend meetups, and engage on platforms like LinkedIn. You never know who might have the inside scoop on a BI Analyst role or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your work with Azure Data Factory and Power BI. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common BI scenarios and case studies. Be ready to discuss how you've tackled data challenges in the past and how you can bring value to their team.
✨Tip Number 4
Don't forget to apply through our website! We make it easy for you to find roles that match your skills and interests. Plus, it shows you're serious about joining the team!
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 partner with others. Share examples of how you've gathered requirements and delivered solutions in previous roles to demonstrate your collaborative spirit.
Highlight Your Technical Expertise: Don’t forget to mention your hands-on experience with Power BI and CI/CD environments. We want to see that you’re comfortable with the tools and processes that will help us drive insight and innovation in our data solutions.
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 for this exciting opportunity!
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 the role involves working closely with stakeholders and Power BI developers, prepare examples that highlight your ability to collaborate effectively. Think of times when you gathered requirements or worked in a team to deliver data solutions, and be ready to share those stories.
✨Demonstrate Your Problem-Solving Abilities
Be prepared to discuss challenges you’ve faced in managing a data warehouse lifecycle. Think about specific problems you encountered and how you resolved them, especially in a CI/CD environment. This will show your adaptability and critical thinking skills.
✨Ask Insightful Questions
At the end of the interview, don’t forget to ask questions that demonstrate your interest in the company and the role. Inquire about their current data projects or how they envision the BI Analyst contributing to their goals. This shows you’re not just interested in the job, but also in the company’s vision.