Senior Data Engineer -Analytics as a Service - Senior Associate - operate

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Managed Services

Management Level

Senior Associate

Job Description & Summary

At PwC, our people in managed services focus on a variety of outsourced solutions and support clients across numerous functions. These individuals help organisations streamline their operations, reduce costs, and improve efficiency by managing key processes and functions on their behalf. They are skilled in project management, technology, and process optimization to deliver high-quality services to clients.

Those in managed service management and strategy at PwC will focus on transitioning and running services, along with managing delivery teams, programmes, commercials, performance and delivery risk. Your work will involve the process of continuous improvement and optimising of the managed services process, tools and services.

Focused on relationships, you are building meaningful client connections, and learning how to manage and inspire others. Navigating increasingly complex situations, you are growing your personal brand, deepening technical expertise and awareness of your strengths. You are expected to anticipate the needs of your teams and clients, and to deliver quality. Embracing increased ambiguity, you are comfortable when the path forward isn’t clear, you ask questions, and you use these moments as opportunities to grow.

Examples of the skills, knowledge, and experiences you need to lead and deliver value at this level include but are not limited to:

• Respond effectively to the diverse perspectives, needs, and feelings of others.
• Use a broad range of tools, methodologies and techniques to generate new ideas and solve problems.
• Use critical thinking to break down complex concepts.
• Understand the broader objectives of your project or role and how your work fits into the overall strategy.
• Develop a deeper understanding of the business context and how it is changing.
• Use reflection to develop self awareness, enhance strengths and address development areas.
• Interpret data to inform insights and recommendations.
• Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance), the Firm's code of conduct, and independence requirements.

Job Summary -   

A career in our Managed Services team will provide you with an opportunity to collaborate with a wide array of teams to help our clients implement and operate new capabilities, achieve operational efficiencies, and harness the power of technology. Our Data, Testing & Analytics as a Service team brings a unique combination of industry expertise, technology, data management and managed services experience to create sustained outcomes for our clients and improve business performance. We empower companies to transform their approach to analytics and insights while building your skills in exciting new directions. Have a voice at our table to help design, build and operate the next generation of software and services that manage interactions across all aspects of the value chain. 

 

Minimum Degree Required (BQ) *:  

Bachelor's degree  

 

Degree Preferred:   

 

Required Field(s) of Study (BQ):   

 

Preferred Field(s) of Study:  

Computer and Information Science, Management Information Systems 

  

Minimum Year(s) of Experience (BQ) *: US 

 

Minimum of 3 years of experience 

 

Certification(s) Preferred:  

 

  

Required Knowledge/Skills (BQ): 

 

Preferred Knowledge/Skills *:  

 

Required Skills: 

Informatica Power Centre, SQL/PL-SQL 

Job description: 

  

Candidate is expected to demonstrate extensive knowledge and/or a proven record of success in the following areas:  

• Should have a minimum 6 years hand on experience building advanced Data warehousing solutions on leading relational or cloud platforms. 

• Should have minimum 3-5 years of Operate/Managed Services/Production Support Experience  

• Should have extensive experience in developing scalable, repeatable, and secure data structures and pipelines to ingest, store, collect, standardize, and integrate data for downstream consumption like Business Intelligence systems, Analytics modeling, Data scientists etc.  

• Designing and implementing data pipelines to extract, transform, and load (ETL/ELT) data from various sources into data storage systems, such as data warehouses or data lakes.  

• Should have experience in building efficient ETL/ELT processes using Informatica 10.x or above. Informatica BDM is a plus 

• Troubleshoot and resolve issues related to data quality, data load failures, and performance bottlenecks using Informatica and SQL/PL-SQL. 

• Implementing data validation and cleansing procedures will ensure the quality, integrity, and dependability of the data. 

• Improve the scalability, efficiency, and cost-effectiveness of data pipelines. 

• Write complex SQL queries for large-scale data extraction, transformation and reporting 

• Implementing and maintaining data security and privacy measures, including access controls and encryption, to protect sensitive data  

• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases  

• Should have experience in Building and maintaining Data Governance solutions (Data Quality, Metadata management, Lineage, Master Data Management and Data security) using industry leading tools  

• Scaling and optimizing schema and performance tuning SQL and ETL/ELT pipelines in data lake and data warehouse environments.  

• Should have Hands-on experience with Data analytics tools like Informatica, SSIS, Alteryx etc.  

• Should have Experience of ITIL processes like Incident management, Problem Management, Knowledge management, Release management, Data DevOps etc.  

• Should have Strong communication, problem solving, quantitative and analytical abilities. 

Nice to have: 

• Informatica Power Centre certification 

 

 

 

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

Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Automation, Automation Framework Design and Development, Automation Solutions, Budgetary Management, Business Process Automation (BPA), Business Process Improvement, Business Process Outsourcing, Business Transformation, Communication, Continuous Process Improvement, Creativity, Data Quality Automation, Deliverable Planning, Delivery Excellence, Design Automation, Digital Transformation, Embracing Change, Emotional Regulation, Empathy, Inclusion, Intellectual Curiosity {+ 24 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

0%

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date