Data Engineer

The Data Engineer role is part of the Data, Analytics and Development team within the IT function at Galliford Try. The role forms part of the "hub" within the hub and spoke model adopted to support the effective and efficient use of data across Galliford Try.

The accountabilities for the role work across the data lifecycle from the point of connecting to data at source, through the ETL process, management of data warehouses and lakehouses and analytics.

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.,

• 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 raw data into a format and structure suitable for reporting and analytics.


• Analytics: Using algorithms/models and analytics techniques to enhance or add value to data. This could relate to supervised/unsupervised machine learning and have applications across predictive analytics, text analytics, image analytics and other areas.


• 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., With an impressive order book of over £3.2 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.


• Ability to capture structured business requirements in a structured user story format.


• 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.


• Good understanding of base structures and the capability of languages such as T-SQL, Oracle SQL, SparkSQL, DAX, M Language, and Python.


• Strong experience with the Microsoft stack whether via Azure data services (Azure Synapse, Azure Data Warehouse, Azure Data Factory etc.) or via on-prem SQL Server solutions.


• 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 working with Microsoft Fabric.


• Experience of using Git to manage version control.


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


You will also be able to demonstrate the following key attributes.

• Desire to understand and promote the Company purpose, vision, values and culture


• Organised, structured and professional, with a passion for excellence, striving to delivering the best.


• Flexibility, resilience and the ability to influence and build relationships with key stakeholders. Demonstrating strong ethical standards with openness and honest.


• Commitment to the provision of excellent customer service, passionate, committed and enthusiastic in all that you do.


• A self-starter with a can-do attitude and a desire to pick up new challenges. Dedicated to working together to achieve results.
  
  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.

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