Data Modeller and Analyst

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.

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