RFQ2122-150 - Data Modeller
Tender ID: 494158
Tender Details
Tender Description
The Deliverables for the Data Modeller include, but are not limited to the following:
• Develop and enhance data models with adherence to ACDW 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:
o E/R Diagrams
o Dimensional modelling
o Data Vault modelling
o 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.
Location
New South Wales : Central West : Far North Coast : Far West : Hunter : Illawarra : Mid North Coast : Murray : New England : Orana : Riverina : Southern Highlands : Sydney
Queensland : Cairns & Far North Queensland : Gladstone : Mackay Whitsunday Region : Mount Isa & North West Region : Rockhampton : South East Queensland : South West & Darling Downs : The Central West : Townsville : Wide Bay Burnett
Victoria : Barwon South West : Gippsland : Grampians : Hume : Loddon Mallee : Melbourne
South Australia : Adelaide : Eyre & Western : Far North : Fleurieu & Kangaroo Island : Limestone Coast : Murray & Mallee : York & Mid North
Northern Territory : Big Rivers : Central Australia : East Arnhem : Greater Darwin
Australian Capital Territory
Tasmania
Similar Tenders
Active opportunities matching this tender's categories and regions.