Hybrid Data Analyst: Databricks & SQL for Govt Data

Canberra Consulting; Canberra; Hybrid; AUD 131,000 - 152,000; Full time

Job summary

Canberra Consulting is seeking a Data Analyst to join a Federal Government team in Canberra on a hybrid basis. The role focuses on school data production, reporting and analytics, leveraging Databricks, PySpark and SQL to deliver reliable insights and repeatable reporting processes.

You will collaborate with business and technical stakeholders to translate requirements into analytical outputs, profile data quality, and contribute to a Databricks-based analytics platform transition.

Qualifications

• Advanced SQL capability with experience on complex datasets.
• Experience analysing government or similar datasets.
• Working knowledge of Databricks, PySpark and/or Spark SQL.
• Data profiling, reconciliation, validation and quality assurance.
• Ability to translate business requirements into data specifications and outputs.
• Strong stakeholder engagement, documentation and written communication.

Responsibilities

• Analyse and reconcile complex administrative and reporting datasets.
• Translate business and reporting requirements into data specifications and analytical outputs.
• Develop SQL and PySpark transformations, validation rules and repeatable reports.
• Undertake data profiling, reconciliation, quality assurance and anomaly investigation.
• Develop documented business rules and fit-for-purpose analytical datasets.
• Support annual reporting, BAU activities and ad hoc data requests.
• Prepare technical and analytical documentation.
• Support stakeholder engagement, knowledge transfer and ongoing team capability.

Skills

Advanced SQL

Databricks

PySpark

Spark SQL

Data profiling

Data reconciliation

Stakeholder engagement

Tools

Databricks

PySpark

Spark SQL

Job description

Canberra Consulting is seeking a Data Analyst to join a Federal Government team in Canberra on a hybrid basis. The role focuses on school data production, reporting and analytics, leveraging Databricks, PySpark and SQL to deliver reliable insights and repeatable reporting processes.

You will collaborate with business and technical stakeholders to translate requirements into analytical outputs, profile data quality, and contribute to a Databricks-based analytics platform transition.