SQL Data Engineer: ETL, Azure & Data Modeling Pro

Tata Consultancy Services; City of Brisbane; On-site; AUD 150,000 - 190,000; Full time

Job summary

Tata Consultancy Services (TCS) Australia welcomes you to join our teams delivering data-driven solutions for Australian enterprises. This role focuses on designing and optimising SQL Server environments, building robust data models, ETL pipelines, and integrating APIs to ensure reliable data movement.

You will collaborate with cross-functional stakeholders, apply modern data engineering practices, and leverage Azure and Microsoft Fabric for scalable analytics, while aligning with our

Qualifications

• Design, develop and optimize SQL Server solutions, including complex Stored Procedures, Functions, Views and high-performance SQL queries.
• Build and maintain robust data models and ETL solutions using SSIS, Transactional Replication and Azure Pipelines.
• Manage SQL Agent Jobs, monitor database health, troubleshoot data and performance issues, and perform database performance tuning.
• Develop and support data ingestion and API integration solutions while ensuring reliable movement and availability of data across systems.
• Contribute to modern data engineering solutions using Microsoft Fabric, Azure Databricks, Python and Spark, while collaborating effectively with stakeholders and delivery teams.

Responsibilities

• Design, develop and optimise SQL Server solutions, including complex Stored Procedures, Functions, Views and high-performance SQL queries.
• Build and maintain robust data models and ETL solutions using SSIS, Transactional Replication and Azure Pipelines.
• Manage SQL Agent Jobs, monitor database health, troubleshoot data and performance issues, and perform database performance tuning.
• Develop and support data ingestion and API integration solutions while ensuring reliable movement and availability of data across systems.
• Contribute to modern data engineering solutions using Microsoft Fabric, Azure Databricks, Python and Spark, while collaborating effectively with stakeholders and delivery teams.

Skills

SQL Server development

Data modelling

ETL processes

Transactional Replication

SSIS

Azure Pipelines

Stored Procedures/Functions/Views

SQL Agent Jobs & performance tuning

Analytical skills & stakeholder mgmt

Onsite collaboration

Tools

Microsoft Fabric

Azure Databricks

Python

Spark

APIs & data ingestion tooling

Job description

Tata Consultancy Services (TCS) Australia welcomes you to join our teams delivering data-driven solutions for Australian enterprises. This role focuses on designing and optimising SQL Server environments, building robust data models, ETL pipelines, and integrating APIs to ensure reliable data movement.

You will collaborate with cross-functional stakeholders, apply modern data engineering practices, and leverage Azure and Microsoft Fabric for scalable analytics, while aligning with our