Data Analyst

2 weeks ago


Camden, United Kingdom Great Ormond Street Hospital Charity Full time

Great Ormond Street Hospital (GOSH) is one of the world’s top children’s research hospitals. Children are referred from all over the UK and abroad in need of treatment for the most complex and threatening illnesses. Working in partnership with the UCLGreat Ormond Street Institute of Child Health, the hospital is the largest paediatric research and training centre in the UK and one of a small number of internationally recognised centres of excellence in the field of child health. Great Ormond Street HospitalChildren’s Charity exists to enable the hospital to reach its ambitions, providing world-class care for thousands of children facing life-threatening or life-shortening conditions.
The Data Analyst will be working on the CRM programme which is one of the largest programmes the charity has undertaken. The charity is currently working on a Salesforce implementation which will replace the current system (Raiser’s Edge). The project willtransform the way in which the charity operates from a day-to-day process level, and at the strategic level too.
The role is to work as part of the Data Migration team where, using the Agile delivery framework, you will analyse complex data sets, propose mappings for the data migration and test data once it has been loaded into the target schema.You will be experiencedwith the MS SQL Server platform, querying using T-SQL and be familiar with ERDs.
You will also be responsible for a number of items that may be holding up the Data Migration process and will work closely with Business Analysts and other stakeholders to resolve these items so that Data Migration can be as seamless as possible.
**Key relationships:**
Internal customers, Data Migration Partner, Project & Business Analysis Manager/CRM Project Manager, Peers, Database teams.
**Main duties and responsibilities:**:

- Enable our data migration partner to be able to carry out data migration seamlessly.
- Answer queries raised by our data migration partner.
- Identify appropriate test cases in order to test a data migration
- Carry out testing following a data migration
- Querying and aggregating data using T-SQL
- Be aware of, and ensure implementation during assignments of all relevant legislative, regulatory, audit and administrative standards adhered to by the charity.
- Chair and facilitate workshop or ‘fact finding’ meetings in order to properly analyse current and future data solutions.
- Adhere to and help maintain standards for data analysis.
- Perform any other relevant duties as required within the team.
- Positively contribute and work to team objectives.
- Adhere to the charity’s policies and procedures.

REF-201 754



  • Camden, United Kingdom GNB Partnership Full time

    **Marketing Data Analyst - Hybrid role** **Our Client** Our client is a global online brand, looking to hire a Marketing Data Analyst to support the delivery of data driven information to the marketing and product teams. This exciting and specialist role requires strong leaderships skills and excellent stakeholdermanagement. **The Role** As the Marketing...

  • Customer Data

    2 weeks ago


    Camden Area, United Kingdom Datatech Full time

    Customer Data & Insight Analyst - SQL£Negotiable dependant on experienceHybrid working from either London (Euston) or Central Birmingham officesReference J12773Are you a data professional with an interest in customer behaviour? Do you want to be the person who translates customer data into meaningful understanding that we can use to improve the customer...


  • Camden, United Kingdom James Gray Associates Full time

    * Workday knowledge - Hybrid/flexi working - London or Edinburgh Job Title: Payroll Cover Analyst (6-month FTC) **Salary**: £45k plus excellent benefits Location: Remote A highly successful entertainment company who are recruiting for a Payroll Cover Analyst to assist in all aspects of payroll processing and analytics, ensuring performance is maintained at...


  • Camden Town, United Kingdom Select Service Partner (Head Office) Full time

    SSP is a leading operator of food and beverage outlets in travel locations worldwide, with c.42,000 colleagues in over 600 locations across 37 countries.  We operate sit-down and quick service restaurants, cafes, lounges and food-led convenience stores, principally in airports and train stations, with a portfolio of around 550 international, national and...

  • Analyst - Beverages

    5 days ago


    Camden Town, Greater London, United Kingdom Select Service Partner (Head Office) Full time

    SSP is a leading operator of food and beverage outlets in travel locations worldwide, with c.We operate sit-down and quick service restaurants, cafes, lounges and food-led convenience stores, principally in airports and train stations, with a portfolio of around 550 international, national and local brands. These include our own brands Upper Crust, Millies...


  • Camden Town, Greater London, United Kingdom Select Service Partner (Head Office) Full time

    SSP is a leading operator of food and beverage outlets in travel locations worldwide, with c.We operate sit-down and quick service restaurants, cafes, lounges and food-led convenience stores, principally in airports and train stations, with a portfolio of around 550 international, national and local brands. These include our own brands Upper Crust, Millies...


  • Camden Town, Greater London, United Kingdom Select Service Partner (Head Office) Full time

    SSP is a leading operator of food and beverage outlets in travel locations worldwide, with c.42,000 colleagues in over 600 locations across 37 countries. We operate sit-down and quick service restaurants, cafes, lounges and food-led convenience stores, principally in airports and train stations, with a portfolio of around 550 international, national and...


  • Camden Town, Greater London, United Kingdom Select Service Partner (Head Office) Full time

    SSP is a leading operator of food and beverage outlets in travel locations worldwide, with c.42,000 colleagues in over 600 locations across 37 countries. We operate sit-down and quick service restaurants, cafes, lounges and food-led convenience stores, principally in airports and train stations, with a portfolio of around 550 international, national and...