Technology Consulting-BI Consultant-SA2-Shanghai

2 Months ago • 4 Years + • Legal

About the job

Job Description

This role requires a BI consultant with 4+ years of experience in database and management reporting visualization development. You'll design data warehouses, ETL processes, and develop dashboards and reports using Hive, Oracle, SQL Server, MySQL, and Hana. Strong SQL query optimization skills are essential.
Must have:
  • Database Development
  • Management Reporting
  • Data Warehouse
  • ETL Processes
Good to have:
  • Financial Knowledge
  • SQL Optimization
  • Data Governance
  • System Planning
Not hearing back from companies?
Unlock the secrets to a successful job application and accelerate your journey to your next opportunity.

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Application & Emerging Technology

Management Level

Senior Associate

Job Description & Summary

A career in our Advisory Acceleration Centre is the natural extension of PwC’s leading class global delivery capabilities. We provide premium, cost effective, high quality services that support process quality and delivery capability in support for client engagements.

To really stand out and make us fit for the future in a constantly changing world, each and every one of us at PwC needs to be a purpose-led and values-driven leader at every level. To help us achieve this we have the PwC Professional; our global leadership development framework. It gives us a single set of expectations across our lines, geographies and career paths, and provides transparency on the skills we need as individuals to be successful and progress in our careers, now and in the future.

As a Senior Associate, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. PwC Professional skills and responsibilities for this management level include but are not limited to:

  • Use feedback and reflection to develop self awareness, personal strengths and address development areas.
  • Delegate to others to provide stretch opportunities, coaching them to deliver results.
  • Demonstrate critical thinking and the ability to bring order to unstructured problems.
  • Use a broad range of tools and techniques to extract insights from current industry or sector trends.
  • Review your work and that of others for quality, accuracy and relevance.
  • Know how and when to use tools available for a given situation and can explain the reasons for this choice.
  • Seek and embrace opportunities which give exposure to different situations, environments and perspectives.
  • Use straightforward communication, in a structured way, when influencing and connecting with others.
  • Able to read situations and modify behavior to build quality relationships.
  • Uphold the firm's code of ethics and business conduct.

岗位职责:

1、根据客户管理报表的需求,建设企业数据仓库,相关数据治理,分析平台架构设计,以及前端可视化开发;

2、建立数据模型,设计数据仓库ETL作业流程;

3、前端可视化开发,包括管理驾驶舱、管理报表、自定义分析报表;

4、设计数据质量稽核规则保证数据质量。


任职资格:

1、4年以上数据库和管理报表可视化开发经验,有财务知识背景的优先;

2、计算机、数学、统计学或相关专业,本科以上学历;

3、具备BI系统规划能力,熟悉完整的系统建设流程与方法论;

4、精通Hive、Oracle、SQL Server、MySQL、Hana等主流数据库的应用设计;

5、有存储过程的开发能力,掌握SQL查询优化方法;
6、有良好的沟通、访谈、协调、文档编写技能.

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required:

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date

November 19, 2021

View Full Job Description

Add your resume

80%

Upload your resume, increase your shortlisting chances by 80%

About The Company

At PwC, our purpose is to build trust in society and solve important problems. We’re a network of firms in 152 countries with over 327,000 people who are committed to delivering quality in assurance, advisory and tax services. Find out more and tell us what matters to you by visiting us at www.pwc.com. PwC refers to the PwC network and/or one or more of its member firms, each of which is a separate legal entity.


Content on this page has been prepared for general information only and is not intended to be relied upon as accounting, tax or professional advice. Please reach out to your advisors for specific advice.

View All Jobs

Get notified when new jobs are added by PWC

Similar Jobs

Ness Digital - Full Stack Developer

Ness Digital, United States (Hybrid)

Discord - Group Product Manager, Machine Learning

Discord, United States (Remote)

Infinity Ward - 2025 US Summer Internship - Software Engineering

Infinity Ward, United States (On-Site)

Info Stretch - Engineering Lead - ETL Architecture

Info Stretch, India (On-Site)

NinjaVan - Legal Counsel

NinjaVan, Malaysia (On-Site)

PwC - Tax Consultant (m/f)

PwC, Slovakia (Hybrid)

PwC - Audit Associate

PwC, Sri Lanka (On-Site)

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Envestnet,  Inc  - Senior Engineer - QA

Envestnet, Inc , India (On-Site)

Animoca Brands - Backend Developer

Animoca Brands, South Korea (Remote)

Assystems - Développeur Full Stack Python H/F

Assystems, France (On-Site)

Abnormal Security - Software Engineer II - Fullstack

Abnormal Security, India (Hybrid)

Universal Music - React Engineer

Universal Music, United States (On-Site)

Luxoft - Site Reliability Engineer

Luxoft, Singapore (On-Site)

SSC Technologies - Operations Engineer - Senior Associate

SSC Technologies, India (On-Site)

Globalization Partners - Business Intelligence Analyst

Globalization Partners, (Remote)

Tencent - Data Scientist 103891

Tencent, United States (On-Site)

Get notifed when new similar jobs are uploaded

Jobs in Shanghai, Shanghai, China

Motphys - 游戏引擎开发

Motphys, China (On-Site)

Ubisoft - Senior Animator (Rainbow Six)

Ubisoft, China (On_site)

Virtuos - Senior Game Producer

Virtuos, China (On-Site)

Razer - Business Development Specialist

Razer, China (On-Site)

Publicis Groupe - UI Designer

Publicis Groupe, China (On_site)

Ubisoft - Rigger [Rainbow Six]

Ubisoft, China (On_site)

Virtuos - Technical Director

Virtuos, China (On-Site)

Get notifed when new similar jobs are uploaded

Legal Jobs

PwC - Deals, Merger & Acquisition - MA/SM

PwC, Singapore (On-Site)

Paypal - Sr. Director, Risk and Legal Comms

Paypal, United States (Hybrid)

HoYoverse - Intellectual Property Counsel

HoYoverse, Singapore (On-Site)

PwC - Asistente Senior Auditoria 2

PwC, Dominican Republic (On-Site)

SSC Technologies - Compliance Business Partner

SSC Technologies, Australia (On-Site)

PwC - Senior Associate - External Audit

PwC, Sri Lanka (On-Site)

Get notifed when new similar jobs are uploaded