Line of Service Advisory Industry Sector Not Applicable Specialism Data Analytics AI Management Level Senior Associate Summary 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 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 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 Summary A career within Responsibilities Design develop and maintain scalable data pipelines using Azure data services such as Azure Data Factory and Apache Spark Implement efficient Extract Transform Load ETL processes to move and transform data across various sources Design develop and maintain data solutions using Azure Synapse Analytics Implement data ingestion transformation and extraction processes using Azure Synapse Pipelines Knowledge about data warehousing concepts Utilize Azure SQL Database Azure Blob Storage Azure Data Lake Storage and other Azure data services to store and retrieve data Performance optimization and troubleshooting capabilities Advanced SQL knowledge capable to write optimized queries for faster data workflows Proven work experience in Spark Python SQL Any RDBMS Experience in designing solutions for multiple large data warehouses with a good understanding of cluster and parallel architecture as well as high-scale or distributed RDBMS Must be extremely well versed with handling large volume data and work using different tools to derive the required solution Mandatory skill sets Hands-on experience in ADF or Synapse Analytics Proficiency in Python for data processing and scripting Solid command over SQL - writing complex queries performance tuning etc Experience working with Azure Data Lake Storage and Data Warehouse concepts e g dimensional modeling star snowflake schemas Understanding CI CD practices in a data engineering context Excellent problem-solving and communication skills Preferred skill sets Experienced in Delta Lake Power BI or Azure DevOps Knowledge of Databricks will be a plus Knowledge of Spark Scala or other distributed processing frameworks Exposure to BI tools like Power BI Tableau or Looker Familiarity with data security and compliance in the cloud Experience in leading a development team Years of experience required 4 - 7 yrs Education qualification Btech MBA MCA Education if blank degree and or field of study not specified Degrees Field of Study required Bachelor of Technology Master of Business Administration Degrees Field of Study preferred Certifications if blank certifications not specified Required Skills Snowflake Platform Optional Skills Accepting Feedback Accepting Feedback Active Listening Analytical Thinking Business Case Development Business Data Analytics Business Intelligence and Reporting Tools BIRT Business Intelligence Development Studio Communication Competitive Advantage Continuous Process Improvement Creativity Data Analysis and Interpretation Data Architecture Database Management System DBMS Data Collection Data Pipeline Data Quality Data Science Data Visualization Embracing Change Emotional Regulation Empathy Inclusion Industry Trend Analysis 16 more 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