Job Details
Industry/Sector: Not Applicable
Time Type: Full time
Travel Requirements: Up to 40%
At PwC, our people in data and analytics focus on leveraging data to drive insights and make informed business decisions. They utilise advanced analytics techniques to help clients optimise their operations and achieve their strategic goals. In business intelligence at PwC, you will focus on leveraging data and analytics to provide strategic insights and drive informed decision-making for clients. You will develop and implement innovative solutions to optimise business performance and enhance competitive advantage.
Driven by curiosity, you are a reliable, contributing member of a team. In our fast-paced environment, you are expected to adapt to working with a variety of clients and team members, each presenting varying challenges and scope. Every experience is an opportunity to learn and grow. You are expected to take ownership and consistently deliver quality work that drives value for our clients and success as a team. As you navigate through the Firm, you build a brand for yourself, opening doors to more opportunities.
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