Line of ServiceAdvisory
Management LevelSenior Associate
Job Description & SummaryA career in our Advisory Service Delivery Centre is the natural extension of PwC’s leading class global delivery capabilities. We provide premium, cost effective, high quality services that support process quality and delivery capability in support for client engagements.
To really stand out and make us fit for the future in a constantly changing world, each and every one of us at PwC needs to be an authentic and inclusive leader, at all grades/levels and in all lines of service. To help us achieve this we have the PwC Professional; our global leadership development framework. It gives us a single set of expectations across our lines, geographies and career paths, and provides transparency on the skills we need as individuals to be successful and progress in our careers, now and in the future.
As a Senior Associate, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. PwC Professional skills and responsibilities for this management level include but are not limited to:
Data Engineer - Azure
Experience: 2 to 7 years
Minimum Degree Required: Bachelor's degree in Engineering
Certification(s) Preferred: Azure certifications DA100, DP200, DP201, AZ 900
Microsoft Azure Platform - Mandatory
Demonstrated experience in end-to-end deployment of MS Azure BI solution
Hands on experience in developing solutions using Azure data factory
Hands on experience in building data lake from multiple data sources with ingestion, data governance and auditing capabilities
Should have exposure to Microsoft Azure platform, including Azure Data Factory (ADF), Azure Cosmos DB, Azure Storage, Azure Data Warehouse (SQLDW), Event Hubs, Data Lake Store, Data Lake Analytics, U-SQL, HDInsights, PowerShell
SQL Server - Mandatory
Expert in designing and implementing relational database and Dimensional model
In-depth knowledge of Transact-SQL (DDL, DML)- creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
SQL Server Integration Services (SSIS) - (Desirable)
Proficient in implementing all transformations available on the SSIS toolbox.
Excellent knowledge of using variables and expressions in packages.
Experienced in creating master and child packages, package configurations and logging.
Experienced in SSIS package Auditing.
Experienced in SSIS package deployment and Scheduling
Power BI (Desirable)
Experience in creating Microsoft Power BI dashboards, modeling, reports with a focus on usability, performance, flexibility, testability, and standardization
Experience in Data Gateway for data refreshing, contents packs, publishing reports to app.powerbi.com
Exposure to custom visuals, embedding Power BI reports, SSRS integration with Power BI
Exposure to Power Pivot, T-SQL, MDX, VBA, DAX, Power queries
Education (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)
Desired Languages (If blank, desired languages not specified)
Available for Work Visa Sponsorship?
Government Clearance Required?
Job Posting End DateOctober 15, 2021