Data Analyst

Ochre Education Resource Library Ltd; North Sydney Council; Remote; AUD 90,000 - 130,000; Full time

Benefits offered by this job

Flexible working hours

100% from flexible location

Mission-driven not-for-profit

Job summary

Ochre Education Resource Library Ltd – North Sydney NSW is hiring a Data Analyst to support organisation-wide technology vision and ensure scalable, secure, user-centered data platforms aligned with the mission.

You will design and maintain data pipelines, ingest from multiple sources, and implement robust ELT/ETL workflows while enabling self-service analytics for internal stakeholders.

Qualifications

• Strong experience with SQL (complex queries, performance tuning).
• Proficiency in Python, Scala, or similar data-focused languages.
• Hands‑on experience with data orchestration tools (Airflow, Prefect, etc.).
• Experience with cloud platforms (AWS, GCP, or Azure).
• Familiarity with data warehouses and/or lakehouse architectures.
• Understanding of data modeling concepts and analytics use cases.
• Experience operating production systems.
• Strong debugging and root‑cause analysis skills.
• Bias toward automation and long‑term maintainability.
• Valid Working with Children Check (or equivalent) and satisfactory criminal record check required.

Responsibilities

• Design, build, and maintain scalable data pipelines (batch and/or streaming).
• Ingest data from multiple sources (application databases, APIs, third-party tools, files).
• Implement robust ELT/ETL workflows with clear contracts and schema management.
• Design and maintain analytical data models.
• Manage data warehouses/lakes (e.g. Snowflake, BigQuery, Redshift, Databricks).
• Implement data quality checks, validation rules, and anomaly detection.
• Enable self-service analytics through datasets and tooling.
• Treat data pipelines as production software using version control, CI/CD, and Infrastructure-as-Code.
• Write maintainable, tested, and observable code.

Skills

SQL (complex queries)

Python

Scala

Data modeling concepts

Analytics use cases

Production systems operations

Debugging / root-cause analysis

Automation / maintainability

Education

Bachelor's degree in Computer Science or related field

Tools

Airflow

Prefect

Snowflake

BigQuery

Redshift

Databricks

AWS

GCP

Azure

Job description

Ochre Education Resource Library Ltd – North Sydney NSW

The Data Analyst is a position responsible for supporting Ochre Education's organisation-wide technology vision. As Ochre continues to expand its impact, this role will contribute to ensuring our digital platforms, data foundations, and technology systems are scalable, secure, user-centred, and aligned to our mission.

Key responsibilities

• Design, build, and maintain scalable data pipelines (batch and/or streaming)
• Ingest data from multiple sources (application databases, APIs, third-party tools, files)
• Implement robust ELT/ETL workflows with clear contracts and schema management
• Design and maintain analytical data models
• Manage data warehouses/lakes (e.g. Snowflake, BigQuery, Redshift, Databricks)
• Implement data quality checks, validation rules, and anomaly detection
• Enable self-service analytics through datasets and tooling
• Treat data pipelines as production software using version control, CI/CD, and Infrastructure-as-Code
• Write maintainable, tested, and observable code

About you

• Strong experience with SQL (complex queries, performance tuning)
• Proficiency in Python, Scala, or similar data-focused languages
• Hands‑on experience with data orchestration tools (Airflow, Prefect, etc.)
• Experience with cloud platforms (AWS, GCP, or Azure)
• Familiarity with data warehouses and/or lakehouse architectures
• Understanding of data modeling concepts and analytics use cases
• Experience operating production systems
• Strong debugging and root‑cause analysis skills
• Bias toward automation and long‑term maintainability
• Valid Working with Children Check (or equivalent) and satisfactory criminal record check required

About us

Ochre Education is an innovative national Australian not-for-profit organisation committed to improving educational outcomes by supporting teachers with high-quality, evidence-informed resources and professional learning. Over the last 4 years we have worked with over five hundred Australian expert practicing teachers to create 7,000 lessons and 28,000+ resources in 4 subjects and made them freely available on our national platform. Our resources are accessed by 90% of Australian schools. Our work spans curriculum development, teacher training, and education system-wide capacity building across Australia.

• Be part of a mission-driven not-for-profit organisation, taking direct action towards educational equity
• Significant opportunities for growth and development
• Work closely alongside talented, passionate and fun colleagues
• Flexible working hours, and ability to work 100% from a flexible location