Job Description:
Australian Citizens residing in Australia only respond.
Job details
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.
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.)
Required Skills:
Reports Performance Analysts Data Support Database Calculations Data Engineering Architects Business Requirements Metrics Analytics Design Engineering Business SQL
#J-18808-Ljbffr
El1 Lead Data Modeller employer: Softtest Pays Pty
As an EL1 Technical Delivery Manager in Adelaide, you'll join a dynamic team dedicated to delivering impactful Cyber Security and assurance projects. Our company fosters a collaborative work culture that prioritises employee growth through continuous learning opportunities and mentorship, ensuring you can advance your career while making a meaningful contribution to national security. With a focus on innovation and a commitment to the well-being of our employees, we offer a supportive environment where your expertise will be valued and recognised.
