Azure Data Engineer: Modernize Enterprise Data Warehouse

Teachers Mutual Bank; Sydney; On-site; AUD 140,000 - 190,000; Full time

Job summary

Teachers Mutual Bank Limited is modernising its data environment and migrating its enterprise data warehouse from legacy SQL Server to Azure SQL Managed Instance. As a Data Engineer, you will design, build and maintain SQL, ETL/ELT and orchestration components to support regulatory, operational and analytical reporting.

You will apply DataOps practices, implement data governance, lineage and quality controls, and collaborate across governance, architecture, technology, risk and reporting teams.

Qualifications

• At least five years’ experience in data engineering, business intelligence, data warehousing or analytics delivery.
• Advanced SQL Server development capability, including stored procedures, views, functions, performance tuning and data modelling.
• Experience designing, testing, scheduling, reconciling and supporting ETL/ELT pipelines for material data flows.
• Strong knowledge of relational and dimensional modelling, data quality controls and reconciliation.
• Practical experience working within incident, problem and change management processes.
• A tertiary qualification in Computer Science, Information Technology, Data Engineering, or equivalent practical experience.
• The ability to communicate clearly and work effectively with technical specialists, business stakeholders, testers and control partners.

Responsibilities

• Design, build, test and maintain SQL, ETL/ELT and orchestration components across the enterprise data environment.
• Deliver migration outcomes including source-to-target mapping, migration scripts, reconciliation, variance investigation, testing support, cutover readiness and transition to business-as-usual support.
• Develop relational, dimensional and lakehouse-ready models and curated datasets for operational, regulatory, board, management and analytical reporting.
• Build reusable ingestion, transformation, validation, logging, alerting and reconciliation patterns that improve reliability and supportability.
• Apply disciplined Data Ops practices, including source control, peer review, testing, deployment controls, rollback planning and production validation.
• Embed metadata, lineage, data quality, ownership and control evidence into delivery, while maintaining clear designs, runbooks and support documentation.

Skills

SQL Server

ETL/ELT

Data modelling

Data quality

Incident management

Communication

Education

Tertiary degree

Tools

Azure SQL Managed Instance

Azure Data Factory

SSIS

Power BI Paginated Reports

Databricks

Purview

Alation

GitHub

CI/CD automation

Job description

Teachers Mutual Bank Limited is modernising its data environment and migrating its enterprise data warehouse from legacy SQL Server to Azure SQL Managed Instance. As a Data Engineer, you will design, build and maintain SQL, ETL/ELT and orchestration components to support regulatory, operational and analytical reporting.

You will apply DataOps practices, implement data governance, lineage and quality controls, and collaborate across governance, architecture, technology, risk and reporting teams.