National Citizen Service Trust
London, UK
Data Operations Analyst - National Citizen Service Trust London
A great opportunity has arisen for a Data Operations Analyst to join our team at National Citizen Services in London. This is the perfect opportunity if you are looking to take the next step up in your career and work across the full data life cycle, whilst learning new tools such as Salesforce Einstein Analytics.
Organisation and programme
National Citizen Service (NCS) is a government-backed programme established in 2011 to help build a more cohesive, mobile and engaged society. By bringing together young people from different backgrounds for a unique shared experience, NCS helps them to become better individuals and, in turn, better citizens with a greater sense of purpose, optimism and belonging.
The programme, which lasts from two to four weeks during school holidays, is open to 16 to 17 year olds across England and Northern Ireland. It includes outdoor team-building exercises, a residential for participants to learn ‘life skills’, a community-based social action project, and an end of programme celebration event.
National Citizen Service Trust is a not-for-profit organisation incorporated by Royal Charter and established to shape, support, champion, and lead a thriving National Citizen Service. National Citizen Service Trust is registered in England and Wales with Royal Charter Body number RC000894. Our registered office is at The Pembroke Building, Kensington Village, Avonmore Road, London, W14 8DG.
Role Description
Situated within the Trust’s Central Data and Analytics (CD&A) team, the Data Operations Analyst will:
Support the Data Operation Specialist in designing and implementing data projects for the NCS Trust to ensure the availability of data for reporting and analytics purposes
Help design, implement and test the extraction, transformation and load (ETL) of any data into the Trust’s Salesforce Next Generation platform, e.g. when migrating data from legacy systems
Build and test data flows between the Trust’s core Salesforce platform and the Einstein Analytics BI tool
Support the build of any other data integrations between the Trust’s IT system
Create and maintain source-to-target mappings for any data integrations developed
Document and catalogue resulting data assets developed by the Trust to ensure they are clearly understood by reporting and analytics users
Work collaboratively with the Data Assurance team to carry out data fixes where data quality issues have been identified
Person Specification
Experience
Minimum of 2 years’ experience in a related role, e.g. database administrator, ETL developer or data engineer (essential)
Experience manipulating large data sets using enterprise applications (e.g. using DB queries, from operational reporting systems, using ETL tools) (essential)
Experience in profiling data to identify approaches to data integration design (essential)
Proven track-record of delivery of data assets incl. build, testing and documentation (essential)
Understanding of data modelling and data architecture (desirable)
Familiarity with Salesforce CRM (desirable)
Skills & Attributes
High level of accuracy and attention to detail (essential)
Eager to learn about new technologies, in a self-taught fashion if required (essential)
Comfortable executing BAU activities with a creative approach to designing improvements (essential)
Ability to work collaboratively with other members of the CD&A and wider Information Services team (essential)
Core SFIA Competencies
Data Modelling and Design DTAN: Level 3 - Applies data analysis, design, modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions). Advises database designers and other application development team members on the details of data structures and associated components.
Database Design DBDS: Level 3 - Develops appropriate physical database or data warehouse design elements, within set policies, to meet business change or development project data requirements. Interprets installation standards to meet project needs and produces database or data warehouse component specifications.
Further Information
Offer type: This is a permanent, full-time role.
Remuneration: Salary for this role is competitive, dependent upon skills and experience.
Locatio n: The role is based in the Earls Court neighbourhood, West London, with occasional travel to other NCS offices.
If you need any further information please contact Arabella Grainger, People Recruitment Business Partner on arabellagrainger@ncstrust.org.uk
Learn about NCS on www.ncsyes.co.uk
How to apply:
Please send your CV to Arabella Grainger - arabellagrainger@ncstrust.org.uk
Your covering email should:
Include the job title in the subject line
Make clear the role you are applying for
Outline how you satisfy the specific experience, skills and attributes elements listed
Say what attracts you to us and this role
The deadline for applications is October 18th, 2019.
Your personal data will always be treated in confidence. NCS Trust is an equal opportunities employer, embracing diversity and inclusion.
Data Operations Analyst - National Citizen Service Trust London
A great opportunity has arisen for a Data Operations Analyst to join our team at National Citizen Services in London. This is the perfect opportunity if you are looking to take the next step up in your career and work across the full data life cycle, whilst learning new tools such as Salesforce Einstein Analytics.
Organisation and programme
National Citizen Service (NCS) is a government-backed programme established in 2011 to help build a more cohesive, mobile and engaged society. By bringing together young people from different backgrounds for a unique shared experience, NCS helps them to become better individuals and, in turn, better citizens with a greater sense of purpose, optimism and belonging.
The programme, which lasts from two to four weeks during school holidays, is open to 16 to 17 year olds across England and Northern Ireland. It includes outdoor team-building exercises, a residential for participants to learn ‘life skills’, a community-based social action project, and an end of programme celebration event.
National Citizen Service Trust is a not-for-profit organisation incorporated by Royal Charter and established to shape, support, champion, and lead a thriving National Citizen Service. National Citizen Service Trust is registered in England and Wales with Royal Charter Body number RC000894. Our registered office is at The Pembroke Building, Kensington Village, Avonmore Road, London, W14 8DG.
Role Description
Situated within the Trust’s Central Data and Analytics (CD&A) team, the Data Operations Analyst will:
Support the Data Operation Specialist in designing and implementing data projects for the NCS Trust to ensure the availability of data for reporting and analytics purposes
Help design, implement and test the extraction, transformation and load (ETL) of any data into the Trust’s Salesforce Next Generation platform, e.g. when migrating data from legacy systems
Build and test data flows between the Trust’s core Salesforce platform and the Einstein Analytics BI tool
Support the build of any other data integrations between the Trust’s IT system
Create and maintain source-to-target mappings for any data integrations developed
Document and catalogue resulting data assets developed by the Trust to ensure they are clearly understood by reporting and analytics users
Work collaboratively with the Data Assurance team to carry out data fixes where data quality issues have been identified
Person Specification
Experience
Minimum of 2 years’ experience in a related role, e.g. database administrator, ETL developer or data engineer (essential)
Experience manipulating large data sets using enterprise applications (e.g. using DB queries, from operational reporting systems, using ETL tools) (essential)
Experience in profiling data to identify approaches to data integration design (essential)
Proven track-record of delivery of data assets incl. build, testing and documentation (essential)
Understanding of data modelling and data architecture (desirable)
Familiarity with Salesforce CRM (desirable)
Skills & Attributes
High level of accuracy and attention to detail (essential)
Eager to learn about new technologies, in a self-taught fashion if required (essential)
Comfortable executing BAU activities with a creative approach to designing improvements (essential)
Ability to work collaboratively with other members of the CD&A and wider Information Services team (essential)
Core SFIA Competencies
Data Modelling and Design DTAN: Level 3 - Applies data analysis, design, modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions). Advises database designers and other application development team members on the details of data structures and associated components.
Database Design DBDS: Level 3 - Develops appropriate physical database or data warehouse design elements, within set policies, to meet business change or development project data requirements. Interprets installation standards to meet project needs and produces database or data warehouse component specifications.
Further Information
Offer type: This is a permanent, full-time role.
Remuneration: Salary for this role is competitive, dependent upon skills and experience.
Locatio n: The role is based in the Earls Court neighbourhood, West London, with occasional travel to other NCS offices.
If you need any further information please contact Arabella Grainger, People Recruitment Business Partner on arabellagrainger@ncstrust.org.uk
Learn about NCS on www.ncsyes.co.uk
How to apply:
Please send your CV to Arabella Grainger - arabellagrainger@ncstrust.org.uk
Your covering email should:
Include the job title in the subject line
Make clear the role you are applying for
Outline how you satisfy the specific experience, skills and attributes elements listed
Say what attracts you to us and this role
The deadline for applications is October 18th, 2019.
Your personal data will always be treated in confidence. NCS Trust is an equal opportunities employer, embracing diversity and inclusion.
