At a Glance
- Tasks: Lead the design and evolution of a cloud-based Azure data estate and create impactful Power BI dashboards.
- Company: Join a dynamic product manufacturing business on the outskirts of Norwich, focused on data-driven decision-making.
- Benefits: Enjoy a competitive package, career progression, and a supportive work environment with hands-on influence.
- Why this job: Shape a modern BI function while mentoring a small team and promoting a data-driven culture.
- Qualifications: Deep expertise in Microsoft SQL Server, Azure data stack, and strong Power BI skills required.
- Other info: Experience in leading technical teams and supporting M&A data workstreams is desirable.
The predicted salary is between 48000 - 72000 £ per year.
Job Description
Are you ready to take ownership of a growing Data & BI function? This is a fantastic opportunity for a hands-on leader to shape and evolve a modern Microsoft data platform, deliver insightful analytics, and mentor a small team while remaining close to the technology in a product manufacturing business on the outskirts of Norwich. We’re looking for someone who thrives at the intersection of strategy and delivery: an architect who enjoys rolling up their sleeves, building high-quality SQL and ETL solutions, and turning complex datasets into impactful Power BI dashboards that drive decision-making.What you’ll be doing
- Lead the design, optimisation, and ongoing evolution of a cloud-based Azure data estate.
- Build and maintain SQL models, queries, and stored procedures to deliver accurate, performant datasets.
- Develop and manage ETL/ELT pipelines using Azure Data Factory and Python.
- Create engaging Power BI dashboards using advanced DAX and Power Query/M.
- Ensure strong governance and data quality standards, providing a trusted “single source of truth.”
- Work with stakeholders across multiple functions to translate business requirements into technical solutions.
- Automate reporting processes to improve efficiency and reliability.
- Provide technical leadership and mentoring to a small BI team, encouraging best practice and continuous improvement.
- Promote data literacy and adoption across the organisation, helping to embed data-driven culture.
What we’re looking for
- Deep expertise in Microsoft SQL Server, including T-SQL, indexing, and performance tuning.
- Proven experience with the Azure data stack (Data Factory, Data Lake Gen2, SQL MI, Power BI, Purview).
- Strong Power BI skills (advanced DAX, Power Query/M).
- Solid understanding of data modelling, ETL design, and relational database principles.
- Proficiency with Python for automation and API integrations.
- Excellent communication and stakeholder management skills.
- Previous experience leading or mentoring a technical team.
- Experience supporting M&A data workstreams (desirable).
Why join?
- Opportunity to lead and shape a modern BI function.
- A hands-on role with real influence on technical direction.
- Work across a variety of stakeholders, from operational teams to executive leadership.
- Competitive package and career progression within a supportive environment.
Data and BI Manager employer: Pure Resourcing Solutions
Contact Detail:
Pure Resourcing Solutions Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data and BI Manager
✨Tip Number 1
Familiarise yourself with the specific tools and technologies mentioned in the job description, such as Azure Data Factory, Power BI, and SQL Server. Having hands-on experience or projects that showcase your skills with these platforms will make you stand out.
✨Tip Number 2
Network with professionals in the data and BI field, especially those who have experience in product manufacturing. Engaging with industry-specific groups on LinkedIn can provide insights and potentially lead to referrals.
✨Tip Number 3
Prepare to discuss your leadership style and experiences in mentoring teams during interviews. Highlight specific examples where you've successfully led a project or improved processes, as this aligns with the role's requirements.
✨Tip Number 4
Showcase your ability to translate complex data into actionable insights. Be ready to present case studies or examples of how your analytical skills have driven decision-making in previous roles, as this is crucial for the position.
We think you need these skills to ace Data and BI Manager
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Microsoft SQL Server, Azure data stack, and Power BI. Use specific examples that demonstrate your expertise in these areas, especially any leadership or mentoring roles you've held.
Craft a Compelling Cover Letter: In your cover letter, express your passion for data and BI management. Discuss how your skills align with the job requirements, particularly your experience in building SQL models and creating impactful Power BI dashboards.
Showcase Relevant Projects: If you have worked on projects involving ETL/ELT pipelines or automated reporting processes, be sure to mention these. Highlight any specific achievements that demonstrate your ability to deliver insightful analytics and improve efficiency.
Prepare for Technical Questions: Anticipate technical questions related to SQL, Azure, and Power BI during the interview process. Brush up on your knowledge of DAX, data modelling, and performance tuning to showcase your expertise effectively.
How to prepare for a job interview at Pure Resourcing Solutions
✨Showcase Your Technical Skills
Be prepared to discuss your experience with Microsoft SQL Server, Azure data stack, and Power BI in detail. Bring examples of past projects where you optimised SQL queries or built impactful dashboards, as this will demonstrate your hands-on expertise.
✨Demonstrate Leadership Qualities
Since the role involves mentoring a small team, be ready to share your leadership experiences. Discuss how you've guided teams in the past, encouraged best practices, and fostered a culture of continuous improvement.
✨Understand the Business Context
Research the company and its industry to understand their specific data challenges. Be prepared to discuss how you can translate business requirements into technical solutions that drive decision-making and improve efficiency.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving skills, particularly in data governance and quality assurance. Think of scenarios where you had to ensure data integrity or automate reporting processes, and be ready to explain your approach.