Senior Data Engineer
Summary
Design and build scalable ETL/ELT pipelines in Azure Data Factory, optimize T-SQL queries, and collaborate with teams to deliver analytics-ready datasets for government projects.
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:
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 Great and 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 great 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
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 Great and 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 great 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