Data Analyst

Date: 02-Jul-2022

Location: Beijing, East Asia, CN

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.


Contract: 2 years, fixed term contract
Location: Beijing, China
Salary: Pay Band 6/G (starts from CNY 12,000 per month)
Start Date: ASAP
Closing Date: 7 July 2022 - 23:59 China Time (GMT +8)

Role Purpose

Data analyst will work with data insight manager to support data warehouse and Power BI based data analysis platform. Make sure the business insight is accurately and timely presented to business management team.
Role Context
The Exams Systems team is a key part of the China Exams team. It provides IT solutions, digitalization service, and technical support to exams operations in China.
This role will cooperate with external consulting vendors and operate cross team working.

Main accountabilities but not limited to the following: 
•    Understand business working procedure and design data product.
•    Support business users as a technique expert from data perspective.
•    Design data processing platform. Integrate, clean and transform data from different data source and format to the central data warehouse.
•    Develop and test reports/dashboards based on Power BI platform.
•    Innovate new data product.


•    The British Council systems and global processes operate in English. Written and verbal proficiency in English is required.
•    Bachelor’s Degree in computer science, Software Engineering, information management or statistics.


Role specific knowledge and experience:
•    4 years and above working and project experience of business intelligence development.
•    Expert in database design and development, SQL language
•    Expert in data warehouse design and implementation and ETL process. Familiar with mainstream ETL tool like SSIS and Kettle.
•    Mainstream visualization tool like Power BI

•    Annual leave and public holidays
•    Statutory benefits
•    Commercial insurance package including accidental insurance, life insurance, and supplementary medical insurance Provident Fund – if applicable
•    Professional development opportunities – we offer a broad range of professional courses to large corporations and that is available for our staff members too! 

Additional Information
Job holder must have the right to live and work in China.



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


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.