Data Modeller

Heritage and People's Choice; City of Brisbane; Hybrid; AUD 90,000 - 120,000; Full time

Job summary

A leading mutual banking organization in Australia is seeking a highly skilled Data Modeller / SQL Developer to design data models for their new enterprise data warehouse. The role involves collaborating with stakeholders to analyze data requirements and delivering comprehensive data mapping documentation. Candidates should have proven experience in data modelling and a deep understanding of data warehousing concepts. The organization offers a supportive environment with benefits including flexible work arrangements and career development opportunities.

Benefits

Paid parental leave

Flexibility and hybrid working arrangements

Employee banking benefits

Career development opportunities

Employee Assistance Program

Paid volunteering days

Qualifications

• Proven experience in designing dimensional and relational data models.
• Experience in delivering models in a green field environment.
• Capable of using 3NF and Dimensional modelling methods.

Responsibilities

• Design data model for the new enterprise data warehouse.
• Collaborate with stakeholders to gather and analyze data requirements.
• Assist in the design and development of data models.

Skills

Data modelling

SQL

Data governance

Collaboration

Communication

Education

Experience in enterprise data modelling

Tools

Erwin

Azure Databricks

DBT

Job description

About the role

We have a new opportunity for a highly skilled Data Modeller / SQL developer to play a support role in designing the data model on our new enterprise data warehouse using Azure Databricks and DBT.

This role is offered as 1-year fixed term contract with possible extension or permanency.

Key Responsibilities

Reporting to Data Domain Leader, you will play a pivotal role in designing data model for the new enterprise data warehouse.

• Collaborate with business stakeholders, business analysts, and subject matter experts to gather and analyse data requirements and business rules.
• Work closely with engineers on the implementations of target databases.
• Work closely with modelling lead on governing the modelling standards and ensuring process is followed.
• Creation of data mapping documentations,metadata and other related artefacts. Ensure data models align with business objectives and strategies, using best practices and industry standards for data modelling.
• Translate high-level business requirements into detailed data models and technical specifications.
• Assist the design and development of conceptual, logical, and physical data models to support various projects and business-as-usual (BAU) requirements.

Qualifications

• Proven experience in designing dimensional and relational data models.
• Proven experience in working in a green field environment.
• Proven experience in delivering models.
• Creating and maintaining dimensional and relational data models in Erwin or similar tools.
• Develop and maintain comprehensive documentation for data models, data dictionaries, metadata, and related artifacts.
• Champion data governance, risk, and compliance (GRC) controls to ensure data quality, integrity, and security.
• Extensive demonstrated experience of enterprise data modelling, including banking industry data models.
• Capable of using 3NF and Dimensional modelling methods.
• In depth knowledge of designing and implementing enterprise data model using dimensional modelling approach in at least 2-3 enterprise data transformation projects.
• Deep understanding of data warehousing concepts and methodologies.
• Proven experience with translating business requirements into appropriate data model to support BI applications that yield actionable results.
• Proficiency in SQL and Data modelling tool like Erwin, ER / Studio or similar.
• Knowledge of industry best practice in data governance, security, and compliance standards.

About you

You are creative in development of accurate, consistent and high-performance data models that effectively support business requirements and strategic objectives. You work collaboratively as part of a team and can communicate complex data concepts to non-technical stakeholders.

Who are we?

It's an exciting time to join our organisation! On 1 March 2023, two of Australia's most successful member-owned banking organisations merged to form People First Bank – powered by Heritage and People's Choice. We are Australia's leading mutual banking organisation and a genuine, member-owned alternative to the major banks.

We exist to create a better future for our members and the communities in which they live.

We are 100% member owned, with approximately 720,000 members and 1,900 employees. We have dual head offices in Adelaide and Toowoomba, and 95 branches across South Australia, Victoria, New South Wales, Queensland and the Northern Territory, trading under two brands, Heritage Bank and People's Choice.

When you come to work with us, you'll be joining a team of inclusive, friendly, and motivated employees who value making a difference every day for our members, community, and the planet. We are committed to creating an outstanding working environment where you feel supported, can continue to develop and are proud advocates of our members and our business.

Benefits of working for us

We believe the little extras can make a big difference in supporting your success. That's why we offer great incentives and benefits including:

• Paid parental leave and special leave provisions
• Flexibility and hybrid working arrangements
• Employee banking benefits and discounted insurances
• Career development opportunities, and ongoing training, coaching and support
• A dedicated Employee Assistance Program for you and your family to access in times of need
• Paid volunteering days and access to a diverse range of community and charitable initiatives

If you are ready to join a supportive team who are passionate about the work they do and the results they achieve, then apply now.

If this sounds like you, then this is the next step in your career. Click 'Apply' now and submit your application, including a cover letter and current resume by 5th January 2026.

We are committed to diversity and inclusion and support candidate requests for adjustments to enable everyone to equitably participate in our selection process.