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.

company/*******/
Why Araza?
We are EXCELLENT.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 ofBe GreatandBe 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
**** CRN Impact Award – Emerging Innovation Winner
**** Financial Review Fast 100
**** Financial Times High-Growth Companies Asia-Pacific
**** Deloitte Technology Fast50 Australia
**** Deloitte Technology Fast500 APAC
**** CRN Fast50
**** ARN Homegrown Service Provider Winner
**** EY Winning Women Program Winner
**** Cisco Diversity Initiative Award Winner
**** Cisco Rising Star Winner
******* Under 30 Tech Awards Winner
**** CRN Fast50
**** Deloitte Technology Fast50 Australia
**** Deloitte Technology Fast500 APAC
**** CRN Fast50
**** ARN Start Up Entrepreneur Winner
**** ARN Personal Innovation Sales Excellence Winner
**** Westpac Business of Tomorrow Winner
**** Financial Times ****: High-Growth Companies Asia-Pacific
**** Deloitte Technology Fast50 Australia
**** Deloitte Technology Fast**** Asia/Pacific
**** CRN Fast50
**** ARN WIICTA Entrepreneur of the Year Winner
**** Westpac Business of Tomorrow Winner
**** Optus myBusiness Business Leader of the Year Winner
**** Deloitte Rising Star
**** CRN Fast50
#J-*****-Ljbffr

📌 Senior Data Engineer (Canberra)
🏢 Araza
📍 Canberra