Data Engineer Government client (must be a citizen) Full-Time, Permanent Hybrid work arrangement 3 days onsite Location: Lucas Heights About the Role The role involves working with Azure technologies such as Synapse, Data Factory, Databricks, and Cosmos DB, developing ETL/ELT workflows, and managing data warehouses and data lakes. Candidates should have strong experience in SQL, query optimisation, and data warehouse modelling (OLTP/OLAP, SCDs). This is a great opportunity to work on high-impact projects, leverage modern cloud technologies, and advance your career in a dynamic and collaborative environment. Key Responsibilities Design, develop, and optimise ETL/ELT workflows for seamless data integration. Build and maintain data warehouses and data lakes (SQL, Data Lake Storage, Spark, Cosmos DB). Implement data warehouse modelling techniques, including OLTP/OLAP structures and Slowly Changing Dimensions (SCDs). Work with Azure data services such as Synapse, Data Factory, Databricks, and Cosmos DB to develop scalable data solutions. Write and optimize complex SQL queries to improve performance and efficiency. Collaborate with cross-functional teams to ensure data accuracy, governance, and security. Skills & Experience Degree in Computer Science or equivalent experience/certifications in Azure Data Engineering. Proficiency in Azure technologies, including Synapse, Data Factory, and Databricks, or equivalent cloud platforms. Strong SQL skills with a focus on query optimisation and performance tuning. Strong hands-on experience with Integration/ETL tools, preferably within the Azure environment. Proven experience working with data lakes, SQL-based storage, and Spark-based processing. If you wish to apply for this position, please submit your resume by clicking the 'Apply Now' button. For further information please contact Theo Panaligan at Clicks IT Recruitment on 02 9200 4451. At Clicks we embrace diversity, inclusion and equal opportunity. We provide reasonable adjustments, including alternate formats to the recruitment process for individuals with disability. If you require an adjustment to be made during the recruitment process, please call 1300 254 257 or email [email protected] Apply Now Job Summary Pay: $115000 per annum Location: Sydney - South Job Type: Permanent Specialisation: Database Design & Development Reference ID: BBBH76140 Jobseeker FAQs FAQ 1 Optional. Specifies the mode. Possible values: 0 – Default. Does not count all elements of multidimensional arrays 1 – Counts the array recursively (counts all the elements of multidimensional arrays) Optional. Specifies the mode. Possible values: Optional. Specifies the mode. Possible values: 0 – Default. Does not count all elements of multidimensional arrays 1 – Counts the array recursively (counts all the elements of multidimensional arrays)