Data Analytics Test Lead - 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 software and product innovation focus on developing cutting-edge software solutions and driving product innovation to meet the evolving needs of clients. These individuals combine technical experience with creative thinking to deliver innovative software products and solutions.

In testing and quality assurance at PwC, you will focus on the process of evaluating a system or software application to identify any defects, errors, or gaps in its functionality. Working in this area, you will execute various test cases and scenarios to validate that the system meets the specified requirements and performs as expected.

Enhancing your leadership style, you motivate, develop and inspire others to deliver quality. You are responsible for coaching, leveraging team member’s unique strengths, and managing performance to deliver on client expectations. With your growing knowledge of how business works, you play an important role in identifying opportunities that contribute to the success of our Firm. You are expected to lead with integrity and authenticity, articulating our purpose and values in a meaningful way. You embrace technology and innovation to enhance your delivery and encourage others to do the same.

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

• Analyse and identify the linkages and interactions between the component parts of an entire system.
• Take ownership of projects, ensuring their successful planning, budgeting, execution, and completion.
• Partner with team leadership to ensure collective ownership of quality, timelines, and deliverables.
• Develop skills outside your comfort zone, and encourage others to do the same.
• Effectively mentor others.
• Use the review of work as an opportunity to deepen the expertise of team members.
• Address conflicts or issues, engaging in difficult conversations with clients, team members and other stakeholders, escalating where appropriate.
• 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 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 Testing Managed Services team bring 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.

Job Description:

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 in the Managed Services Platform, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy through execution and beyond. PwC Professional skills and responsibilities for this level include but are not limited to:

• Design and implement automated tests to ensure consistent and accurate date processing.
• Validate source to target mapping and perform data reconciliation using SQL.
• Develop and execute comprehensive test plans and test cases for data pipelines, ETL processes and data transformations.
• Document test results, defect tracking, and QA reports in a clear and structured manner.  
• Design, build and maintain robust data queries using SQL for analytics and reporting.
• Interpret and analyze large datasets to identify trends, patterns and Opportunities.
• Collaborate with stakeholders to define business metrics and KPIs.
• Develop dashboards and reports using BI tools ( Power BI, Tableau,etc)
• Conduct deep-dive analysis and present findings to non-technical stakeholders.
• Ensure data quality and integrity across systems and reports.
• Automate repetitive analysis and streamline data workflows.
• Support data driven decisions-making across product, operations, marketing and finance teams.
• Should have a deep understanding of Data warehousing concepts.
• Should have a deep understanding of Data should be able connect the connections of Data being linked to different stages.
• Should have an basic knowledge on concepts of Data quality concepts.
• Work in a team environment that includes client interactions, workstream management, and cross-team collaboration. 
• Good Team player. Take up cross competency work and contribute to COE activities. 
• Escalation/Risk management. 

Minimum Degree Required: BE/BTech/MCA/M.Sc.

Degree Preferred:  Bachelors in Computer Engineering, Information Systems, Statistics or etc

Minimum Years of Experience:  6 year(s) of progressive roles managing IT quality assurance

Certifications Required: NA

Certifications Preferred:

Required Knowledge/Skills

• NA

Preferred Knowledge/Skills:

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

• Data Analytics concepts, SQL, ETL concepts, Python, Cloud platform (AWS/AZURE), JAVA core concepts, GITLAB
• Should have minimum of 3 year’s hands on experience in Data testing, Data quality Assurance or similar roles.
• Experience with test automation framework and scripting.( Python , Selenium BDD)  
• At least 2 years of experience working in Cloud (AWS), Agile, CI/CD.
• Experience in writing queries against databases and data warehouses in Oracle or SQL Server, MySQL, Postgres.
• Strong written/oral communication skills, problem resolution, good judgment, presentation, and decision-making skills required
• Prior experience of development or testing for Cloud Services. Experience with testing services in AWS/Azure/Google Cloud is a big plus
• Demonstrating experience in Agile practices, CI/CD pipeline, Best Practices and Procedures;
• Performing Data Mining, predictive modeling techniques and using data to drive business outcomes and decisions;
• Should have minimum 3 year’s hands on experience building advanced Data Analytics 
• Should have minimum 3 years’ hands on Experience ETL testing with strong emphasis on accuracy, reliability and data integrity. 
• Should have minimum 3 years’ hands on Experience in SQL for Data Handling, 
• Minimum 0-1 years of experience in Manual Testing 
• Should have understanding on core data concepts: Data ingestion, transformation, enrichment, quality, governance, lineage and design  
• Validating data fields, formats and utility using Quality Control checklists 
• Should have sound knowledge of snowflake data warehouse and Salesforce workbench for data management and reconciliation. 
• Ability to transform requirements and user stories into comprehensive test cases.  
• Strong foundation in data modelling principles, including database schemas, normalization and relationships.  
• Ability to define and develop test strategies, test plans, KPI’s, Metrics, Defect management processes and reporting mechanism. 
• Designing Test Cases, generate test data based on the requirements and project needs.  
• Familiarity with data quality frameworks and tools to enhance testing efficiency. 

Nice to have: 

• Certifications in ETL and other BI tools is an added advantage. 

• Tools knowledge: - Snowflakes, Qlik, Appflow, Ataccama or equivalent, Reltio

• Cloud platforms: AWS,AZURE 

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

Acceptance Testing, Acceptance Testing, Accepting Feedback, Active Listening, Analytical Thinking, Automated Testing, Automation Testing, Coaching and Feedback, Communication, Creativity, Data Model Testing, Debugging, Defect Management, Documentation Testing, Embracing Change, Emotional Regulation, Empathy, Fault Analysis, Functional Testing, Inclusion, Intellectual Curiosity, Learning Agility, Optimism, Performance Testing, Problem Diagnosis {+ 24 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

Yes

Job Posting End Date