Acceleration Centers Products & Tech, Data Engineer, Senior Associate

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Advisory - Other

Management Level

Senior Associate

Job Description & Summary

A career in Products and Technology is an opportunity to bring PwC's strategy to life by driving products and technology into everything we deliver. Our clients expect us to bring the right people and the right technology to solve their biggest problems; Products and Technology is here to help PwC meet that challenge and accelerate the growth of our business. We have skilled technologists, data scientists, product managers and business strategists who are using technology to accelerate change.

Our team establishes and builds processes and structures based on business and technical requirements to channel data from multiple inputs, route appropriately and store using any combination of distributed (cloud) structures, local databases, and other applicable storage forms as required. We develop the data sets and pipelines that will support analysis and model development including improving data quality, integration of disparate data sources, enhancement of data, transformation of data and development of performant infrastructure for access and reporting. As well, we design, build and oversee the deployment and operation of technology architecture, solutions and software to capture, manage, store and utilize structured and unstructured data from internal and external sources.

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 an authentic and inclusive leader, at all grades/levels and in all lines of service. 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 and coach to help deliver results.
• Develop new ideas and propose innovative solutions to problems.
• Use a broad range of tools and techniques to extract insights from from current trends in business area.
• Review your work and that of others for quality, accuracy and relevance.
• Share relevant thought leadership.
• Use straightforward communication, in a structured way, when influencing others.
• Able to read situations and modify behavior to build quality, diverse relationships.
• Uphold the firm's code of ethics and business conduct.

PwC Digital  is focused on standardizing, automating, delivering tools and processes and exploring emerging technologies that drive efficiency and enable our people to reimagine the possible. We are seeking talented and passionate administrators with deep understanding of data management, data transformation and engineering, data quality and data analytics. You will be part of a team comfortable performing tasks at any level of the technology stack ranging from Data Engineering to administration.

Job Requirements and Preferences: 

Basic Qualifications: 

Minimum Degree Required:  Bachelor Degree

Additional Educational Requirements: 

In lieu of a Bachelor Degree, 5 years of professional experience involving technology-focused process improvements, transformations, and/or system implementations

Minimum Years of Experience:  5 year(s) 

Oral and written English proficiency required

Preferred Qualifications: 

Degree Preferred:  Bachelor Degree

Preferred Fields of Study:  Computer and Information Science, Database Administration, Management Information Systems, Software App, Cloud technologies.

Preferred Knowledge/Skills: 

Demonstrates through knowledge and/or a proven record of success in the following areas:

• Working within product/solution teams to build data models and data transformation/integration routines/services;

• Having knowledge of data architecture and data management;

• Having knowledge of database fundamentals and data modeling;

• Having an understanding of ODS, data warehouse, data mart, and data cube, and database technologies;

• Having the ability to recognize and identify patterns in data relationships from disparate systems;

• Analyzing source systems and develop processes to extract, transform and load (ETL/ELT) this data into the target platforms;

• Having experience in building complex, highly scalable, high volume and low latency analytics solutions;

• Having extensive experience with RDBMS (SQLServer, Azure SQL, PostgreSQL), NoSQL (MongoDB) and/or other database technologies (Neo4j);

• Creating data integration using iPaaS tools, ADF, Snap Logic etc., and work with the team and vendor to create and evolve scalable data integration solutions;

• Having experience programing with Python, Spark, pySpark will be an advantage; 

• Understanding, creating and implementing process design and target data models;

• Developing, test and debug and document ETL and data integration process. Ensure data integrity of sensitive data;

• Addressing performance, high availability, high scalability and data quality issues;

• Demonstrating some knowledge/experience with data analytic, visualization and virtualization  tools (Dremio, PowerBI a plus);

• Demonstrating ability to conceptualize Azure infrastructure and understand the prescribed design architecture;

• Key:

  • Big data architecture and strategy

  • Data modeling - Relational databases, non-relational databases, columnar databases

  • Data quality

  • Data transformation - Alteryx, Azure Data Factory, Azure Databricks, Python, PySpark

  • Relational databases - Azure SQL, PostgreSQL

  • NoSQL databases - MongoDB, Cosmos DB

  • Big data - Snowflake

  • Data storage - Azure Data Lake Storage

Demonstrates thorough abilities and/or a proven record of success in the following areas:

• Documentation of processes and procedures

• Ability to resolve user requests and inquiries in a timely manner

• Perform root cause analysis and troubleshooting of various issues

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

Up to 20%

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date

Products and Technology