Data Modeller

The Deliverables for the Data Modeller include, but are not limited to the following:

• 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.

Skills

Data Modeller

• Minimum 5 years of data modelling
• Minimum three (3) years of experience in structured analysis and
• Knowledge of business intelligence solutions and data warehouse development
• Negotiation and influencing
• Excellent interpersonal and communication
• Strong knowledge on system development life
• Strong analysis skills and attention to
• Understanding of data modelling principles for data
• Strong delivery focus to complete tasks within schedule and quality
• Strong verbal and written communication
• 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
• Discuss technical matters with both technical and non-technical
• Negotiate outcomes between business and technical
• Ability to work in a multidisciplinary team undertaking multiple projects and maintenance activities with potentially competing priorities.
• Bachelor's degree in IT; or equivalent

If you wish to apply for this position, please submit your resume by clicking the 'Apply Now' button. For further information please contact Shilpa Kunhikannan Sreeja at Clicks IT Recruitment on +61 430 294 828.

At Clicks we embrace diversity, inclusion and equal opportunity.

We provide reasonable adjustments, including alternate formats to the recruitment process for individuals with disability. If you require an adjustment to be made during the recruitment process, please call 1300 254 257 or email adjustments@clicks.com.au