British CouncilHiring for Data Analyst – CRM 1 at Noida, Uttar Pradesh Full Time

Location: Noida, South Asia, IN

Company: British Council

The British Council builds connections, understanding and trust between people in the UK and other countries through arts and culture, education and the English language.

We work in two ways – directly with individuals to transform their lives, and with governments and partners to make a bigger difference for the longer term, creating benefit for millions of people all over the world. We help young people to gain the skills, confidence and connections they are looking for to realise their potential and to participate in strong and inclusive communities. We support them to learn English, to get a high-quality education and to gain internationally recognised qualifications. Our work in arts and culture stimulates creative expression and exchange and nurtures creative enterprise. We connect the best of the UK with the world and the best of the world with the UK.

These connections lead to an understanding of each other’s strengths and of the challenges and values that we share. This builds trust between people in the UK and other nations which endures even when official relations may be strained. We work on the ground in more than 100 countries. In 2019-20 we connected with 80 million people directly and with 791 million overall, including online and through our broadcasts and publications.

Job Title:Data Analyst – CRM 1

Purpose of job:
Responsible for delivering against defined data initiatives within the ‘Technical, reporting and data’ stream within CRM Operations team, in support of the initiatives of the CRM system within the British Council. Specifically, to prepare data for upload, upload, add, delete, amend, merge, restructure and migrate data, and to deliver regular reporting from the CRM system.

This is a hands-on job to support the work of our data team.

Role context

The British Council launched Global (Salesforce) CRM as a global solution in 2011. There are currently around 1700 regular users across 50+ locations. To date, the majority of our users have worked in customer service or consumer sales, and the need to ‘prepare data for upload, upload, add, delete, amend, merge, restructure and migrate data’ has been limited. However, in May 2018, we re-launched CRM for use by British Council staff in business-to-business (‘B2B’) and business-to-government (‘B2G’) roles, and this involves significant data support work through to the end of the current CRM programme, in October 2019.

One key initiative for the re-launch is to clean up and restructure existing ‘B2B/G’ data (several thousand records) that have built up over the last five years in a largely unmanaged way. Going forward, the main focus will, however, be on working with data currently in Excel spreadsheets or Outlook, cleaning that data for upload, uploading said data, and addressing duplication/merging issues arising in those uploads. In addition, there will be a need to assist the data lead in migrating data from other systems into Global CRM.

The British Council is the UK’s international organisation for cultural relations and educational opportunities. We create friendly knowledge and understanding between the people of the UK and other countries. We do this by making a positive contribution to the UK and the countries we work with – changing lives by creating opportunities, building connections and engendering trust.

We work with over 100 countries across the world in the fields of arts and culture, English language, education and civil society. Each year we reach over 20 million people face-to-face and more than 500 million people online, via broadcasts and publications. Founded in 1934, we are a UK charity governed by Royal Charter and a UK public body.

Equality, Diversity & Inclusion:
The British Council is committed to a policy of equal opportunity and welcomes applicants from all sections of the community. We work to ensure that people are not unjustifiably discriminated against on the basis of gender, including transgender, marital status, sexual identity, religion and belief, political opinion, race, work pattern, age, disability or HIV/AIDS status, socio-economic background, spent convictions, trade union activity or membership, on the basis of having or not having dependants, or any other irrelevant grounds.

Main opportunities/challenges for this role

Accountabilities, responsibilities and main duties:
Experience in building models using data from Salesforce is required

Lead development, implementation and continuous improvement of models and strategies; Leverage in-house, external and other open-source machine learning software/algorithms;

Assemble large, complex data sets that meet functional/non-functional business requirements

Identify, design and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Experience in Power BI , MS Azure and Google Analytics.

Benchmark models against existing Salesforce predictive tools. Experience in Data Modelling, R, Python, SQL, Data Science, Machine Learning, Deep Learning, Statistics.

Support and collaborate on the infrastructure required for optimal extraction, transformation and loading data from a wide variety of data sources using SQL.

Work with internal customers to understand their needs and author and define implementation plans and functional specifications that solve those needs.

Regularly assess and improve ones own performance in areas such as job knowledge, technical skills, productivity, accountability, quality, initiative, innovation, drive, working relationships, communications, leadership.

Mentor juniors in the team using your experience / expertise.

Perform database management, data mining, merging, duplicate management and running queries for the British Council’s CRM and publish dashboards and reports for user and senior management.

Undertake report writing and maintenance of folders, dashboard creation and maintenance, tracking of user change requests, data processing prior to upload and create process documentation on reporting and data requirements.

The role will entail recurring and ad-hoc analytics to analyse and measure various Salesforce CRM related adoption and data integrity metrics to enable business decision making. The analytics would range from simple Salesforce object analysis to sustain and strengthen data integrity to complex adoption analytics in the form of reports / dashboards, both within and outside Salesforce (third party apps), to help business track user trends and preferences.

Work with management to identify new and creative opportunities to leverage the database to support additional business processes or functions.

Key relationships:
Salesforce Administrators, Technical Service Delivery Manager, Senior Manager’s, Service Owner, Service Line Owner, CRM users, CRM implementation Team.

Qualifications

University Graduate

Certifications:
Salesforce ADM201

ITIL Service Management Foundation Certificate

Role specific knowledge and experience

Work Experience: Overall work experience of 7+ years in IT.

Technical Support Skills

Expert and in-depth knowledge of Salesforce from a systems administration perspective

+18 months Salesforce Administrator

Understanding of relational databases and data integration tools.

Experience with programming languages such as .NET C# and VB, AJAX, ASP, VB, CSS, SQL is a plus

Database and reporting skills.

Understanding of data concepts and data manipulation

Design & Development Skills

Have knowledge of the web architecture, SAAS architecture, Database design and query architecture. Customises, scripts, packages, tests, debugs, and documents simple software programs or modules to a clear design specification as part of a software/web application. Assists in design and provides input into project plans.

Process skills: More than 3 years’ experience of having worked on the Incident/Change/Release process in an ITIL environment.

Further Information

Pay Band – 7

Contract Type – Indefinite

Department/Country- GIS NON-SAP- Noida

Closing Date (Time) – 04th Jul 22 (IST -23:59)

A connected and trusted UK in a more connected and trusted world.

Equality , Diversity, and Inclusion (EDI) Statement

The British Council is committed to policies and practices of equality, diversity and inclusion across everything we do. We support all staff to make sure their behaviour is consistent with this commitment. We want to address under representation and encourage applicants from under-represented groups, in particular, but not exclusively, on grounds of ethnicity and disability. All disabled applicants who meet the essential criteria are guaranteed an interview and we have Disability Confident Employer Status. We welcome discussions about specific requirements or adjustments to enable participation and engagement in our work and activities.

The British Council is committed to safeguarding children, young people and adults who we work with.

We believe that all children and adults everywhere in the world deserve to live in safe environments and have the right to be protected from all forms of abuse, maltreatment and exploitation as set out in article 19, UNCRC (United Nations Convention on the Rights of the Child) 1989.

Appointment to positions where there is direct involvement with vulnerable groups will be dependent on thorough checks being completed; these will include qualification checks, reference checks, identity & criminal record checks in line with legal requirements and with the British Council’s Safeguarding policies for Adults and Children.

If you have any problems with your application please email askhr@britishcouncil.org

Please note: Applications to this role can only be considered when made through the Apply section of our careers website. Our ‘ASK HR’ email is only to be used in case of a technical issue encountered when applying through the careers website. Emails with supporting statements and CV/Resumes sent to this email address will not be reviewed and will be deleted.