At a Glance
- Tasks: Lead the design of data models and engage with stakeholders to meet business needs.
- Company: Commonwealth Government organisation supporting Australians with disabilities.
- Benefits: Inclusive workplace, diverse perspectives, and commitment to equal opportunity.
- Other info: Join a dynamic team with a focus on innovation and career growth.
- Why this job: Make a real difference while shaping data solutions for meaningful impact.
- Qualifications: Extensive experience in data modelling and strong analytical skills required.
The predicted salary is between 90000 - 110000 $ per year.
Our client, a Commonwealth Government organisation whose focus is to provide support to Australian's living with disability, require the services of
Lead Data Modeller.
Duties of the Lead Data Modeller
- Lead the design and governance of enterprise semantic models, certified datasets, KPIs, and business metrics.
- Engage with business stakeholders and data architects to understand business requirements and translate them into logical, dimensional and semantic data model.
- Design and develop enterprise grade dimensional models using start schema principles, including fact tables, dimensions, relationships, hierarchies and appropriate data granularity.
- Develop and optimise analytical data models within data warehouse, including presentation layer tables, views and SQL transformations to support semantic model requirements.
- Design, develop and maintain reusable and scalable semantic models in BI tools to support enterprise reporting and analytics.
Skills and Experience
- Extensive experience leading enterprise data modelling activities within large and complex data environments, with a strong understanding of enterprise data modelling principles, naming conventions, metadata management, model documentation and governance standards.
- Proven ability to analyse complex business requirements, identify business entities, relationships, measures, KPIs and dimensions, and translate these into logical, physical and semantic data models.
- Strong hands-on experience designing and developing analytical data models in Snowflake, including presentation layer design, complex SQL transformations, query optimisation, and validation of semantic models against business requirements to ensure accuracy and consistency of business metrics.
- Demonstrated proficiency in data modelling tools and techniques, including ER modelling, dimensional modelling, data normalisation, and the use of ERWIN or equivalent modelling tools.
- Extensive experience architecting and developing scalable semantic data models that support self-service reporting, analytics and business intelligence solutions, including Power BI and similar platforms.
- Job ID
- We Value Diversity
The Recruitment Hive is a proud Equal Opportunity Employer.
We recognise the value of diverse perspectives and experience and are committed to an inclusive workplace where everyone feels valued and respected for who they are.
We encourage people with disability, indigenous, veterans and people of all backgrounds and abilities to express their interest in this role.
Be careful - Don’t provide your bank or credit card details when applying for jobs.
Don't transfer any money or complete suspicious online surveys.
If you see something suspicious, report this job ad .
#J-18808-Ljbffr
Lead Data Modeller employer: The Recruitment Hive Pty Ltd
As a Senior Salesforce Developer with our esteemed Federal Government Organisation, you will be part of a dynamic team that values innovation and collaboration. Enjoy a supportive work culture that prioritises employee growth through continuous learning opportunities and professional development, all while contributing to meaningful projects that impact foreign policy and trade. Located in Canberra, this role offers the unique advantage of working within a diverse and inclusive environment, where your contributions are recognised and valued.
Contact Details:
The Recruitment Hive Pty Ltd Recruitment Team
