Data and Development Engineer

Galliford Try; Metropolitan Borough of Solihull; On-site; GBP 60,000 - 90,000; Full time

Benefits offered by this job

Be Well programme

Agile Working programme

Pension plan

Private medical scheme

Job summary

Galliford Try is seeking a Data & Development Engineer in Solihull to join the Data, Analytics and Development team within IT. You will handle data lifecycle activities from source connect to data platform, build ETL pipelines, design scalable databases, and develop dashboards for self-service insights.

The role emphasizes data quality, security and collaboration with the wider data practice, including AI applications and standards adopting best practices across the business.

Qualifications

• Strong understanding of database architecture and data modelling.
• Experience with ETL, data pipelines and data integration from multiple sources.
• Experience in reporting, analytics and AI applications is desirable.

Responsibilities

• Data Connection: establish feeds from internal/external sources and design data pipelines into Galliford Try’s data platform.
• Storage and Management: design database architectures for staging and storage, ensure data quality and security.
• Transformation: build ETL pipelines to model data for reporting and analytics.
• Reporting: develop interactive dashboards to enable self-service data access.
• Analytics and AI: apply models and analytics techniques to enhance data value, including ML/AI applications.
• Standards and Best Practice: champion central standards and support wider data practitioners.

Skills

T-SQL

DAX

M Language

Python

Azure data services

Microsoft Fabric

Power BI

Tools

Oracle SQL

Git

Power BI

Azure Data Factory

Job description

Role Title: Data & Development Engineer

Business Unit: Group Services

Location: Solihull

Role Overview

The data and development engineer role is part of the Data, Analytics and Development team within the IT function at Galliford Try. The accountabilities for the role sit across the whole data lifecycle from the point of connecting to data at source, through the ETL process, management of data within our data platform, integrations, master data management, reporting, analytics and AI. It is critical that the role demonstrates best practice and supports the rest of the central team and wider network of data practitioners across the business in maximising the value that can be derived from data.

What You Will Be Doing:

• Data Connection: Working with APIs and other transfer mechanisms to establish data feeds from various internal and external sources, designing and implementing efficient data pipelines to pass data into Galliford Try’s data platform.
• Storage and Management: Designing and implementing appropriate database architecture for staging and storing data, implementing appropriate schemas and following best practice to ensure data quality, integrity and security.
• Transformation: Designing and implementing ETL pipelines to transform and model data into a format and structure suitable for reporting and analytics.
• Reporting: Developing interactive dashboards to support the business in self-serving the data and insight they need.
• Analytics and AI: Using models and analytics techniques to enhance or add value to data. This could relate to supervised/unsupervised machine learning and have applications across advanced analytics and AI agent development.
• Standards and Best Practice: Adopting best practice and championing the standards established by the central team, providing support and guidance to the wider network of data practitioners and users across the business.

Contribution to Ways of Working: Providing constructive challenge to team ways of working and putting forward ideas for improvements and new opportunities.

About You:

• Ability to work with stakeholders to understand different areas of the business and capture their requirements in a structured way.
• Ability to translate business requirements into technical requirements to inform a solution design.
• Competent in creating high-level design documents and low-level technical designs.
• A strong understanding of database architecture and the fundamentals of database management and data modelling.
• Good understanding of base structures and the capability of languages such as T-SQL, DAX, M Language, and Python.
• Strong experience with the Microsoft stack whether via Azure data services or Microsoft Fabric.
• Able to demonstrate alignment and work in-line with the Galliford Try values - Excellence, Passion, Integrity, and Collaboration
• Excellent interpersonal and written communication skills, with the ability to discuss and simplify technical concepts for non-technical stakeholders.
• Excellent organisational skills in managing personal workload and to take the lead and responsibility for projects.

Desirable:

• Experience working with Oracle databases and Oracle SQL.
• Experience developing reports using Power BI.
• Experience of using Git to manage version control.

Experience of working to Agile methodology either via Kanban or sprint approaches.

What We Can Offer in Return:

With an impressive order book of over £4.1 billion we are one of the industry’s leading principal contractors, affording you the opportunity to work on some of the UK’s most exciting projects offering you stability as well as the chance to stretch your capabilities and realise long held career goals. You will be joining diverse teams working at a high professional level with exceptional levels of commitment. With an ambitious strategy, we’re poised for further growth and success, so if you’re committed, talented and enthusiastic, Galliford Try is the right place for you.

We are committed to maintaining the physical and mental wellbeing of all our people, through our ‘Be Well’ programme which offers discounts on certain products, advice and support for a range of issues.

We invest in high-quality training for employees of all levels, from our leadership development framework to our apprenticeship programmes. Through our Career Paths initiative, individuals receive tailored training and support to fulfil their potential.

Our industry is all about creating talented teams that excel in their areas of expertise. As an employer, we know you are most motivated to give your best when you feel valued and engaged.

Our Agile Working programme empowers you with flexibility in when, where and how you work. Where appropriate, site and office-based employees can take advantage of a wide variety of working practices, offering different amounts of structure, regularity and flexibility to suit your needs as well as those of your wider team.

Our Benefits:

We put our people first and our benefits package reflects that by offering a comprehensive range of attractive options to help support your career on top of a competitive salary.

• Generous holiday entitlement, increasing with years of service, plus the opportunity to purchase further holidays
• A wide range of corporate discounts
• Cycle to Work schemes
• Comprehensive pension plan
• Regular Save as You Earn share purchase scheme
• Private medical scheme options are available for all salaried employees and our employee assistance programme also provides free 24/7 support to those who need it
• Paid for yearly membership to one recognised professional association relevant to your role

About us:

Galliford Try is one of the UK’s leading construction groups with a vision to continuously be a people-orientated, progressive business, driven by our values to deliver lasting change for our stakeholders and the communities we work in.

Our purpose is to improve people’s lives through building the facilities and infrastructure that communities need, providing opportunities for our people to learn, grow and progress, working with our supply chain to promote the very best working practice and caring for the environment in which we work.

We do this by holding true to our values, delivering excellence for our clients and the community, being passionate about our role in providing vital services, putting integrity at the heart of our business by doing the right thing, and collaborating with our clients, supply chain and stakeholders to deliver lasting change and long-term value.

For more information on this role or to enquire about other positions available within our Specialist Services business please contact [e-mail]

Additional Information:

Galliford Try welcomes applications from candidates who would like to work full-time, reduced hours or flexibly and this will be discussed in more detail as part of the recruitment process.

We encourage, and would be grateful if, you could confirm any requirements we can reasonably fulfil to make this application a positive experience for you.

Don’t meet every requirement of the role? Studies have shown that some people are less likely to apply for jobs unless they meet every single qualification. At Galliford Try, we are committed to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every requirement of the role, we encourage you to apply anyway. You may be just the right candidate for this or other roles.

As a Disability Confident employer, we have committed to offer an interview to any candidate with a long-term health condition or disability that meet the essential criteria for the advertised position. Please contact the Resourcing Partner listed within the job advert if you believe this applies to you. We will also take the opportunity to discuss any adjustments required for your interview.

A full job description for this role is available upon request.

#LI-SB1