Data Analysis and Analytics, Senior Associate – Azure

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Technology Strategy

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.

PwC Canada is seeking a highly skilled and innovative Data Analysis and Analytics, Senior Associate to join our fast-growing dynamic Microsoft Alliance Data team. In this role, you will be instrumental in designing, developing, and maintaining data analytics projects, enabling our client to deploy reports and advanced analytics. Your expertise will be crucial in transforming vast datasets into actionable insights, empowering our clients to achieve their business goals. You will help guide and support your team in creating and managing dashboards and reports, ensuring data quality and integrity, and collaborating with various stakeholders to meet business requirements. Your role will be pivotal in enhancing our data models and analytical capabilities, driving the success of our data-driven initiatives.

What to consider before applying

As a requirement, a Secret Security Clearance is mandatory for all staff who will engage on these assignments. Prior to applying, please review the Government of Canada website to ensure you meet the eligibility requirements to obtain this clearance. This will become a condition of your employment with PwC Canada should you receive an offer from us.

Meaningful work you’ll be part of

As a Data Analysis and Analytics, Senior Associate – Azure, you’ll work as part of a team of problem solvers, helping to solve business issues, deliver high quality client service and operational efficiency. Responsibilities include but are not limited to:

• Collaborate with IT and Business Teams to define Data Models and Improve Data Analytical Capabilities; Partner with client business analysts to define and refine data models. Work together to expand the organization's capacity for deep data analysis and foster a culture of data-driven decision-making.
• Design, Develop, and Maintain Data Analytics and Reporting Solutions: Create sophisticated analytics insights that transform vast datasets into actionable insights. Develop comprehensive reporting mechanisms that consistently monitor data accuracy and generate reliable business intelligence.
• Ensure Data Quality and Integrity in Reporting and Analytics: Implement rigorous validation processes to guarantee the precision of data used in analytics and reporting.
• Work with Various Stakeholders to Understand Business Requirements and Translate Them into Technical Specifications: Collaborate closely with business units to comprehend their data needs. Translate these requirements into detailed technical plans that guide the development of data solutions.
• Create and Manage Dashboards and Reports That Provide Actionable Insights: Craft dynamic Power BI and third-party dashboards and reports that not only visualize data but also drive decision-making with clear, actionable insights.
• Provide Guidance and Support to Junior Data Analysts and Other Team Members: Serve as a mentor and leader to less experienced data analysts. Offer support and guidance to ensure the team's continuous professional growth and the overall enhancement of analytical competencies.
• Collaboration: Work closely with our client’s business stakeholder, data engineers and data scientists, AI researchers, and software engineers.

Experience and skills you’ll use to solve

• Strong experience in data analysis and business intelligence: Demonstrated proficiency in analyzing data trends and translating insights into strategic business decisions. Skilled in utilizing BI tools to create impactful data visualizations and reports.
• Proficient in leveraging Microsoft Azure Analytics ecosystem tools to transform raw data into informative, easy-to-understand visual reports, enhancing decision-making processes.
• Experience with SQL and data modeling: Well-versed in SQL querying and experience at constructing robust data models that streamline and optimize data retrieval and storage.
• Knowledge of data warehouse design and ETL processes: Familiar with designing scalable data warehouses and implementing efficient ETL processes to support data integrity and analytics.
• Ability to work with large datasets and complex data structures: Capable of managing and analyzing large volumes of data, ensuring accuracy and consistency in complex data environments.
• Microsoft Certifications on PowerBI, Microsoft Fabric and Azure Data Engineer are highly desirable.
• Excellent problem-solving skills and attention to detail: Proven ability to identify and resolve data-related issues with precision, ensuring the highest quality of data analysis.
• Strong communication and presentation skills: Effective communicator, able to present complex data insights in a clear and persuasive manner to stakeholders at all levels.
• When applying to a Quebec based opportunity, fluency in French is required. Outside of Quebec, fluency in French is an asset.

Why you’ll love PwC

We’re inspiring and empowering our people to change the world. Powered by the latest technology, you’ll be a part of diverse teams helping public and private clients build trust and deliver sustained outcomes. This meaningful work, and our continuous development environment, will take your career to the next level. We reward your impact, and support your wellbeing, through a competitive compensation package, inclusive benefits and flexibility programs that will help you thrive in work and life. Learn more about our Application Process and Total Rewards Package at: https://jobs-ca.pwc.com/ca/en/life-at-pwc

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)

Required Skills

Optional Skills

Accepting Feedback, Active Listening, Algorithm Development, Alteryx (Automation Platform), Analytical Thinking, Analytic Research, Big Data, Business Data Analytics, Communication, Complex Data Analysis, Conducting Research, Creativity, Customer Analysis, Customer Needs Analysis, Dashboard Creation, Data Analysis, Data Analysis Software, Data Collection, Data-Driven Insights, Data Integration, Data Integrity, Data Mining, Data Modeling, Data Pipeline {+ 38 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

Yes

Job Posting End Date

At PwC Canada, our most valuable asset is our people and we grow stronger as we learn from one another. We’re committed to creating an equitable and inclusive community of solvers where everyone feels that they truly belong. We understand that experience comes in many forms and building trust in society and solving important problems is only possible if we reflect the mosaic of the society we live in. We’re committed to providing accommodations throughout the application, interview, and employment process. If you require an accommodation to be at your best, please let us know during the application process. To learn more about inclusion and diversity at PwC Canada: https://www.pwc.com/ca/en/about-us/diversity-inclusion.html. Be a part of The New Equation.

Chez PwC Canada, notre atout le plus précieux, c’est notre personnel. Et c’est en apprenant les uns des autres que nous devenons plus forts. Nous avons à cœur de créer une communauté équitable et inclusive de professionnels de la résolution de problèmes, dans laquelle chacun se sent vraiment à sa place. Nous savons que l’expérience peut prendre diverses formes et, pour nous, donner confiance au public et résoudre des problèmes importants n’est possible que si notre milieu de travail reflète la diversité de la société dans laquelle nous vivons. Nous tenons à répondre à vos besoins tout au long du processus de demande d’emploi, d’entrevue et d’embauche. Si vous avez besoin de mesures d’adaptation pour être parfaitement à l’aise, faites-le-nous savoir à l’étape de la demande d’emploi. Pour en savoir plus sur l’inclusion et la diversité chez PwC Canada: https://www.pwc.com/ca/fr/about-us/diversity-inclusion.html. Faites partie de La Nouvelle équation.