Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead data engineering projects using Microsoft Fabric and Databricks to deliver impactful solutions.
- Company: Simpson Associates, a Microsoft Solutions Partner recognised for positive change through technology.
- Benefits: Competitive salary, professional development, and a collaborative work environment.
- Other info: Opportunities for mentorship and career growth in a dynamic, innovative setting.
- Why this job: Join a team that transforms data into actionable insights for purpose-led organisations.
- Qualifications: Experience in Azure data engineering and strong communication skills required.
The predicted salary is between 55000 - 65000 £ per year.
Simpson Associates transforms raw data into actionable insights that drive positive change. Our Microsoft data expertise, specialist sector knowledge, plus our innovative and trusted advice and guidance are just some of the reasons clients choose to work with us. Our mission is to help purpose-led organisations from within the public and private sectors to harness data as a lever for change and enable them to realise business value more quickly. We provide the full range of services to support organisations on their data transformation journey.
The Lead Consultant plays a pivotal role within the Data Engineering capability, delivering high-quality solutions using Microsoft Fabric, Databricks and Azure-native technologies. The role may involve running projects independently or leading workstreams within larger and more complex engagements under the direction of a Principal Consultant.
A Lead Consultant is the primary point of contact for customers during delivery and is expected to combine strong technical capability with excellent consultancy, communication and leadership skills. You will be responsible for shaping solutions, guiding delivery teams, and ensuring projects are delivered to time, cost and quality expectations, while supporting the development of junior consultants.
Key Responsibilities- Lead the end-to-end delivery of data engineering projects, either independently or as part of larger multi-disciplinary programmes.
- Act as the primary service delivery contact for customers, building trusted relationships and providing clear technical leadership.
- Demonstrate deep technical expertise in data engineering, understanding how solutions fit within wider customer architectures and business requirements.
- Work with customers to identify, challenge and prioritise business and technical requirements, including running design and discovery workshops.
- Translate functional and non-functional requirements into robust, scalable data platform architectures and technical designs.
- Design and implement data engineering solutions using Microsoft Fabric and Databricks, following best-practice approaches.
- Produce clear technical documentation and communicate designs using appropriate visualisations (e.g. architecture diagrams, data flows).
- Accurately estimate delivery effort, contributing to proposals and addressing variances between pre-sales estimates and detailed requirements.
- Convert estimates into delivery plans and manage these throughout the project lifecycle, working with Project Management and Scheduling as required.
- Provide hands-on technical delivery alongside other consultants when appropriate.
- Take overall responsibility for solution and delivery quality, including code reviews, testing strategies and customer acceptance.
- Identify, manage and mitigate delivery risks and issues early, drawing on experience to pre-empt likely challenges.
- Ensure appropriate deployment, handover and transition into support or managed services.
- Mentor and support junior consultants, contributing to capability development within the Data Engineering team.
- Contribute to intellectual property, reusable assets, marketing content, case studies and blogs.
- Technical Skills
- Strong experience designing and delivering modern data engineering solutions on Azure.
- Hands-on expertise with Microsoft Fabric, including Lakehouse, Data Engineering and orchestration capabilities.
- Strong experience with Databricks, including Spark-based data processing and optimisation.
- Solid understanding of data modelling, data integration patterns, and ELT/ETL pipelines.
- Experience working with Azure data services such as Azure Data Lake, Azure SQL and related platform components.
- Knowledge of DevOps and deployment practices for data platforms (e.g. CI/CD, version control, automated testing).
- Consulting & Delivery Skills
- Proven experience delivering projects within agreed time, cost and quality constraints.
- Strong ability to communicate complex technical concepts clearly to both technical and non-technical stakeholders.
- Experience leading delivery in both waterfall and agile environments and adapting approach to suit the customer and engagement.
- Commercial awareness and consultative mindset, with the ability to identify additional opportunities and add value for customers.
- Personal Attributes
- Confident, proactive problem-solver who remains calm and reassuring in customer-facing situations.
- Strong organisational and time management skills, with the ability to manage multiple priorities simultaneously.
- A proven self-starter, comfortable working independently while contributing positively to team delivery.
- Commitment to continuous professional development and maintaining up-to-date technical and consultancy skills.
- Willingness to mentor others and contribute to a collaborative, knowledge-sharing culture.
Data Engineer employer: Simpson Associates
Contact Detail:
Simpson Associates Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer
✨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
Show off your skills! Create a portfolio showcasing your data engineering projects, especially those using Microsoft Fabric and Databricks. This gives you a chance to demonstrate your expertise and makes you stand out during interviews.
✨Tip Number 3
Prepare for interviews by brushing up on common data engineering questions and scenarios. Practice explaining complex concepts in simple terms, as you'll need to communicate effectively with both technical and non-technical stakeholders.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, it shows you’re genuinely interested in joining our team at Simpson Associates.
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with Azure and data engineering. We want to see how your skills align with our mission of transforming data into actionable insights!
Showcase Your Projects: Include specific examples of projects you've worked on, especially those involving Microsoft Fabric or Databricks. We love seeing real-world applications of your skills, so don’t hold back!
Be Clear and Concise: When writing your application, keep it straightforward and to the point. Use clear language to explain your technical expertise and how it fits within the role. We appreciate clarity just as much as you do!
Apply Through Our Website: We encourage you to submit your application through our website. It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Simpson Associates
✨Know Your Tech Inside Out
Make sure you brush up on your knowledge of Microsoft Fabric, Databricks, and Azure data services. Be ready to discuss how you've used these technologies in past projects, as well as any challenges you've faced and how you overcame them.
✨Showcase Your Consultancy Skills
Since the role involves a lot of customer interaction, prepare examples that highlight your ability to communicate complex technical concepts clearly. Think about times when you've successfully led workshops or managed client expectations.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve hypothetical problems related to data engineering projects. Practice articulating your thought process and decision-making steps, especially around risk management and delivery quality.
✨Demonstrate Your Leadership Qualities
As a Lead Consultant, you'll need to show that you can guide teams and mentor junior consultants. Prepare examples of how you've supported others in their development and contributed to team success in previous roles.