Design source-to-target mapping and design documents that consider security, performance tuning and other best practices
- Salary from $106k plus super| Permanent Opportunity
- Sydney Location | Hybrid working environment
**About the Role**
This role will be a part of the data engineering team, will work closely with ETL developers and Data engineers to provide data architectural tasks, including data models, reverse engineering, and optimise data flows and automate the data integration from multiple data sources by designing databases and purpose build data marts for business specific requirements. Data accessibility and accuracy are critical to this role to deliver fact driven high quality insurance service and care to people of NSW.
**Benefits**
- A corporate wellbeing program with subsidised gym membership, free flu vaccinations and health check programs
- icare day - access to an extra day’s leave
- Comprehensive learning and development support aligned to icare’s Core Capabilities.
- Our People Awards - On-the-spot Recognition, Quarterly Values Awards & Our People Annual Awards
- Access to our Employee Assistance Program
**Duties**
It’s an exciting time at icare where no two days are the same; as **Data Modeller** you will:
- Analysing and translating business needs into long-term solution data models.
- Evaluating existing data systems.
- Working with the development team to create conceptual data models and data flows.
- Developing best practices for data coding to ensure consistency within the system.
- Reviewing modifications of existing systems for cross-compatibility.
- Implementing data strategies and developing physical data models.
- Updating and optimizing local and metadata models.
- Evaluating implemented data systems for variances, discrepancies, and efficiency.
- Troubleshooting and optimizing data systems.
**Skills & Experience**
- Relevant experience in Data Modelling, specialising in dimensional data modelling (implementing Kimball methodology to design data marts - bus matrix, star schemas, conformed dimensions, etc.)
- Experience in modelling BI Semantic Layers - modelling Snowflake datasets will be an added advantage.
- Substantial understanding of traditional/up-to-date BI/DW, ETL and metadata concepts.
- Demonstrated experience in using data modelling tools such as Sparx EA, Erwin, or similar.
- Hands on commercial experience or exposure to using snowflake and AWS Cloud technologies
- High level analytical, problem solving and research skills in dealing with complex enterprise system issues, including the ability to develop and implement innovative strategies and solutions to address those issues.
- A Bachelor's Degree or equivalent in Computer engineering, Computer Science, Information Systems, or relevant experience in data modelling
- Strong interpersonal skills
- Excellent communication and presentation skills.
**Culture**
We know our strength comes from the diversity of our people and would encourage people with different experiences and backgrounds to apply. We are committed to our people’s development so the people of NSW can thrive.
**About the Company**
We care for the people of NSW, building confidence and trust so our communities can thrive. We make the complex simple, so our schemes deliver better outcomes for people and communities. Whether a person is severely injured in the workplace or on our roads, icare supports their long-term care needs to improve quality of life, including helping people return to work.
In addition, we insure builders and homeowners, provide treatment and care to people severely injured on NSW roads; and protect more than $266.6 billion of NSW Government assets, including the Sydney Opera House, the Sydney Harbour Bridge, schools and hospitals.
- For more information about icare visit our website
- **icare operates a direct sourcing model so no agency introductions will be accepted**:
- We are a Circle Back Initiative Employer - we commit to respond to every applicant
- A talent pool may be created through this recruitment process.
📌 Data Modeller
🏢 NSW Government -iCare
📍 Sydney