Lead Data Modeller

Role/s: 1 x EL1 Data Modeller The EL1 Data Modeller role is responsible for leading enterprise data modelling activities across multiple projects and initiatives. Working closely with architects, engineers, analysts and business stakeholders, the position drives best practice data modelling, governance and design to support the Agency's modern data platform and analytics capability. Supplier Briefing: A supplier briefing will be held for this role on Friday 30 October – meeting details will be posted in the “Q&A” section of the RFQ for invited Sellers only. Rate: The proposed rate should reflect candidate's skills and experience against the Evaluation Criteria. Candidates that do not demonstrate these criteria will not be assessed. Candidates should be aware that rates may be negotiated further as part of the selection process. Citizenship: As part of the eligibility and suitability requirement, NDIA seeks Labour Hire Workers who are Australian citizens only. Successful candidates will be required to furnish valid evidence of citizenship during the Pre-engagement Check. Labour Hire Licence: Applicable for ACT, VIC and QLD: Labour hire licences are required in the state that specified personnel are being contracted. Key duties and responsibilities 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. Define and implement business measures, KPIs, calculations and reusable business logic. Collaborate with data engineering teams to identify source data requirements, resolve data modelling challenges and ensure data is structured appropriately for analytical consumption.  Optimise semantic model performance including relationships, cardinality, filter propagation and underlying database query performance. Work closely with reporting and analytics teams to enable consumption of governed semantic models without duplicating business logic across individual reports.   (Note: responsibilities may change based on business priorities.) Criteria The buyer has specified that each candidate must provide a response to each criterion. Each response is limited to 3000 characters. Essential criteria 1. 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. 2. 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. 3. 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. 4. Demonstrated proficiency in data modelling tools and techniques, including ER modelling, dimensional modelling, data normalisation, and the use of ERWIN or equivalent modelling tools. 5. 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. 6. Excellent stakeholder engagement, communication and facilitation skills, with the ability to conduct workshops, collaborate across technical and business teams, and present complex technical concepts to senior stakeholders. Desirable criteria 1. Experience working with cloud data platforms including AWS, Databricks, Snowflake, MS Fabric, Redshift or similar technologies. 2. Experience supporting enterprise architecture, data strategy or large-scale data transformation programs. 3. Knowledge of data governance, metadata management, master data management and data quality frameworks. 4. Previous experience working within the Australian Government or other highly regulated environments. Opportunity summary Sellers can submit Up to 3 candidates Number of sellers invited More than 10 Number of candidates submitted Fewer than 10 RFQ closing time 01 Weeks 06 Days 18 Hours Send us feedback About Accessibility Privacy Terms of use Disclaimer and copyright An initiative of the Digital Transformation Agency The Australian Government acknowledges the Traditional Owners of Country throughout Australia and acknowledges their continuing connection to land, waters and community. We pay our respects to the people, the cultures and the Elders past and present. © Commonwealth of Australia