Data Modeller & Analyst
On-siteSydney, New South Wales, Australia
Job Summary
Conduct conceptual, logical, and physical data modelling using UML diagrams to meet IT and business requirements. Analyze source system schemas, database structures, and unstructured data stores to determine reference data domains and assess fitness for purpose. Map source data elements to target models and document data lineage while collaborating with subject matter experts on transformations and gaps. Review existing projects and information architecture strategies to identify deficiencies, ensuring strong metadata management across all activities. Deliver large-scale information management solutions within enterprise relational databases and AWS cloud platforms. Requires 10+ years of domain expertise and 5+ years of data modelling experience.
Required Qualifications
- Conceptual, logical (Entity Relationship) and physical data modelling
- Data models review with both IT and business audiences
- 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)
- Analysis of source system including database structures, semi-structured and unstructured data stores
- Understanding and assessment of source system schemas; table structures and relationships, primary / foreign keys, indexing, etc
- Determining reference data domains and ranges and relationship to transactional data
- Mapping of source data elements to target models and data schemas using detailed logical data models
- Ability to work with source system SMEs to determine correct mappings, transformations and gaps
- Analysis and documentation of source to target data lineage
- Detailed analysis of source system data structures and content to assess fitness for purpose
- 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
- 10+ years with domain expertise
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.