Data Engineer - #1771379

The Vacancy

WGM Engineering have an excellent opportunity for a data Engineer to join our Digital Services team on a full-time permanent basis, the role will be based in our Glasgow offices on a hybrid working basis. In partnership with other RSK Group companies WGM Engineering is now contracted on frameworks with water companies in both Scotland and England with a strong order book and pipeline of work. The business has significant growth planned over the next 5-years and during this period of growth and geographic expansion, WGM is seeking to transform its business operation, improve continuously and simultaneously, with a view to improve customer satisfaction, safety, quality and business performance. This transformation is underpinned by the development of a One Team culture and a digital transformation program.

Duties & Responsibilities:

• Design, develop, and manage/maintain robust end-to-end data pipelines and dataflows within MS Fabric, and integrated with other related business systems, to support project controls and reporting use cases.
• Implement integration of external data sources, including: Primavera P6 EPPM via REST and SOAP APIs.
• EMiR (WGM cost repository) through structured ETL/ELT processes and ODBC direct connection.
• Design and manage integrations with Microsoft Dataverse, PowerApps, SharePoint, and other systems as required.
• Establish and optimise Lakehouse and Data Warehouse structures to support reporting data requirements.
• Collaborate with business users to ensure data models and DAX measures support actionable insights.
• Ensure data quality, reliability, and performance through robust engineering standards and automated testing.
• Support development of dashboards in Power BI, to meet business requirements.
• Performance optimisation of Power BI datasets, semantic models, and visualisations.
• Ensure all data handling, storage, and transmission complies with relevant security and privacy standards (e.g. ISO 27001, UK GDPR, and company policies).
• Implement role-based access controls (RBAC) and data masking to restrict access to sensitive project, financial, and personnel data.
  
  
  

To be considered for this position you will have proven experience as a Data Engineer or equivalent role with demonstrable end-to-end platform, previous hands-on expertise with Microsoft Fabric and/or Azure Data Factory, SQL Server, and Power BI is essential for the role. The ideal candidate will have experience integrating data from enterprise platforms via REST and SOAP APIs and have a strong understanding of relational data modelling, warehousing, and data pipelines.

Benefits

We offer a competitive package, including:

• 32 days holiday, increasing to 36 based on length of service.
• Enhanced pension scheme.
• Life assurance scheme.
• Salary sacrifice – (Electric vehicle scheme, annual leave purchase & cycle to work).
• Remote & hybrid working options (subject to role requirements).
• Enhanced maternity & paternity Leave.
• Company sick pay (available after qualifying period).
• Employee discount programme.
  
  
  

About Us

Based in Scotland, we are an engineering business providing mechanical, electrical and civil engineering services to clients across the UK. We are one of the UK’s leading engineering solution providers, recognised for outstanding client service, quality solutions and our commitment to health and safety. From our HQ in Glasgow, we deliver sustainable solutions to the water and renewables sectors. Supplementary services include project management, technical engineering, design, and off-site modular build. 

We have partnered with innovative technology providers in the renewables sector, including solar PV, hydroelectric and heat networks. We are a progressive, people-orientated business driven by our values to deliver workable and cost-effective solutions in the communities we work. When you work for WGM you join a dynamic team and have the opportunity to be part of our ambitious plans for future growth.

WGM is part of the RSK Group, a leading integrated environmental, engineering, and technical services business providing dynamic, multidisciplinary services to a wide range of sectors. RSK was founded in 1989 and has grown considerably since then.

At RSK, we operate as a group of businesses that work together seamlessly, aiming for growth through diversification. Our strategy helps us build a strong and resilient business, capable of weathering external challenges, while also providing greater value to our clients and more opportunities for our employees.

Since the beginning, our philosophy has remained the same: employ, develop and reward talented individuals. People are crucial to our company, and we recognise that our success hinges on our colleagues' growth. We're committed to preserving RSK's people-first culture, promoting innovation, and fostering a supportive and caring environment for collaboration. At RSK, we want you to be part of our successes and help you reach your career aspirations. We take pride in offering employees fulfilling and challenging careers by promoting ongoing growth and empowering individuals to excel.

We are committed to fostering an inclusive workplace that welcomes individuals from all backgrounds, experiences, and perspectives. We firmly believe that embracing and celebrating the diversity in our workforce makes us a stronger and more innovative company.

By providing workplace adjustments, we make it easier for people to confidently explore and pursue our career opportunities and recognise that flexibility is key to fostering a dynamic and thriving workplace. Many of our office-based positions benefit from a flexible working arrangement, allowing our team members to achieve a balance between professional and personal commitments.

We actively encourage applications from candidates of all genders, races, ethnicities, ages, neurotypes, religions or beliefs, sexual orientations, and those with disabilities.

If you're passionate about making a difference, join us as we work together to build a brighter, more equitable, and sustainable future for all. Do you have what it takes?