Deals Real Assets, Data Engineering & Digital Solutions, Senior Associate

PwC

Vancouver

On-site

CAD 60,000 - 100,000

Full time

13 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

PwC Canada is seeking a Senior Data Engineer within Deals, Capital Projects and Infrastructure to design robust data pipelines and dashboards. You will leverage Azure Data Factory, Databricks, and Synapse, building scalable transformations and data models for advisory workflows.

You’ll collaborate with project advisors and data analysts to deliver high-quality data solutions. You’ll develop Python tools, AI modules, and front-end dashboards (HTML/CSS/JS) while ensuring data quality, governance,

Qualifications

  • Relevant years of experience in data engineering, software development, or a related technical role.
  • Exposure to capital projects, engineering consulting, or construction management environments is an asset.
  • Ability to troubleshoot and learn new tools in ambiguous technical challenges.
  • Proficiency in Python for data tooling and transformations.
  • Familiarity with core Azure data services and data warehousing concepts.
  • Knowledge of SQL for data extraction and transformations.

Responsibilities

  • Architect end-to-end data pipelines using Azure data services and tools.
  • Design and implement data models in data lakes with Medallion Architecture.
  • Ingest data from relational databases, APIs, files, and project systems.
  • Automate data workflows; implement CI/CD for pipelines.
  • Monitor performance, scalability, and cost of data solutions.
  • Lead development of internal tools and dashboards using Python.
  • Build web dashboards with HTML/CSS/JavaScript and Python frameworks.
  • Integrate Generative AI modules into advisory workflows.
  • Ensure data quality and governance, with documentation.

Skills

Data engineering
Python
Azure data services
SQL
Front-end web
Generative AI
CI/CD
Dashboard development

Education

Bachelor's degree in Computer Science, Engineering, IT, or related field
MBA or professional designation asset

Tools

Azure Data Factory
Azure Databricks
Azure Synapse Analytics
HTML/CSS/JavaScript
Flask / Dash / Streamlit
OpenAI / AI APIs

Job description

Job Summary

Line of Service Advisory Industry/Sector Not Applicable Specialism Capital Projects Management Level Senior Associate Job Description & Summary A career within Deals, Capital Projects and Infrastructure, part of our Real Assets group, will provide you with the opportunity to deliver innovative deal solutions to our clients, providing advice and support, from initiation through to completion. In short, we're a part of helping some of the world's leading companies and governments across many industries originate, create, execute, and realize value. The Real Assets team advises governments and businesses in the delivery of complex infrastructure and capital projects and programs. As part of our team, you'll leverage your technical expertise in data engineering and software development to build the digital tools, platforms, and data solutions that power our advisory capabilities, enabling clients to optimize capital programs, ensure project success, and navigate constrained budgets or challenging situations.

Responsibilities
  • Data Engineering & Pipeline Development Architect, design, and develop robust, end-to-end data pipelines utilizing Azure Data Factory, Azure Databricks, and Azure Synapse Analytics
  • Design and implement data models within Azure Data Lake, leveraging Medallion Architecture and building complex business logic into scalable, efficient transformations
  • Develop processes to ingest data from a wide variety of sources, including relational databases (SQL, Oracle), APIs, flat files, and project management systems
  • Automate data workflows and implement CI/CD practices for data pipelines using Azure DevOps or GitHub Actions to ensure quality and rapid deployment
  • Monitor, troubleshoot, and optimize data solutions for performance, scalability, and cost-effectiveness
  • Proactively identify and resolve performance bottlenecks in data pipelines, data partitioning strategies, and cost-control measures across Azure data services
  • Lead the development, build, and maintenance of internal tools and applications using Python, including Generative AI modules, automation scripts, and data processing pipelines to enhance the team's advisory capabilities on capital projects
  • Design, develop, and maintain custom web-based dashboards and interactive reporting tools using HTML, CSS, JavaScript, and Python-based frameworks (e.g., Flask, Dash, Streamlit)
  • Integrate AI-driven solutions into project advisory workflows (e.g., document analysis, benchmarking, risk identification, schedule analytics)
  • Ensure data quality, integrity, and governance by implementing best practices, data validation checks, and robust documentation
  • Participate in reviewing and validating project schedules and budgets, forecasting of project performance, and performing project risk assessments, monitoring and control
  • Assist in the preparation of proposals and development of opportunities for the CP&I practice
  • Work closely with project advisors, data analysts, and business stakeholders to understand their data requirements and deliver high‑quality data solutions
  • Perform site visits and inspections as needed (may require work on site, including travel to remote locations)
