Senior Data Engineer

• Design, build and maintain scalable ETL and ELT pipelines within Microsoft Fabric, ensuring data is ingested, transformed and made available in a reliable, secure and supportable way.

• Work with the Manager: Digital and Data Engineering to support the delivery of the data engineering roadmap, ensuring activity is aligned to Technology priorities and business value.

• Translate business reporting and analytics requirements into clear technical designs, data models and engineering deliverables that are scalable and reusable.

• Develop and maintain data pipelines, lakehouse structures, notebooks, dataflows, semantic models and related Fabric components in line with agreed standards.

• Ensure data engineering activity supports trusted Power BI reporting by improving data quality, consistency, availability, performance and traceability.

• Work closely with business stakeholders, data owners and analysts to understand data definitions, reporting logic and operational processes behind business requirements.

• Partner with Enterprise Platforms, Architecture, Information Security and Infrastructure teams to ensure data solutions align to CWG’s platform architecture, security standards and operating model.

• Apply appropriate governance, testing, version control, documentation and release controls across data engineering deliverables.

• Identify and manage risks relating to data quality, data privacy, reporting accuracy, pipeline resilience, access control and operational supportability, escalating where appropriate.

• Support the integration of data from key business platforms, SaaS applications, databases and external sources into CWG’s enterprise data environment.

• Work with suppliers and implementation partners where required, ensuring technical outputs are reviewed, challenged, documented and aligned to CWG standards.

• Contribute to engineering best practice, reusable patterns, technical standards and continuous improvement across the Digital and Data Engineering team.

• Provide technical guidance and knowledge sharing to colleagues, helping build internal capability and reducing reliance on external support over time.

• Strong hands-on experience as a Data Engineer, with a proven track record of designing, building and supporting data pipelines in a business-critical environment.

• Practical experience with Microsoft Fabric, including lakehouses, warehouses, data pipelines, notebooks, dataflows, OneLake and integration with Power BI.

• Strong SQL skills and experience working with structured and semi-structured data from databases, APIs, SaaS platforms and file-based sources.

• Good understanding of ETL and ELT design patterns, data modelling, orchestration, scheduling, monitoring and performance optimisation.

• Experience supporting Power BI reporting through well-designed data models, semantic layers and trusted curated datasets.

• Good understanding of data governance, data quality, lineage, metadata, access control, data privacy and information security principles.

• Experience working in Microsoft Azure data environments, with an appreciation of cloud architecture, identity, security, networking and operational support considerations.

• Ability to engage with business stakeholders, understand operational requirements and explain technical concepts clearly to non-technical audiences.

• Structured and analytical approach to problem solving, with strong attention to detail and a focus on practical, supportable and scalable solutions.

• Experience working with third-party suppliers or delivery partners, including reviewing technical outputs and ensuring standards are met.

• Outcome-led and business-aligned mindset, with the ability to connect engineering work to better decisions, improved efficiency, reduced risk and measurable business value.

• Collaborative, proactive and improvement-focused, with a commitment to high standards, continuous learning and helping CWG build a sustainable internal data capability.

All staff are required to fulfil their legal duty to take reasonable care for the health and safety of themselves and others who may be affected by their acts and omissions, and to follow all guidance and instructions given in this respect. Further details regarding Health & Safety responsibilities are set out in the Health & Safety Policy in the Administrative Rules and Procedures, and the Health, Safety & Welfare Manual.

Recognising the centrality of ESG principles within our organisation, we have developed a comprehensive ESG Strategy. It is imperative that all staff members understand and adopt this strategy into their respective roles. This includes adhering to environmental regulations, minimising waste, supporting nature within our urban environment, and facilitating positive change for those in need within our community and utilising our volunteering.

In line with the latest ISO 9001 requirements and our dedication to quality management, all staff are mandated to comply with system requirements as detailed within the Company Quality Manual & Policies. Additionally, it's vital to ensure the effective implementation of all Procedures, Plans, and Forms within our Electronic Document Management Systems (EDMS) to meet the ISO 9001: Quality Management Standard.