WGM Engineering is one of Scotland’s leading engineering solution providers and performing responsibly is integral to our success and sustainability. We are committed to delivering projects and services whilst ensuring that we meet our customer and society needs, whilst managing the social and environmental impacts of our business. Since trading commenced in 1986, WGM has continued to develop its operations to adhere to the marketplace and client demand. This has been achieved by offering a unique and total service where Mechanical, Electrical and Civil Engineering disciplines are provisioned under the one roof. Aligning our three disciplines and our strategically located service centres offers a total turnkey solution to clients countrywide and ensures we are the number one engineering company of choice.
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.

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