What You'll Bring
  • Relevant years of experience in data engineering, software development, or a related technical role (internships, co‑ops, and academic projects count)
  • Exposure to or interest in capital projects, engineering consulting, project management, or construction management environments is an asset
  • Ability to troubleshoot and problem‑solve, with a willingness to work through ambiguous or unfamiliar technical challenges and an openness to learning new tools and adapting how you work
  • Proficiency or working knowledge of Python with the ability to develop tools, create reusable scripts for data analysis, and build data processing pipelines
  • Familiarity with core Azure data services (e.g., Azure Data Factory, Azure Databricks)
  • Understanding of or exposure to data pipeline development concepts, including data warehousing principles, and data lake architectures
  • Working knowledge of SQL with the ability to write queries to extract and transform data from relational databases
  • Experience with front‑end web technologies (HTML, CSS, JavaScript) and Python-based dashboard frameworks
  • Interest in or exposure to building Generative AI modules (e.g., leveraging APIs such as OpenAI, Anthropic, etc.) and integrating AI-driven solutions into advisory workflows
  • Awareness of Azure security best practices
  • Bachelor's degree in Computer Science, Engineering, Information Technology, or related field is ideal
  • MBA or and interest in obtaining a professional designation (e.g., PMP, P.Eng., etc.) would be an asset
  • Willingness to travel when required
  • Experience with construction claims is a plus
Key Salary & Compensation

The salary range for this position is $60,000 - $100,100. The posted salary range represents the expected hiring range for PwC locations in major city centres. Given our national recruiting approach, ranges may vary for positions in other locations. At PwC Canada, base salary is determined by your skills, experience, qualifications and work location. In addition to base salary, eligible employees may have opportunities to participate in variable incentive pay programs which are designed to reward individual and firm‑wide achievements. We are committed to offering competitive compensation and adhere to all relevant pay transparency legislation. During the hiring process, our Talent Acquisition team will provide details about our comprehensive total rewards package.

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.

Inclusive Culture

PwC Canada acknowledges that we work and live across Turtle Island, on the land that is now known as Canada, which are the lands of the ancestral, treaty and unceded territories of the First Nations, Métis and Inuit Peoples. We recognize the systemic racism, colonialism and oppression that Indigenous Peoples have experienced and still go through, and we commit to allyship and solidarity.

Additional Requirements
  • Travel requirements: Not specified
  • Work visa sponsorship: No
  • Government clearance required: No
Accommodation Statement

We’re committed to providing accommodation throughout the application, interview, and employment process. If you require accommodation to be at your best, please let us know during the application process.

French Inclusive Statement

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. L’utilisation de l’intelligence artificielle (IA) dans le domaine du recrutement est à ses balbutiements. Nous savons que vous pourriez vous demander comment et pourquoi nous y avons recours. À certains stades de notre processus de recrutement, nous comptons sur l’IA pour améliorer votre expérience. Par exemple, pendant l’examen du curriculum vitæ ou l’élaboration d’une liste de recommandations personnalisées, un agent conversationnel pourrait vous demander des précisions ou fixer avec vous un rendez‑vous pour l’entrevue. L’IA nous aide à mieux lutter contre les préjugés, car l’évaluation des candidats se fait de façon juste et équitable, sans que les informations d’identification comme le nom ou le sexe soient connues. Elle nous permet également de mieux repérer les bons candidats pour un poste et d’évaluer le lien entre leurs compétences, leur expérience et leurs chances de réussir chez PwC Canada. Bien que l’IA facilite certaines étapes de notre processus de recrutement, les décisions finales d’embauche sont toujours prises par des personnes. Pour en savoir plus sur l’utilisation et la protection de vos données personnelles, consultez notre politique sur la protection des renseignements confidentiels (https://www.pwc.com/fr/privacy-policy.html).

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Digital Assurance & Transparency Manager
Digital Assurance & Transparency Manager

PricewaterhouseCoopers LLP • Vancouver

On-site
CAD 88,000 - 138,000
Digital Assurance & Transparency Manager
Digital Assurance & Transparency Manager

PwC • Alberta

On-site
CAD 88,000 - 138,000
Capital Projects and Infrastructure, Infrastructure Project Finance, Director
Capital Projects and Infrastructure, Infrastructure Project Finance, Director

PricewaterhouseCoopers LLP • Toronto

On-site
CAD 152,000 - 202,000
Real Assets Senior Associate (Bilingual FR/ENG)
Real Assets Senior Associate (Bilingual FR/ENG)

PwC Canada • Montreal

Hybrid
CAD 60,000 - 100,000
Transfer Pricing, Customs and International Trade, Senior Associate
Transfer Pricing, Customs and International Trade, Senior Associate

PwC • Toronto

Hybrid
CAD 60,000 - 100,000
Technology Strategy & Transformation, Senior Associate
Technology Strategy & Transformation, Senior Associate

PricewaterhouseCoopers LLP • Vancouver

On-site
CAD 85,000 - 135,000
Data Management and Strategy, Senior Associate
Data Management and Strategy, Senior Associate

PwC • Toronto

On-site
CAD 85,000 - 135,000
Corporate Finance Senior Associate (Bilingual FR/EN)
Corporate Finance Senior Associate (Bilingual FR/EN)

PricewaterhouseCoopers LLP • Quebec

On-site
CAD 56,000 - 94,000
Digital Assurance & Transparency Senior Associate
Digital Assurance & Transparency Senior Associate

PwC • Toronto

On-site
CAD 66,000 - 109,000
Deals, Corporate Finance, Senior Associate
Deals, Corporate Finance, Senior Associate

PwC • Edmonton

On-site
CAD 60,000 - 100,000