Data And Analytics Architect

• A workplace of positive people and ideas.
• A brilliant city. An exciting lifestyle.
• Full time, permanent role | $137,650 - $143,108 + 11% super

About the Opportunity

As part of the Information Management team, the Data and Analytics Architect’s primary purpose is maintaining and building cutting edge solutions leveraging the full breadth of the Data Analytics capabilities of Council Data Analysis Platform (DAP) which is built on Microsoft Azure Cloud.

About You

To be successful in this role you will have:

• A current Microsoft Azure Data Engineer Associate Certification.
• Experience in Azure SQL Database /Azure SQL Managed Instance/ Azure SQL Elastic Pool/ /Databricks Lake house implementation and administration.
• Proficient knowledge and experience in Azure Synapse (Dedicated Pool, Serverless Pool and Spark Pool) installation and end to end configuration.
• Experience and knowledge Azure Data Lake Store Gen 2 Design and Implementation.
• Experience and knowledge Data Factory to develop automated data pipelines used in data warehouse and data flows.
• Proficient knowledge in Microsoft Purview and data governance frameworks.
• Comprehensive knowledge and understanding of the following:
  • Microsoft Data Platform Landing Zones
  • Data lineage, integrity, and validation
  • Data quality & Master Data Management
  • Data modelling (relational & non-relational)
  • Design and develop database stored procedures, functions, views and queries using various SQL standards (e.g. T-SQL, PL/SQL, etc.)
  • Good knowledge of implementing the IAC with CICD (Azure DevOps / Github)

About Us

Located in the geographic heart of Kaurna Country, the City of Adelaide celebrates its cultural heritage, unique natural surrounds and structures its footprint in a way that allows it to adapt to the changing needs of the community and a dynamic global landscape. Our focus is on our community’s wellbeing and quality of life - investing in city improvements and on future planning, so we continue to design a liveable city where future generations can continue to live authentic and meaningful lives. This is an exciting opportunity to join our team and be a bigger part of our amazing city!

To find out what our people love about what they do please watch this video.

The Information Management Program delivers integrated technology solutions that improve access to information, streamline processes, and encourage collaboration across the organisation, to enable the delivery of customer focused services to our community.

At the City of Adelaide, we thrive in an environment that is welcoming, inclusive and safe, and celebrates difference.  We value and embrace our diverse perspectives and recognise the value diversity has in fuelling innovation and enabling brilliant experiences for our diverse community.

For Further Enquiries & How to Apply

All enquiries regarding this position will remain private and confidential and can be directed to Sonjoy Ghosh on 08 8203 7***.

Please submit a Resume and a Cover Letter expressing the skills, experience and qualities you can bring to this position addressed to Sonjoy Ghosh, Manager, Information Management. 

Please review the position description prior to submitting an application by following the prompts to apply.

For more information about what it’s like to work for the City of Adelaide, including the benefits, please visit www.cityofadelaide.com.au/careers

Applications close at 11.59pm, 14 March 2024.

Please be advised this is a full-time, permanent opportunity with a starting salary at the Level 9 Classification between $137,650 and $143,108 + 11% superannuation.

As part of the recruitment process candidates will be required to undertake a National Police Check.

We encourage Aboriginal and Torres Strait Islander People, and people living with disability to apply.

We are committed to making reasonable adjustments to provide a positive, barrier-free recruitment process and supportive workplace. If you require assistance with our recruitment process, you are more than welcome to connect with our People Services team on (08) 8203 73***or ***********@cityofadelaide.com.au. Please note, applications received via this email will not be considered.