Line of Service
Internal Firm Services
Industry/Sector
Not Applicable
Specialism
Advisory - Other
Management Level
Senior Associate
Job Description & Summary
At PwC, our people in data management focus on organising and maintaining data to enable accuracy and accessibility for effective decision-making. These individuals handle data governance, quality control, and data integration to support business operations.
In data governance at PwC, you will focus on establishing and maintaining policies and procedures to optimise the quality, integrity, and security of data. You will be responsible for optimising data management processes and mitigate risks associated with data usage.
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 Description/Activities to be performed:
- Working comprehensively with Azure Data Factory and Azure Cloud technologies with multiple data source systems on regular basis.
- Create and maintain optimal data pipelines in - On Premise SQL Server Infrastructure and Azure Cloud Environments.
- Responsible for expanding and optimizing data and data pipeline architecture as well as optimizing data flow and collection for cross functional utilization.
- Design, develop and deploy high volume ETL pipelines to manage complex and near-real time data collection
- Expertise working with SQL Server 2005/2008 R2/2012 tools Such as Management Studio, Query Analyzer, SQL Profiler, SQL Agent, SSIS and SSRS.
- Develop complex queries using sub queries and multiple joins.
- Work with the data management team and project leads to assist with data related technical issues, data analysis and support infrastructure needs
- Monitor Data Quality Controls/Remediate
- Data governance, version management, CI/CD deployments
Job Qualifications:
· 5 to 8 years of core hands on experience as a Data Engineer, developing, maintaining and optimising data pipelines in Azure and SQL Server infrastructure.
· Hand on with MS-SQL Server 2012/2008 R2/2008/2005, SQL Server Enterprise Manager, Transact-SQL T-SQL
· Core expertise in Azure Data Factory (ADF), and SQL Server Integration Services SSIS
· Handle common database procedures such as upgrade, backup, recovery, migration, etc.
· Advanced working knowledge and experience with relational databases and database administration/ management
· Ability to analyse and anticipate client requests, interpret asks and act according to expectations
· B Tech/M Tech M Sc (Math/ Stats) or equivalent from a premier institute
· Must have 4 to 6 years of on-the-job experience of working in Data Engineer profiles Required Skills
Optional Skills
Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Business Process Management (BPM), Communication, Corporate Governance, Creativity, Data Access Control, Database Administration, Data Governance Training, Data Processing, Data Processor, Data Quality, Data Quality Assessment, Data Quality Improvement Plans (DQIP), Data Stewardship, Data Stewardship Best Practices, Data Stewardship Frameworks, Data Warehouse Governance, Data Warehousing Optimization, Embracing Change, Emotional Regulation, Empathy, Inclusion {+ 16 more}
Desired Languages (If blank, desired languages not specified)
Travel Requirements
Up to 20%
Available for Work Visa Sponsorship?
No
Government Clearance Required?
No
Job Posting End Date
