Senior Data Engineer

Location: Canberra

Contract Length: 10 months + 12 month extension

Responsibilities: • Design and build ETL/ELT pipelines in Azure Data Factory and create/manage linked services, datasets, and integration runtimes

- Write and optimize complex T-SQL (stored procedures, functions, views) and performance tuning, query optimization, execution plans, indexing strategy
- Work across Azure services: Data Lake Storage (ADLS Gen2), Blob Storage, Azure SQL, Synapse, Key Vault, Azure Functions, Logic Apps
- Monitor pipeline runs, set up alerts (Azure Monitor, Log Analytics) and troubleshoot failures and analyse logs, metrics, and monitoring dashboards to detect anomalies and failures early
- Collaborate with data architects, data modellers, analysts, and business stakeholders to understand data requirements and translate them into technical solutions
- Following the Scaled Agile Framework (SAFe) methodology for software development and contributing to Agile ceremonies

Requirements:

- Demonstrated experience designing, developing, and orchestrating scalable ETL/ELT pipelines using Azure Data Factory — including parameterized, metadata-driven pipelines, integration runtimes, incremental loads, and robust error handling to move and transform data from diverse sources
- Advanced ability to write, optimize, and troubleshoot complex T-SQL (stored procedures, functions, views), design dimensional data models (star/snowflake schemas), and perform performance tuning through indexing and query optimization
- Practical experience ingesting and exchanging data via REST/SOAP APIs handling authentication (OAuth2, tokens, managed identities), pagination, rate limiting, and parsing JSON/XML responses into structured, analytics-ready datasets




- Exceptional communication and documentation abilities, with a proven track record of collaborating across technical and business teams
- Solid understanding of the wider Azure ecosystem (ADLS Gen2, Azure SQL, Key Vault, Azure Functions, Synapse) combined with strong analytical and troubleshooting skills to monitor pipelines, diagnose failures, and apply security best practices

About Araza: Our organisation works with Australia’s largest enterprise and government clients providing project and program teams and resources to ensure success. We pride ourselves on being a trusted technology partner and working collaboratively.

We're partnering with a leading Australian department to deliver high-quality projects that drive impactful results, focused on protecting national interests through intelligence, cybersecurity, and strategic operations to combat global threats.

We can talk about Araza all day but instead, here are a few links if you are interested. www.araza.com.au https://www.linkedin.com/company/3613383/

Why Araza?

We are GREAT.Our purpose is to have our teams align with our client’s needs to assist them on their most interesting and innovative projects. We do this by aligning our clients and teams to our core values of Be Greatand Be Grateful. This focus has helped make us an employer of choice and the consultancy of choice in the Australian market.





We are DIVERSE and INCLUSIVE. We are recognised leader in diversity with an excellent representation of women in leadership and a team with differing backgrounds, ethnicities, experiences and abilities.

We care. Araza is a company that cares for their people. It's that simple. You will work with truly talented switched on and collaborative team members that help each other to succeed.

We rock. #HumbleBrag is that a lot of other companies think we are outstanding as well!

Our awards list

2023 CRN Impact Award – Emerging Innovation Winner

2020 Financial Review Fast 100

2020 Financial Times High-Growth Companies Asia-Pacific

2019 Deloitte Technology Fast50 Australia

2019 Deloitte Technology Fast500 APAC

2019 CRN Fast50

2019 ARN Homegrown Service Provider Winner

2019 EY Winning Women Program Winner

2019 Cisco Diversity Initiative Award Winner

2019 Cisco Rising Star Winner

2019 30 Under 30 Tech Awards Winner

2018 CRN Fast50

2018 Deloitte Technology Fast50 Australia

2018 Deloitte Technology Fast500 APAC

2018 CRN Fast50

2018 ARN Start Up Entrepreneur Winner

2018 ARN Personal Innovation Sales Excellence Winner

2018 Westpac Business of Tomorrow Winner

2018 Financial Times 1000: High-Growth Companies Asia-Pacific

2017 Deloitte Technology Fast50 Australia

2017 Deloitte Technology Fast1000 Asia/Pacific

2017 CRN Fast50

2017 ARN WIICTA Entrepreneur of the Year Winner

2017 Westpac Business of Tomorrow Winner

2017 Optus myBusiness Business Leader of the Year Winner

2016 Deloitte Rising Star

2016 CRN Fast50

Next Steps

If this sounds like the opportunity you are looking for, apply now! Our team would love to hear from you

📌 Senior Data Engineer (Canberra)
🏢 Araza
📍 Canberra