Job Profile Job Title: Data Migration Analyst Date Completed: 13 November 2014 Job Reference Number: T5STC056 Tier: Tier 5 Job Band: Band 5 Functional Area: Strategy, Transformation and Commissioning Support Accountable to: Data Migration Lead Job Dimensions: No budgetary responsibility or responsibility for people. Responsible for system, process and data analysis across ECC Social Care Case Management. The role will require close working across Adults and Families Social Care teams, Finance, Information Services, the Transformation Support Unit and external vendors.

The Role: Essex County Council (ECC) is one of the largest and most dynamic local authorities in the UK and is undergoing significant transformational change to further enhance customer focus, service and delivery. The Social Care Case Management (SCCM) Project will deliver a single social care case management solution for Essex County Council, to replace multiple existing systems, encompassing both Adult and Families social care case management. The Data Migration Analyst will take a lead role in the analysis of multiple legacy social care systems, modelling past and present working practices, and contributing to the definition of processes and configuration for the new SCCM system. The post-holder will have a key role in identifying data quality issues across legacy systems, and

This issue: 01 October 2013

1

will be expected to recommend solutions to these issues. The post holder will develop business rules, validations and transformations that are necessary to complete a successful migration to the new SCCM system, and will liaise with stakeholders across the business to ensure that these are understood, accepted and conform to Information Governance requirements.

Job Purpose Summary: To proactively engage with the business to develop migration strategies that ensure ECC social care data is successfully and safely migrated to a new SCCM system, in line with Information Governance requirements. To highlight data quality issues, propose solutions and oversee their final resolution.

Key Responsibilities and Accountabilities: Non Line Manager Core Accountabilities 

Understand the needs of your customers and deliver the best possible outcomes through exemplar behaviour in accordance with ECC’s Values and Core Organisational Behaviours.



Work flexibly and collaboratively across structural boundaries in support of key outcomes.



To contribute to development of organisational capability by taking ownership of your own training and development, including identifying and taking part in training and development activity and responding to feedback on performance.



Thinking creatively, challenging the norms, and constructively challenging those around them (including those more senior) to ensure continuous improvement and commercial astuteness, and inspire the same in colleagues.



Take responsibility for identifying and actioning areas of risk including Health and Safety and Business Continuity.



Work as part of project or process teams as required under the new operating model, ensuring excellent cross functional output.

Role Specific Accountabilities 

Develop a deep understanding existing systems, and model them in terms of logical data entities.



Take a lead role in identifying data that is in scope for migration.



Analyse data coverage and data integrity across systems.



Identify gaps in data coverage between legacy systems and target system, working with stakeholders and the external provider to solve these issues.



Propose data mapping and data transformation rules



Establish and maintain excellent working relationships with key stakeholders and the wider organisation in order to facilitate the effective delivery of the role.



Workshop facilitation.



Work with stakeholders, subject matter experts and Internal Audit to ensure completeness and accuracy of the data migration



To provide support to the wider SCCM project and contribute to, or take responsibility for specific aspects of project work, ensuring targets and milestones are met.

Knowledge, Skills and Experience (maximum 10):  Qualified to degree level or equivalent, ideally in a relevant subject, or equivalent by experience. 

Advanced knowledge of SQL Server 2005 or higher and Oracle 9i or higher



Advanced Knowledge of Microsoft Excel



2 + years’ experience in a Data Analyst or Business Analyst role



Excellent Microsoft Office/PC skills



Highly organised and results oriented



Advanced analytical skills to identify data quality/integrity issues and make recommendations.



Impeccable attention to detail, with passion for processes and systems



Ability to establish credibility with managers and other stakeholders.



The ability to present complex proposals to an audience of mixed technical ability.



Evidence of continuing professional development.



Impeccable attention to detail, with passion for processes and systems



The ability to work with a wide cross-section of people in various locations

Competencies and Behaviours: The postholder must behave in accordance with ECC’s Values and Behaviours. Non Leadership Behaviour Matrix. These behaviours are intended for ECC team members and independent contributors . CLEAR 

By being clear about my role and the service that I provide, I help ECC deliver successful

outcomes for the Essex community. ACCOUNTABLE 

By taking personal responsibility for my actions and the achievement of my objectives, I understand how I contribute to improving ECC’s performance.

INNOVATE 

By being open to change and putting forward my ideas to adapt and improve services, I play a role in improving ECC’s performance.

TRUST 

By building trusting relationships with my team and ECC’s customers I contribute to the success of my team and of ECC.

CUSTOMER CENTRIC 

By understanding and delivering against the needs of my customers, I help to deliver the best possible outcomes for the wider Essex community.

DELIVER 

By consistently meeting or exceeding quality standards, deadlines and achieving my personal goals, I help my team to deliver effective services to the wider Essex com munity.

DRIVE 

By taking the initiative to get my job done I contribute to the success of my team and ultimately improve outcomes for the Essex community.

SELF-AWARENESS By understanding my own personal style and how this affects how I behave, I find the best way to work with my colleagues and customers.

Work Style: Office based. An office based employee will spend most of their working time at a desk. They will rarely attend meetings and are unlikely to be away from the office. They may, however, work flexibly on an infrequent/ad-hoc basis. Flexible office based. A flexible office based employee will have a main base but will either attend regular meetings, and/or work flexibly on a more frequent basis.

Mobile. A mobile employee has a nominated ECC base but spends at least 50% of their time working flexibly. Home based. A home based worker has no nominated ECC base and spends at least 80% of their time working at home.

Safeguarding: Essex County Council is committed to safeguarding and promoting the welfare of children and vulnerable adults, and expects all employees and volunteers to share this commitment. Role Requirement: This role does not require a DBS (CRB) check.

JP Owners

Signed

Date

Pre-employment Checks: Role Requirement: Not working with children or vulnerable adults, in a specified place or in a specified post. Pre-Employment Check

Definition

Self Declaration (Unspent convictions only)

A declaration of unspent convictions must be completed by all employees who do not work directly with vulnerable adults or children.

References

A minimum of two employer references will be required one of which must be the last employer. Any gaps of 4 weeks or more will be explored by the manager at interview stage. Where requested by the manager additional character references will be taken up.

Medical

All new recruits are required to complete a medical health declaration.

ID/ Eligibility to work in the UK

Proof is required in line with UK Visa and Immigration requirements and original documentation will be sought i.e. passport or full birth certificate.

Regulatory qualifications and professional registration (subject to role)

Original qualification certificates and proof of registration with a professional body is required (if applicable).

Protocol Check (SCF - Children’s Social Care Team only, now known as Family Operations)

A check against the individuals name on the Social Care electronic database will be administered.

Safer Recruitment Consultant

Signed

Date