Data Engineer - Senior Associate

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.

Skills

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