Data Modeller & Analyst

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.