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

• Apply a learning mindset and take ownership for your own development.
• Appreciate diverse perspectives, needs, and feelings of others.
• Adopt habits to sustain high performance and develop your potential.
• Actively listen, ask questions to check understanding, and clearly express ideas.
• Seek, reflect, act on, and give feedback.
• Gather information from a range of sources to analyse facts and discern patterns.
• Commit to understanding how the business works and building commercial awareness.
• Learn and apply professional and technical standards (e.g. refer to specific PwC tax and audit guidance), uphold the Firm's code of conduct and independence requirements.

The Opportunity

As part of the Data and Analytics team you design and implement data pipelines to extract, transform, and load (ETL) data from various sources into data storage systems. As an Associate you focus on learning and contributing to client engagement and projects while developing your skills and knowledge to deliver quality work. You collaborate with cross-functional teams to understand requirements and implement solutions, maintaining data quality, integrity, and dependability.

Responsibilities

- Designing and implementing data pipelines for ETL processes

- Collaborating with cross-functional teams to gather and understand requirements

- Ensuring data quality, integrity, and reliability in solutions

- Contributing to client engagement and project tasks

- Developing skills and knowledge to deliver work

- Utilizing analytical judgment to solve complex problems

- Supporting senior staff in various project activities

- Engaging in continuous learning and personal growth

What You Must Have

- Bachelor's Degree

- 3 years of experience with at least 1 year in Operate/Managed Services/Production Support

- SQL/PL-SQL

What Sets You Apart

- Informatica Power center certification

- Significant experience using Informatica Powercenter

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

- Building productive ETL/ELT processes using Informatica Power center

- Demonstrating experience with Data analytics tools like Informatica, SSIS, Alteryx etc.

- Designing, implementing, and maintaining data pipelines for data ingestion, processing, and transformation in Informatica

- 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

- Working with data scientists and analysts to understand the needs for data and create productive data workflows

- Collaborating with cross-functional teams to understand requirements and implement solutions

- Participating in data modeling and data migration tasks as per client requirements to build analytics implementation

- Implementing data validation and cleansing procedures to maintain the quality, integrity, and dependability of the data

- Improving the scalability, productivity, and cost-effectiveness of data pipelines

- Monitoring and troubleshooting data pipelines and resolving issues related to data processing, transformation, or storage

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

- Demonstrating advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases

- Building and maintaining Data Governance solutions (Data Quality, Metadata management, Lineage, Master Data Management and Data security) using industry leading tools

- Demonstrating experience with Data analytics tools like Informatica, Collibra, Hadoop, Spark, Snowflake etc.

- Demonstrating experience of ITIL processes like Incident management, Problem Management, Knowledge management, Release management, Data DevOps etc.

Learn more about how we work: https://pwc.to/how-we-work

PwC does not intend to hire experienced or entry level job seekers who will need, now or in the future, PwC sponsorship through the H-1B lottery, except as set forth within the following policy: https://pwc.to/H-1B-Lottery-Policy.

All qualified applicants will receive consideration for employment at PwC without regard to race; creed; color; religion; national origin; sex; age; disability; sexual orientation; gender identity or expression; genetic predisposition or carrier status; veteran, marital, or citizenship status; or any other status protected by law. PwC is proud to be an affirmative action and equal opportunity employer.

The salary range for this position is: $49,000 - $116,000, plus individuals may be eligible for an annual discretionary bonus. For roles that are based in Maryland, this is the listed salary range for this position. Actual compensation within the range will be dependent upon the individual's skills, experience, qualifications and location, and applicable employment laws. PwC offers a wide range of benefits, including medical, dental, vision, 401k, holiday pay, vacation and more. To view our benefits at a glance, please visit the following link: https://pwc.to/benefits-at-a-glance