Data Engineer

Data Engineer – Job Specification

Location:Hybrid (1–2 days per month in Nottingham)

Salary:£60,000

Summary

An exciting opportunity for a passionate Data Engineer to join a growing consultancy business at a pivotal stage of its development. This role sits at the forefront of data infrastructure design, development, and optimisation — supporting enterprise-level solutions, modern data platform projects, and consultancy-led client engagements.

You’ll play a hands-on role in delivering robust, scalable data engineering solutions while advocating for best practices across the business. Ideal for someone with a proactive mindset, who wants to make a tangible impact and be part of shaping the future of a data-driven organisation.

Key Responsibilities

Consultancy & Client Delivery:

• Communicate clearly with project managers and stakeholders, translating technical concepts for non-technical audiences.
• Run client advisory sessions and online enablement workshops focused on modern data tools, including Power BI and metadata-driven solutions.
• Provide guidance and mentoring to junior team members on project delivery standards and best practices.

Data Engineering & Infrastructure:

• Develop and maintain scalable data pipelines and integration solutions using modern cloud technologies.
• Identify opportunities for reuse of data flows across projects and teams.
• Ensure data quality, integrity, and performance optimisation throughout the data lifecycle.
• Design and manage metadata repositories, supporting metadata-driven ETL frameworks.

Systems Integration:

• Ensure seamless integration between multiple data platforms and business systems.
• Troubleshoot and resolve data flow and system issues, collaborating closely with technical and non-technical stakeholders.

Advocacy & Innovation:

• Champion modern data engineering techniques, tooling, and approaches within the business.
• Stay up to date with emerging data engineering trends and identify opportunities for continuous improvement.

Essential Skills & Experience

Technical Skills:

• Data Build Tool (DBT):Minimum 1 year’s hands-on project delivery experience.
• Microsoft Fabric:Minimum 1 year of practical experience working with Fabric-based solutions.

Azure Ecosystem:

• At least 2 years of experience delivering business solutions using:
• Azure Data Factory / Synapse
• Power BI
• Azure SQL Server

Data Modelling:

• Strong knowledge of dimensional modelling (Kimball).
• Familiarity with other techniques such as Data Vault 2.0.

Development Experience:

• Minimum 3 years in database and/or analytics systems development and deployment.
• Strong understanding of Python and Spark for data transformation and pipeline development.

Consulting & Client-Facing:

• Experience working on consultancy-led projects with external clients.
• Ability to deliver against agreed project milestones and manage client expectations.
• Comfortable running advisory and enablement sessions (online training, mentoring, and client coaching).
• Likeable, engaging personality with a collaborative, proactive approach.

Desirable Skills

• Azure Data Lake (Azure Storage)
• Familiarity with additional database technologies such as Oracle, Cosmos DB, and MySQL
• Experience with BI/reporting tools like QlikSense and Tableau
• Database performance tuning, query optimisation, and diagnostics
• Cloud infrastructure knowledge (Google Cloud, AWS)
• Data migration projects, particularly high-performance stored procedures

What They’re Looking For

This role is ideal for a driven, enthusiastic Data Engineer who doesn’t just want a job- but a business to build with. Someone for whom this opportunity is their number one choice; a professional keen to make an impact, grow with the business, and be part of its success story.

Candidates should be personable, passionate about data, and eager to champion new ideas and innovations.

Working Arrangements

• Hybrid working with1–2 days per month in Nottingham
• Focus on personal development, innovation, and making a business-wide impact