Data Engineer - Senior Associate

About this role

Line of Service
Internal Firm Services

Industry/Sector
Not Applicable

Specialism
IFS - Operations

Management Level
Senior Associate

Job Description & Summary
A career in National Special Functions, within Internal Firm Services, will provide you with the opportunity to support service, sector, and market leaders deliver the unique PwC client experience to our clients. You'll play an important part in continuously innovating and improving Firm operations so that we can continue to provide the highest quality of services to our current and prospective clients.

Our Analytics Insights team is responsible for serving as a strategic business partner for an assigned customer to identify and pursue new opportunities, conduct market analysis, and prepare revenue projections. You'll also develop new service offerings and solutions, enhance existing delivery capabilities, and support the delivery of solutions on engagements.


Job Function Overview

The Data Engineer role in the Performance Comms team is responsible for expanding and optimizing data and data pipeline architecture as well as optimizing data flow and collection for cross functional utilization. The ideal candidate is an experienced data pipeline builder who enjoys optimizing data systems and building them from the ground up. They must be self-directed, driven and comfortable supporting the data needs of multiple teams, systems and products.

What You will do

● Create and maintain optimal data pipeline architecture

● Identify, design and implement internal process improvements, automating manual processes, optimizing data delivery, re-designing infrastructure for scalability

● Design, develop and deploy high volume ETL pipelines to manage complex and near-real time data collection

● Work with the data management team and project leads to assist with data related technical issues and support infrastructure needs

Preferred Knowledge/ Skills:

● Experience with M365 Power Platform capabilities, including Dataverse, Power Apps and Power Automate

● Hands on experience with integration between the Power Platform services such as embedding Power BI Reports within PowerApps solutions, triggering Power Automate flows from Power Apps solutions to Dataverse or Power BI dashboards and embedding Power Apps visuals within Power BI reports

● Applied automation & ETL experience using tools like Power Query, Power Automate, and Alteryx

● Advanced working knowledge and experience with relational databases (SQL, Dataverse) or data warehouses (Google BigQuery), and database administration/ management

● A successful history of manipulating, processing and extracting value from large disconnected data sets

● Proficient designing, implementing custom REST-ful APIs for usage in integrations with cloud/web-based 3rd party applications

● Adept at consuming 3rd party web-based APIs and integration endpoints (REST-ful, SFTP file transfer, etc.)

● Familiarity with enterprise productivity tools including Microsoft Office Suite and Google platforms and other project management software

● Strong business and technical acumen

● Strong problem solving, communication and follow-up skills

● Ability to navigate complexity and ambiguity, practicing resourcefulness to see things through

● Identifying and keeping up with industry leading best practices in relevant technical domains

About the team

CommTech & Performance Comms: Wrangle and analyze data to produce intelligence and insights, guiding strategic decision-making and measuring our impact.

Exp Level 4-8 years
 

Required Skills

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements
Not Specified

Available for Work Visa Sponsorship?
No

Government Clearance Required?
No

Job Posting End Date