Data Modeller & Analyst

XPT Software Australia Pty Ltd; Sydney; On-site; AUD 110,000 - 170,000; Full time

Job summary

XPT Software Australia Pty Ltd in Sydney invites a Data Modeller and Analyst to join our software services team. You will design conceptual, logical and physical data models, conduct data profiling, and map source data to target schemas, working with IT and business stakeholders.

The role requires strong UML modelling, metadata management, and experience with MS SQL Server, Oracle, and AWS. You will ensure data quality and governance across large enterprise systems, supporting analytics and

Qualifications

• Experience in data analysis and modelling against transactional and analytical systems.
• Proficient with data profiling using SQL and automated tools.
• Experience delivering large-scale information management and analytics solutions.
• At least 5 years of data modelling and analysis experience.
• Strong business communication skills.
• Experience with MS SQL Server, Oracle, and AWS cloud platforms.

Skills

Data analysis

Data modelling

UML modelling

Metadata management

Data profiling

SQL

Data governance

Business communication

Data mapping

Data lineage

Tools

SQL tools

Data modelling tools

Data governance tools

Job description

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 the following:
• Activity diagrams
• Component and package diagrams
• Analyse and translate currentapplication and data landscapes and future business requirements intodetailed logical data models.
• Strong 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.