Data Modeller & Analyst (City of Sydney)

Data Modeller & Analyst (City of Sydney)

16 Aug
|
Xpt Software Australia
|
City of Sydney

16 Aug

Xpt Software Australia

City of Sydney

XPT Software Australia Pty Ltd | Contract

Sydney, Australia | Posted on 08/13/2026

- XPT SoftwareAustralia PTY Ltd, incorporated in 2016, is a Software Services company
- XPT works with topclients across Australia in Banking, Insurance, Telecom,Retail, Energy, Mining and Manufacturingdomains.
- We have 120+technocrats in Australia working at our clientlocations.
- XPT SoftwareAustralia is part of group companies which has globalpresence across India & Europe.
- We have served100+ clients globally, fulfilling their onsite-offshoreneeds.

Job Description

Position

Data Modellerand Analyst

Required Capabilities and Skills

Required Capabilities

- Conceptual, logical (EntityRelationship) and physical data modelling.
- Data models review with both IT andbusiness audiences, communicating how the model meets requirements of bothexisting projects and the overall information architecture and strategy andany relevant deficiencies and gaps.
- UML modelling using all of thefollowing:
- Activity diagrams
- Component and package diagrams
- Analyse and translate currentapplication and data landscapes and future business requirements intodetailed logical data models.
- Robust metadata management(technical and business), incorporating metadata practices into all modellingactivities.
- Analysis of source system includingdatabase structures, semi-structured and unstructured data stores.
- Understanding and assessment of sourcesystem schemas; table structures and relationships, primary / foreign keys,indexing, etc.




- Determining reference data domainsand ranges and relationship to transactional data.
- Data mapping and transformation
- Mapping of source data elements totarget models and data schemas using detailed logical data models.
- Ability to work with source systemSMEs to determine correct mappings, transformations and gaps.
- Analysis and documentation ofsource to target data lineage.
- Data Discovery and Data QualityAssessment
- Detailed analysis of source systemdata structures and content to assess "fitness for purpose".

Skills, Experience & Qualifications

- Experience in data analysis andmodelling against transactional and analytical systems.
- Experience in the use of datamodelling tools and the management of data modelling repositories andsolutions.
- Experience in using data profiling,using both automated tools and hand coded SQL to determine data qualitymetrics, constraints, etc.
- Experience in the delivery of largescale, information management, information governance and analytics solutions
- At least 5 years of data modellingand analysis experience.
- Business communication skills.
- Working knowledge of largeenterprise relational database management systems comprising of traditionaldatabases (MS SQL Server, Oracle) and cloud based platforms and solutionswithin AWS.
- Working knowledge of datagovernance frameworks, processes and technologies such as data catalogues andbusiness glossaries.

Work Experience: 10+ years with domain expertise.

#J-18808-Ljbffr

📌 Data Modeller & Analyst (City of Sydney)
🏢 Xpt Software Australia
📍 City of Sydney

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data modeller & analyst (city of sydney) / city of sydney

Subscribe to this job alert:

Get the latest job offers by email for: data modeller & analyst (city of sydney) / city of sydney