Role: Data Modeller

Location of work: Multiple Locations
Length of contract: 12 months
Contract extensions: Possible extension options up to 12 months

Overview

Our large Federal Govt. client are seeking for an experienced Data Modeller on an urgent basis!

Key responsibilities include, but are not limited to the following:

• Develop and enhance data models with adherence to data architecture principles and data modelling templates, methods and standards.
• Assist Business analysts in understanding and identifying the business needs of data.
• Develop the conceptual and logical data models supporting the requirements. Update the conceptual and logical models in the appropriate folder within the ER Studio Repository.
• Query and interpret data using efficient and effective SQL and provide sound advice on complex data/information related matters to deliver quality solutions
• Work with Data Analysts in identifying the data structures and relationships that exist in the available sources of data including data flows, lineage and definitions.
• Work with the Solutions Designer and Data Analysts to identify gaps in the data, structures and relationships of new data required/acquired, processes to be developed around the data including derivation of values, data cleansing and conversion where applicable.
• Translate the logical model into the physical model, considering data availability, constraints and processes around the data.
• Update the physical model in ER Studio.
• Design the physical tables, noting primary keys and data types.
• Provide advice to data modelling stream lead for continuous improvement, considering industry best practices.
• Be intimately familiar with data modelling methods used within the Aged Care Data Warehouse, such as:
  • E/R Diagrams
  • Dimensional modelling
  • Data Vault modelling
  • Normalised (3NF) modelling
• Work with the development and BAU teams to implement the new and/or amended solution.
• Review and provide feedback to business analysts for reporting requirements, review and provide feedback for solution architecture design.
• Provide peer review feedback for data analysts project deliverables.
• Responsible for the following artefact: Data Models, Release document, DDL SQL scripts.
• Work with management to provide effort estimates, prioritize business and information needs.

Required Skills and Experience

• Minimum 5 years of data modelling experience.
• Minimum three (3) years of experience in structured analysis and design.
• Knowledge of business intelligence solutions and data warehouse development
• Negotiation and influencing skills
• Excellent interpersonal and communication skills
• Strong knowledge on system development life cycle
• Strong analysis skills and attention to detail
• Understanding of data modelling principles for data warehouses
• Strong delivery focus to complete tasks within schedule and quality standards
• Strong verbal and written communication skills
• Extensive experience as a BI Data Modeller, specialising in dimensional data modelling (Kimball methodology)
• Strong understanding of traditional/modern BI/DW, ETL and metadata concepts
• Demonstrated experience in using data modelling and metadata management tools such as ER Studio, Sparx EA, Erwin, or similar
• Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models
• Experience in data analysis, data profiling, data mapping documentation, design and querying languages including SQL or similar
• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks
• Strong understanding of MDM (Master Data Management)
• Experience with the following:
  • Data modelling - dimensional and ERD, and awareness of data vault
  • Various database platforms (i.e. Oracle, SQL Server )
  • XML schema design, ER Studio or similar
  • Data management principles such as Metadata management, Data governance and Data quality
• Strong liaison and interpersonal skills including the ability to:
• Engage with requesting business areas and other project stakeholders
• Discuss technical matters with both technical and non-technical staff
• Negotiate outcomes between business and technical areas
• Ability to work in a multidisciplinary team undertaking multiple projects and maintenance activities with potentially competing priorities
• Bachelor's degree in IT; or equivalent experience.
• Minimum 3- 5 years' experience of database design and development

Please note that due to nature of work Australian Citizenship is mandatory with an ability to obtain Baseline Clearance

Shwetha Bhaskar
Candidate Manager

ManpowerGroup is committed to being a Diversity Confident Recruiter and encourages applications from people from a diverse range of backgrounds, including people with a disability. Please indicate your preferred method of communication in your resume and please let us know if you require any reasonable adjustments should you be contacted for an interview.

Aboriginal and Torres Strait Islander people are encouraged to apply.

By submitting your resume and other personal information with this application you are consenting to this information being collected in line with our privacy policy. Follow the link to learn more - www.manpowergroup.com.au/privacy-policy

Experis Pty Ltd is a wholly owned subsidiary of ManpowerGroup

State: QLD, licensee/s Manpower Services (Australia) Pty Ltd, LHL-02026-D5L4Q. State: QLD, licensee/s Experis Pty Ltd, LHL-02014-Y5F6D. State: SA, licensee/s Manpower Services (Australia) Pty Ltd, LHS 288856