• No results found

INFORMATION TECHNOLOGY AND MEDIA SERVICES

N/A
N/A
Protected

Academic year: 2021

Share "INFORMATION TECHNOLOGY AND MEDIA SERVICES"

Copied!
5
0
0

Loading.... (view fulltext now)

Full text

(1)

INFORMATION TECHNOLOGY AND MEDIA SERVICES

Programmes and Planning, Core Systems Modernisation

Programme

CSM BI Data Migration Technical Lead Full Time, Fixed Term (24 months) Grade G: £36,309 - £45,954 per annum

An opportunity has arisen to join the IT and Media Services (ITMS) Directorate, you will be working with the CSM Business Intelligence and Business Process teams at an exciting time of investment and modernisation at DMU.

The Technical Lead works within the CSM BI project team and provides leadership and coordination of all technical aspects of systems development activities required to provide a productive and efficient system.

Responsible for the data migration activity from De Montfort University’s (DMU’s) legacy systems into target core system, as part of the Core System Modernisation Programme. You will be leading a team of Data Analysts and developers to create a stable and scalable platform for Data Transformation.

You must have extensive Data Warehouse and BI experience, in depth experience of working in a Project Management and Data Migration environment; extensive experience in ETL workbenches; experience in following Data Governance, Processes and Protocols as well as Business Intelligence.

You must be able to demonstrate good communication skills and an ability to present clearly and concisely to a variety of audiences, along with excellent interpersonal skills and the ability to develop and maintain good working relationships with stakeholders at all levels in an often pressured, high profile environment.

For further information or an informal discussion about this role please contact the ITMS CSM Programme Manager, Paul Bodell, on 0116 207 8966 or [email protected].

Please quote

reference: 8561

(2)

Job Description

Job title: CSM BI Data Migration Technical Lead

Information Technology and Media Services

Duties of the role

Overall purpose

of the role

To be responsible for the data migration activity from De Montfort University’s (DMU’s) legacy systems into target core systems as part of the Core System Modernisation Programme. Leading a team of Data Analysts and developers to create a stable and scalable platform for Data Transformation.

The Universities core resource systems (Student Records, Finance, and HR) which are made up of many legacy systems provided by multiple vendors are now causing significant issues. The Core Systems Modernisation (CSM) aims to address these issues.

The core of the CSM programme is targeted at creating a change in efficiency and effectiveness of the core resource management across the University.

Main duties and

responsibilities

1. Lead the design and implement an ETL Framework for Data Migration, adhering to industry best practice and our architectural standards.

2. Define and implement coding standards, documentation standards and version control, ensuring that all migration development activity confirms to these standards 3. Direct development activity to ensure that migration development goals are delivered

on time and within budget

4. Remove technical impediments to development, escalating to the Project Manager where required

5. Conduct regular reviews with ETL Developers and Data Migration Analysts, giving feedback and ensuring quality standards are upheld.

6. Responsibility for software quality through test-driven development and adherence to our Quality Assurance standards, working closely with the Quality Assurance team. To sign off unit testing and ensure that QA testing defects are resolved in a timely manner

7. Work closely with the Business Analyst Lead, Data Governance Lead and Project Manager to ensure data mapping and data quality are implemented correctly to business requirements

8. Responsible for providing estimates, project planning, project risk identification and mitigation action planning with the Project Manager

9. Provide regular development status updates, discussing high priority cases immediately with the Project Manager and assist with attrition management 10. To be a Data Migration technical expert. Helping to build a strong and effective

customer focused and professional team of Data Migration experts through effective coordination, coaching and facilitation. Provide mentorship and leadership that models the university’s values, motivates staff, promotes performance improvement and enables ITMS to deliver excellence based on meeting agreed targets and objectives. 11. Foster and encourage a climate of cross team mentoring and knowledge transfer to

(3)

Duties of the role

12. Engage with all other stakeholders to continuously look at pragmatic ways that inter-team working can be improved by sharing information, knowledge and best practice. Identify and suggest solutions to any process gaps that appear and help build a collaborative culture based on transparency, openness and trust.

13. Ensure compliance with corporate standards for information systems, security and technology are in line with relevant legislation and audit requirements

14. Remain innovative and stay abreast of all relevant industry and technological developments in the market place and provide advice to the Data Migration Project Manager on how to take advantage of these to support the development of initiatives that deliver programme objectives.

