Job Title-Data Architect_CRM
Client-Global Consulting Firm
Day Rate-£500-£550 (Outside IR35)
Duration-3-6 months (extendable)
Location-Hybrid (1-2 days per week from Preston) or can work only 3 days per week (fully remote)
To guide and facilitate the replacement of one product with another
To determine the scope of data necessary to support the business processes facilitated by the current product.
To determine whether the existing product contains redundant functionality and supporting data structures.
To determine whether the existing product functionality needs to be extended to meet new business requirements.
To determine whether potential replacement products contain in-built data structures to support the business processes that the organisation requires of it (both existing and future).
To determine whether potential replacement products can be customised to contain data structures to support the business processes that the organisation requires of it.
Produce logical and/or physical data model of the existing product.
Logical – entities, attributes and entity to entity relationships
Physical – tables, columns, primary and foreign keys
Include sample data if possible, this will help data mapping between products
Obtain models of potential replacement products
Data mapping – produce a business process led comparison between products.
For example:
‘Customer case’ in current product is satisfied from ‘contact’, ‘incident’, ‘root cause’, ‘owner’, ‘business unit’ and ‘activity’ tables.
In a potential replacement product this might be ‘customer’, ‘case’, ‘reason’, ’event’.
The DA would determine whether what data needs to create and store in relation to ‘customer cases’ is satisfied by the entities in the replacement product. What the mapping is, and should the model not satisfy the requirement can it be amended.
Provide best practice guidance on data modelling. Design of entities and attributes, primary and foreign key choices, relationship types between entities, naming standards.