We are currently looking for an experienced Senior Data Executive to join our CRM team. The data migration stream is integral to the success for our CRM v2.0 Project and its implementation of MS Dynamics CRM. As an important team member this role will be providing expertise on data structures, modelling techniques, and ETL’s for Migrations.
To work in the Data Migration work-stream of the CRM 2.0 project along with the external partners to:
Resolve data cleansing issues – through Data Quality Rules (DQRs)
Resolve mapping issues/queries with QBASE and Pythagoras
Work with Departments/Senior Managers in determining data owners and supporting them in making key data decisions
Provide guidance on matters of data structure and modelling best practice with focus on migration ETLs.
Assist in the writing of test cases for data loads
Test loading scripts into replacement transactional database.
Test extract, transform and loading scripts into MSD CRM 2013 and the new data warehouse.
Provide management dashboard reporting of status of data migration activities.
Excellent Data analysis Skills including SQL
Knowledge and Understanding of bulk data manipulation and import procedures
Demonstrable ability in the use of MS office applications including Access, Excel, Powerpoint and Visio.
Understanding of SQL and Visual Basic applications
Understanding of Test Processes Resolution of data cleansing
Test load scripts into replacement transactional database
Ideally demonstrate knowledge of charity database (preferably Raisers Edge)
In return we offer an excellent benefit package including Pension Scheme, Health Cash Plan, Childcare Vouchers and more.