At a Glance
- Tasks: Lead enterprise data modelling and governance for impactful Federal Government initiatives.
- Company: Join a major Federal Government environment with a focus on innovation.
- Benefits: Competitive salary, career growth, and the chance to make a nationwide impact.
- Other info: Work in a dynamic environment with opportunities for professional development.
- Why this job: Shape the future of data analytics and collaborate with top professionals.
- Qualifications: Expertise in Snowflake, SQL, and enterprise data modelling tools required.
The predicted salary is between 90000 - 110000 $ per year.
An opportunity to take a strategic lead in shaping enterprise data modelling, governance, and architecture across high-impact initiatives within a major Federal Government environment. You could collaborate closely with architects, data engineers, and executive stakeholders to build a modern, high-performance data analytics platform delivering critical outcomes nationwide.
Role & Responsibilities
- Drive the architecture, design, and governance of enterprise semantic models, certified datasets, key metrics, and enterprise KPIs.
- Partner with business leaders and technical architects to convert intricate business logic into robust logical, physical, dimensional, and semantic data models.
- Design scalable, enterprise-grade star schema solutions, encompassing fact and dimension tables, relationships, hierarchies, and appropriate data granularity.
- Engineer presentation layer tables, views, and complex SQL transformations within cloud data platforms to maximise performance and analytics consumption.
- Build reusable semantic layers within enterprise BI tools, eliminating metric duplication and enabling accurate self-service reporting across the organisation.
- Align with data engineering teams to define source data requirements, resolve integration challenges, and tune database query performance and filter propagation.
Skills & Experience Required
- Deep proficiency with Snowflake, advanced SQL, enterprise data modelling tools (e.g., Erwin), dimensional modelling/star schema techniques, and modern BI tools such as Power BI.
- Exposure to AWS, Databricks, MS Fabric, or Redshift is highly regarded.
- Demonstrated senior/lead track record delivering enterprise data models within complex, large-scale data environments, with robust knowledge of metadata management, data governance frameworks, and normalisation standards.
- Exceptional stakeholder facilitation and communication skills, with a proven ability to lead technical workshops and translate sophisticated architectural concepts for non-technical stakeholders.
- Experience supporting large-scale transformation programs in Australian Government or regulated environments is strongly advantageous.
Eligibility & Clearance Requirements
- Location available: CBR, NSW, QLD or VIC
- Security Clearance: Candidates must hold a current NV1 security clearance to apply.
Lead Data Modeller in Canberra employer: Aurec
Aurec is an exceptional employer that champions innovation and sustainability, offering a collaborative work culture where your contributions directly impact climate and biodiversity initiatives across Australia. With a strong focus on employee growth, you will have access to ongoing training and development opportunities, ensuring you stay at the forefront of GIS technology while working in a dynamic environment dedicated to meaningful ecological solutions.