15. Take responsibility for ensuring that the university’s strategic equality plans are in place and provide regular reports on progress.

16. Treat all DMU staff, students, contractors and visitors with dignity and respect. Provide a service that complies with the Equality Act 2010, eliminating unlawful discrimination, advancing equality of opportunity and fostering good relations with particular attention to the protected characteristics of age, disability, gender

(4)

Person Specification

CSM BI Project: Technical Lead

Information Technology and Media Services

Grade: G

Role Profile Ref:

Full Time, Fixed Term (24 months)

Area of

responsibility

Requirements

Essential or desirable *Method of

assessment

A

I

T

D

Qualifications

and Training

Educated to degree level or equivalent

experience.

X

X

X

Professional

Qualifications

Professional Certification in ETL and /

or RDMS technology.

X

X

X

X

Management

Managing a team of Data Migration

specialists in either a Microsoft SQL

or/and Oracle environments.

X

X

X

Data Governance Experience monitoring and improving

data quality across multiple

applications and data sources. This will

include Master Data Management,

Data Cleansing and Data Quality

Auditing.

X

X

X

Data Migration

Experience of ETL within a Data

Migration Environment.

X

X

X

Enterprise

solutions

Knowledge and expertise of enterprise

ETL Tools (e.g. SSIS, DataStage,

Talend).

X

Leadership

Experience in a lead/senior position in

a technical environment.

X

X

X

Problem solving

Strong analytical and problem solving

skills.

X

Solution Design

Experience in writing and performance

tuning SQL and

in ETL design

methodologies and concepts, plus an

understanding of best practice

development methodologies.

X

Stakeholder

Engagement

Experience working closely with

customers on solution design, in

cross-functional teams and with senior

(5)

Area of

responsibility

Requirements

Essential or desirable *Method of

assessment

A

I

T

D

stakeholder. Customer focused.

Technical Design A proven track record in delivering

quality fit for purpose ETL solutions on

time and to budget in large, complex

organisations. This will include

design/development of ETL

Frameworks, Batch Process and Audit.

X

Data Cleansing

Use of Data Cleansing and Data

Profiling Tools.

X

X

X

X

Development

Experience of the full development

lifecycle including requirements

gathering, estimation, design, software

development, configuration

management, release management,

testing, training etc.

X

Programming

SQL programming skills (e.g. T-SQL

and/or P-SQL).

X

Solution

Architecture

Knowledge of HE solution

requirements.

X

X

X

X

Communications Good communication, presentation and

report writing skills.

X

Continuous

Improvement

The ability to recognise new

approaches and be able to contribute

to continuous improvement.

X

X

X

Data Operations

Experience of data operations within a

UK Higher Education environment.

X

X

X

Data Security &

Integrity

Knowledge of HE regulatory data

requirements.

X

X

X

X

Societal Ethics

Commitment to equality and diversity.

X

X

X

Team Leadership

Team Leadership of a dedicated

technical team specialising in Data

Migration.

X

Database Design

Knowledge and expertise in

designing,

developing, implementing and

supporting

relational and OLAP

databases such as SQL Server or

Oracle.

X

References

Related documents

• Grupos combinados: crea un diagrama de dispersión de los valores en las dos primeras funciones discriminantes. Si solo hay una función obtendremos un histograma. •

Regarding the sample quality acquired in speaker and face recognition, there is a remarkable difference between the Control group (almost no error) and CRMF test subjects.. This is

The purpose of this Service Level Agreement (SLA) is to define the levels of service provided by Information Technology Services (ITS) to Victoria University of Wellington (VUW)

Innovative tools for quality assessment: integrated quality criteria for review of multiple study designs (ICROMS). Pediatric antibiotic stewardship: successful interventions to

But if it be true, in the case of the earth, that oxidation ceased before the oxidation was complete, then we are particularly inter- ested in knowing which

Our approach accommodates a wide variety of applications, including settings in which there is an unobserved reserve price, an unobserved cost of bidding, or an unobserved number

According to Narver and Slater (1990), market orientation is a broad organizational culture that helps companies performs the behaviors necessary for superior customer value

1.5 This standard provides rules that apply to permanent Radio Frequency Identification Devices (“RFIDs”) for cattle that are approved for use, under the National