Data Modeller & Analyst
XPT Software Australia Pty Ltd Sydney, New South Wales, Australia
IT Services and IT Consulting · 51-200 employees
About the role
The Data Modeller & Analyst will design conceptual, logical, and physical data models while ensuring they align with business requirements and information architecture. They are responsible for mapping source data to target schemas, performing data quality assessments, and managing metadata across enterprise systems.
What they look for
Requirements
Candidates must have at least 5 years of data modelling experience and domain expertise in transactional and analytical systems. Proficiency in UML, SQL, enterprise database management systems, and cloud platforms like AWS is required.
Full description
Position
Data Modeller and Analyst
Required Capabilities and Skills
Required Capabilities
- Data Modelling
o Conceptual, logical (Entity Relationship) and physical data modelling.
o Data models review with both IT and business audiences, communicating how the model meets requirements of both existing projects and the overall information architecture and strategy and any relevant deficiencies and gaps.
o UML modelling using all of the following:
▪ Class diagrams
▪ Activity diagrams
▪ Sequence diagrams
▪ Component and package diagrams
- Analyse and translate current
application and data landscapes and future business requirements into detailed logical data models.
- Strong metadata management
(technical and business), incorporating metadata practices into all modelling activities.
- Data analysis
o Analysis of source system including database structures, semi-structured and unstructured data stores.
o Understanding and assessment of source system schemas; table structures and relationships, primary / foreign keys, indexing, etc.
o Determining reference data domains and ranges and relationship to transactional data.
- Data mapping and transformation
o Mapping of source data elements to target models and data schemas using detailed logical data models.
o Ability to work with source system SMEs to determine correct mappings, transformations and gaps.
o Analysis and documentation of source to target data lineage.
- Data Discovery and Data Quality
Assessment
o Detailed analysis of source system data structures and content to assess “fitness for purpose”.
Skills, Experience & Qualifications
- Experience in data analysis and
modelling against transactional and analytical systems.
- Experience in the use of data
modelling tools and the management of data modelling repositories and solutions.
- Experience in using data profiling,
using both automated tools and hand coded SQL to determine data quality metrics, constraints, etc.
- Experience in the delivery of large
scale, information management, information governance and analytics solutions
- At least 5 years of data modelling
and analysis experience.
- Business communication skills.
- Working knowledge of large
enterprise relational database management systems comprising of traditional databases (MS SQL Server, Oracle) and cloud based platforms and solutions within AWS.
- Working knowledge of data
governance frameworks, processes and technologies such as data catalogues and business glossaries.
Work Experience: 10+ years with domain expertise.
