Data Modeller & Analyst

XPT Software Australia Pty Ltd Contract

Sydney, Australia

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