Lead level Data Engineer at Blend360

We are looking for an experienced Senior Data Engineer to support the delivery of a foundational Azure data platform for a large telecommunications client. This role will be central to building and operating the ingestion pipelines, Medallion architecture, and data models that underpin operational reporting across the business. The ideal candidate will have strong hands-on experience in cloud data engineering, pipeline development, data modelling, and working with modern cloud data warehousing platform, whether Databricks or Snowflake. This person will work closely with BI Consultants, DevOps Engineers, and Data Governance leads to ensure that data from priority source systems is reliably ingested, transformed, and delivered as trusted, well-governed datasets that support business decision-making and PIPEDA compliance. Responsibilities • Design, build, and maintain scalable ingestion pipelines from priority source systems into Bronze, Silver, and Gold layers of the Medallion architecture, covering both batch and incremental load patterns. • Complete source-to-target mapping documentation, agree conformed dimensions, taxonomies, and systems of record with the governance workstream, and implement the Gold aggregation layer with KPI metric definitions signed off by business stakeholders. • Model and transform business data across the Medallion layers into structures that support operational Power BI reporting, ensuring Silver and Gold layer tables are optimised for the agreed KPI and reporting requirements. • Apply and maintain governed data access controls in the chosen cloud data platform, including role-based permissions and any column-level or row-level security required to meet PIPEDA compliance obligations as defined by the governance workstream. • Implement robust ingestion, transformation, and data quality processes including automated DQ checks across all Medallion layers, error handling for failed pipeline runs, and end-to-end testing from source systems to the Gold layer. • Drive Silver-to-Gold reconciliation sign-off with business stakeholders, ensuring a single agreed definition for every committed KPI and eliminating cross-department reporting discrepancies. • Complete and maintain the data dictionary for all platform tables, ensuring data is well-documented, accessible, and aligned to business definitions used by BI developers, report authors, and stakeholders during UAT. • Work with architects and client data stakeholders to align designs with enterprise data standards, governance requirements, and long-term maintainability. • Produce data engineering runbooks and handover documentation, including pipeline operational guides and technical documentation structured for the client’s internal team to maintain and extend the platform independently. • Support deployment of data solutions into controlled Dev, Test, and Production environments. • Support continued development of the Medallion architecture in later phases, including additional Bronze, Silver, and Gold datasets, and contribute to pipeline orchestration running reliably on the agreed ingestion schedule.