IN-Senior Associate_Automation Database Devreloper_Data & Analytics_Advisory_PAN India

1 Month ago • 5-10 Years • Data Analyst

About the job

Summary

This Senior Associate role in PwC's Data and Analytics Advisory focuses on automation and database development. Responsibilities include extensive SQL Server experience (performance tuning, optimization, complex queries), proficiency in Azure Data Factory (ADF) for data integration and ETL processes, and expertise in T-SQL for advanced queries and stored procedures. Good knowledge of PL/SQL and experience as a SQL DBA are a plus. The ideal candidate will troubleshoot database and data pipeline issues and communicate effectively with technical and non-technical stakeholders. The role involves creating business intelligence from data using Rapid Business Intelligence Solutions, data visualization, and integrated reporting dashboards.
Must have:
  • Extensive SQL Server experience
  • Proficient in Azure Data Factory (ADF)
  • Proficient in T-SQL
  • Troubleshooting and resolving database issues
  • Excellent communication skills
Good to have:
  • PL/SQL knowledge
  • SQL DBA experience
Not hearing back from companies?
Unlock the secrets to a successful job application and accelerate your journey to your next opportunity.

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

Job Description & Summary

A career within Data and Analytics services will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations in order to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.

Creating business intelligence from data requires an understanding of the business, the data, and the technology used to store and analyse that data. Using our Rapid Business Intelligence Solutions, data visualisation and integrated reporting dashboards, we can deliver agile, highly interactive reporting and analytics that help our clients to more effectively run their business and understand what business questions can be answered and how to unlock the answers.

*Why PWC

At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us.

At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations. "

Responsibilities:
 

  • Extensive experience with SQL Server, including performance tuning, optimization, and complex query writing.
  • Proficient in Azure Data Factory (ADF) for data integration, ETL processes, and data flow management.
  • Proficient in T-SQL for writing advanced queries, stored procedures, and functions.
  • Knowledge of PL/SQL is a plus for handling Oracle database interactions.
  • Good to have experience as a SQL DBA, managing database security, backups, and recovery strategies.
  • Ability to troubleshoot and resolve database and data pipeline issues.
  • Excellent communication skills, both verbal and written, with the ability to convey technical concepts to non-technical stakeholders.
  • Self-motivated and proactive, with a commitment to delivering high-quality solutions.

Mandatory skill sets:

SQL. PL/SQL, T-SQL, SQL DBA

Preferred skill sets:

SQL. PL/SQL, T-SQL, SQL DBA

Years of experience required:

5-10 Years

Education qualification:

BE, B.Tech, MCA, M.Tech

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required: Bachelor Degree, Master of Engineering, Bachelor of Engineering

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Structured Query Language (SQL)

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date

View Full Job Description

About The Company

At PwC, our purpose is to build trust in society and solve important problems. We’re a network of firms in 152 countries with over 327,000 people who are committed to delivering quality in assurance, advisory and tax services. Find out more and tell us what matters to you by visiting us at www.pwc.com. PwC refers to the PwC network and/or one or more of its member firms, each of which is a separate legal entity.


Content on this page has been prepared for general information only and is not intended to be relied upon as accounting, tax or professional advice. Please reach out to your advisors for specific advice.

View All Jobs

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug