Job Description

Line of Service Internal Firm ServicesIndustry/Sector Not ApplicableSpecialism Advisory - OtherManagement Level Senior Associate & 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 isnxe2x80x99t 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.

/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:xc2xb7 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.xc2xb7 Hand on with MS-SQL Server 2012/2008 R2/2008/2005, SQL Server Enterprise Manager, Transact-SQL T-SQLxc2xb7 Core expertise in Azure Data Factory (ADF), and SQL Server Integration Services SSISxc2xb7 Handle common database procedures such as upgrade, backup, recovery, migration, etc.xc2xb7 Advanced working knowledge and experience with relational databases and database administration/ managementxc2xb7 Ability to analyse and anticipate client requests, interpret asks and act according to expectationsxc2xb7 B Tech/M Tech M Sc (Math/ Stats) or equivalent from a premier institutexc2xb7 Must have 4 to 6 years of on-the-job experience of working in Data Engineer profilesEducation (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 SkillsOptional 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? NoGovernment Clearance Required? NoJob Posting End Date

PwC