Lead Data Modeller

Location Sydney CBD
Discipline BI, Data & Analytics
Job reference 179084
Salary Negotiable
Consultant email [email protected]

Responsibilities of the role include but are not limited to:

  • Set peer review and data modelling release standards.
  • Provide knowledge transfer sessions on best practices on development, data modelling, release process etc.
  • Own the technical implementation of new data from analysis to delivery (designing and delivering data dictionary, defining the release steps, defining best practices of data modelling and review steps).
  • Facilitate continuous improvement measures in delivery principles, coding standards, documentation and provide training sessions to team.
  • Prioritise work items and add them to a work queue.
  • Understand, analyse and size user requirements;
  • Development and maintenance of SQL analytical and ETL code;
  • Development and maintenance of system documentation;
  • Collaboration with data consumers, database development, testers and IT support teams;


Skills and experience:

1. Strong demonstrated experience data modelling using metadata/model driven frameworks
2. MS SQL / Teradata /Snowflake / Redshift / Databricks - Demonstrated competency in developing, auditing and reviewing code in 2 out of the 5 Data Warehouses listed
3. Ability to understand DevOps process and can use DevOps tools in accordance with the process
4. High level of competency in Programming, including knowledge of supplementary programming languages such as Python, SAS, R or Java
5. Ability to demonstrate knowledge of version controls and its appropriate uses
6. Strong expertise with SQL, including experience with reverse-engineering end user SQL code



Skills and experience that would be nice to have:

1. Minimum of 4 years in a similar role, with exposure to AWS Cloud, AWS S3, AWS Glue or similar tools within the cloud environment
2. Competency with required systems, software and programs, including SAS and Excel
3. Ability to read and interpret data models and specifications, experience working in an agile environment
4. Ability to read and interpret data models and specifications, experience working in an agile environment