Data Engineer

Role Overview

TRI is seeking a Data Engineer to join the Data Innovations team and help build data capabilities from the ground up. You will shape how the organisation moves, stores, and transforms data, designing pipelines and scalable data infrastructure while partnering with Data Scientists to deliver analysis-ready datasets.

Responsibilities

• Design, build, and maintain ETL pipelines to extract, transform, and load data from diverse sources into warehouses, lakes, and lakehouses.
• Build scalable, high-performance data infrastructure using tools such as Databricks, Snowflake, and Azure Data Factory.
• Architect data warehouses and lakehouses to support structured and unstructured analytics, reporting, and modelling.
• Work with Development and Operations teams to define data model views that enable complex Power BI reports.
• Collaborate with Data Scientists to deliver pipelines, aggregations, and datasets ready for modelling and analysis.
• Optimise storage performance, manage data quality, and ensure data integrity across environments.
• Translate business and data requirements into practical engineering solutions for data-driven decision-making.

Requirements

• Hands-on experience with Azure Data Engineering services, including Azure Data Factory, Databricks, and Snowflake.
• Strong programming skills in T-SQL, Python, or R.
• Deep knowledge of relational databases, especially Azure PostgreSQL and MS SQL Server, including design, query optimisation, and performance tuning.
• Familiarity with enterprise architecture frameworks such as TOGAF and Zachman.
• Understanding of data governance principles (as per DAMA DMBOK), including data quality, data lineage, and compliance.

Nice to Have

• Experience supporting analytics/reporting workflows (e.g., Power BI) and model/view design for BI consumption.