Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform raw data into actionable insights and lead complex incidents for key clients.
- Company: Award-winning tech firm dedicated to positive change through data solutions.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Other info: Dynamic work environment with a focus on mentorship and career development.
- Why this job: Join a team that champions creativity and innovation while making a real impact.
- Qualifications: Experience in data analysis, strong communication skills, and knowledge of Microsoft technologies.
The predicted salary is between 45000 - 55000 £ per year.
Simpson Associates transforms raw data into actionable insights that drive positive change. Our Microsoft data expertise, specialist sector knowledge, and innovative advice are some of the reasons clients choose to work with us. Our mission is to help purpose-led organisations from both the public and private sectors harness data as a lever for change and enable them to realise business value more quickly. We provide a full range of services to support organisations on their data transformation journey, from advisory support and data strategy to developing Data & AI solutions and providing managed services.
We are a Microsoft Solutions Partner, holding specialisations in AI Platform on Microsoft Azure, Analytics on Microsoft Azure, Data Warehouse Migration to Microsoft Azure, and Migrate Enterprise Applications to Microsoft Azure. We also hold Solutions Partner designations in Data & AI (Azure), Digital & App Innovation (Azure), Infrastructure (Azure), and Security. We are proud to be recognised as the winner of the 2024 Microsoft Community Response Partner of the Year award, reflecting our dedication to using technology for positive change. Additionally, we are a Databricks partner and an IBM Gold Partner, specialising in Cognos Analytics and Planning Analytics.
With offices in York and Sheffield, and a team based throughout the UK, we champion creativity, innovation, and collaboration in the workplace. As a Level 2 Senior Data Consultant, you will act as a trusted advisor for key Managed Services clients, owning relationships and leading on complex incidents. This role combines advanced technical expertise with strong leadership and communication skills to deliver seamless service and long-term value.
- Perform advanced monitoring, maintenance, and health checks; identify and manage risks within the managed service contracts.
- Mentor and support Microsoft Consultants, developing their troubleshooting and communication skills.
- Work closely with Consulting and Delivery teams to ensure smooth project handovers.
- Manage utilisation and provide accurate reporting on support, maintaining understanding of client contracts and working with clients and internal teams to establish commercial cover for requests outside of contractual entitlements.
Required skills include:
- T-SQL, Azure SQL, Synapse Serverless DB, Data Factory/Synapse Pipelines, SSIS/SSAS/SSRS, Power BI, Databricks, Python, .NET, Microsoft Purview, Microsoft Fabric.
- Skilled at managing solutions across hybrid on-prem and cloud environments.
- Deep understanding of Data Warehousing principles, DR/HA concepts, patching, and installation strategies.
- Ability to evaluate multiple solution paths and consider long-term impacts.
- ITIL4 Foundation.
- Project management certification (Prince2, Agile, or equivalent).
- Terraform, Bicep, Git, DevOps, Azure IaaS/PaaS.
- Familiarity with modern DevOps pipelines and CI/CD approaches.
BI Consultant/Data Analyst in York employer: Simpson Associates
Contact Detail:
Simpson Associates Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land BI Consultant/Data Analyst in York
✨Tip Number 1
Network like a pro! Get out there and connect with people in the industry. Attend meetups, webinars, or even just grab a coffee with someone who works at Simpson Associates. Building relationships can open doors that a CV just can't.
✨Tip Number 2
Show off your skills! If you’ve got a portfolio of projects or case studies, make sure to share them during interviews. Demonstrating your expertise in T-SQL, Azure SQL, or Power BI can really set you apart from the competition.
✨Tip Number 3
Prepare for those tricky questions! Brush up on your knowledge of data warehousing principles and cloud environments. Being able to discuss your understanding of these topics confidently will impress the interviewers at Simpson Associates.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our team and contributing to our mission of driving positive change with data.
We think you need these skills to ace BI Consultant/Data Analyst in York
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the BI Consultant/Data Analyst role. Highlight your experience with T-SQL, Azure SQL, and any relevant projects that showcase your data expertise. We want to see how your skills align with our mission of transforming raw data into actionable insights!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data and how you can contribute to our team. Mention specific projects or experiences that relate to our work at Simpson Associates, and don’t forget to show your enthusiasm for using technology for positive change.
Showcase Your Technical Skills: We love seeing technical skills in action! Be sure to include any experience you have with tools like Power BI, Databricks, or Azure Data Factory. If you've worked on hybrid environments or have knowledge of DevOps practices, let us know – it could set you apart from the crowd!
Apply Through Our Website: Ready to take the plunge? 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 to know you better. Plus, it shows you're keen on joining our innovative team!
How to prepare for a job interview at Simpson Associates
✨Know Your Data Tools
Make sure you brush up on your knowledge of T-SQL, Azure SQL, and Power BI. Be ready to discuss how you've used these tools in past projects, as well as any challenges you've faced and how you overcame them.
✨Showcase Your Problem-Solving Skills
Prepare examples that highlight your ability to manage complex incidents and provide solutions. Think about specific situations where you identified risks and how you addressed them, especially in a managed services context.
✨Understand the Company’s Mission
Familiarise yourself with Simpson Associates' mission to drive positive change through data. Be prepared to discuss how your values align with theirs and how you can contribute to their goal of helping organisations realise business value.
✨Demonstrate Leadership and Mentoring Experience
Since the role involves mentoring Microsoft Consultants, think of instances where you've led a team or supported others in developing their skills. Highlight your communication style and how you foster collaboration within a team.