Data Warehouse Development Manager

British Council

Beijing
RMB¥12,000 per month
Contract
Full-time

1 month ago

We support peace and prosperity by building connections, understanding and trust between people in the UK and countries worldwide.We work directly with individuals to help them gain the skills, confidence and connections to transform their lives and shape a better world in partnership with the UK. We support them to build networks and explore creative ideas, to learn English, to get a high-quality education and to gain internationally recognised qualifications.Working with people in over 200 countries and territories, we are on the ground in more than 100 countries. In 2021-22 we reached 650 million people.Pay Band: 6 (from CNY 12,000 per month)
Country/Location: Beijing, China
Department: Exams
Contract Type: Fixed term contract (2 years)
Closing Date: Monday, 19 August 2024 - 23:59 China Time (GMT +8)Role Purpose:
Data Warehouse Development Manager is responsible for designing, developing, and maintaining data warehouse systems and related data marts to enable businesses to integrate, consolidate, and analyse vast amounts of data from various sources. Their primary goal is to facilitate better decision-making and business intelligence by ensuring that data is accessible, reliable, and timely.Accountabilities:
1. Design data warehouse and implement data warehouse architecture, including data marts, data models, and ETL (Extract, Transform, Load) processes.
2. Develop data pipelines and workflows for ingesting data from various sources into the data warehouse.
3. Optimize and maintain data warehouse performance for efficient data querying and reporting.
4. Create and manage ETL processes to integrate data from multiple sources, ensuring data quality and consistency.
5. Develop and maintain data dictionaries, and documentation for data warehouse and ETL processes.
6. Implement data quality checks and balances to ensure accuracy and integrity of data within the warehouse.
7. Assist in the development of reports, dashboards, and analytics solutions that leverage the data warehouse.
8. Provide technical support to business analysts and data scientists in accessing and analysing data warehouse contents.
9. Monitor data warehouse systems to ensure optimal performance and availability.
10. Troubleshoot and resolve issues related to data warehouse performance, ETL processes, and data integrity.
11. Work closely with business stakeholders to understand their data requirements and translate business needs into technical specifications.
12. Collaborate with IT teams, including system developer, data engineers and archecturer, to ensure seamless integration and alignment with overall IT infrastructure.Role specific knowledge and experience:
1. Experience in data warehouse development, including designing and implementing data models, ETL processes, and data warehousing strategies.
2. Demonstrated ability to work on complex data integration projects and deliver solutions that meet business requirements.
3. Proven experience in SQL, database design, ETL tools (such as Informatica, Talend, or SSIS), and data modeling tools, and skilled in cloud data warehouse technologies (e.g., Snowflake, Amazon Redshift, Google BigQuery) is a plus.
4. Proven experience in ETL processes for efficient data extraction, transformation, and loading. Well-acquainted with prominent ETL tools such as SSIS and Kettle.
5. Strong analytical and problem-solving skills to address data-related challenges and optimize data warehouse solutions.Role specific skills:
1. Good sense of business and operation logic, good communication skill and teamwork spirit.
2. Ability to drive issues to a robust closure in a timely manner.Requirements:

Education: Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field. Relevant certifications in data warehousing technologies and tools are advantageous.
Language: The British Council systems and global processes operate in English. Written and verbal proficiency in English is required.
Condition of Employment:

Locally Recruited
Applications are welcomed from candidates currently in this location with a natural right to work.
Applications are also welcomed from candidates currently based in other British Council country offices. However, please note candidates must have a natural right to work in the country, on a permanent basis, as immigration clearance and/or on-going visa support is not provided by the British Council for this role. Relocation support is also not provided.Benefits:

Annual Leaves (on a pro-rata basis if the service period is less than one full year); public holidays
Statutory benefits: national social insurance benefits and housing fund
Other benefits: commercial insurance package including accidental insurance, life insurance, and supplementary medical insurance
13th month salary: staff who pass the probation and work for minimum of 6 months in a year will be entitled to annual bonus in December
Performance-related pay: paid annually according to relevant performance review scheme
Professional development opportunities

A connected and trusted UK in a more connected and trusted world.Equality , Diversity, and Inclusion (EDI) StatementThe 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 emailPlease 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.

British Council

Apply Now