Technology Consulting-BI Consultant-SA2-Shanghai

2 Months ago • 4 Years + • Legal

About the job

Summary

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

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

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug