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 chance to deliver innovative deal solutions to our clients, providing advice and support, from initiation through to completion. In short,we’rea part of helping some of the world’s leading companies and governments across many industries originate, create, execute, andrealizevalue.

The Real Assets teamadvisesgovernments 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.

The Opportunity:

As a Deals, Real Assets Senior Associate – Data Engineering & Digital Solutions, unlock your potential and embrace the chance to drive meaningful outcomesthat’llelevate your career. Your role will include, butisn’tlimited to:

- Data Engineering & Pipeline Development
- Architect, design, and develop robust, end-to-end data pipelinesutilizingAzure Data Factory, Azure Databricks, and Azure Synapse Analytics
- Design and implement data models within Azure Data Lake,leveragingMedallion 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, andoptimizedata solutions for performance, scalability, and cost-effectiveness
- Proactivelyidentifyand 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, andmaintaincustom 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
- Participatein reviewingand validatingproject schedules and budgets,forecasting ofproject performance, and performing project risk assessments,monitoringand control.
- Assistin 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
- Proficiencyor 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.,leveragingAPIs 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 fieldis ideal
- MBA orandinterest in obtaining a professional designation (e.g., PMP, P.Eng., etc.)



would be an asset
- Willingness to travel whenrequired
- Experience with construction claims is a plus

This newly created role reflects our commitment to growth and delivering distinctive value for our clients and stakeholders.

The salary range for this position is $58,400 - $97,500. 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.

Whyyou’lllove PwC

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étisand Inuit Peoples. We recognize the systemic racism,colonialismand oppression that Indigenous Peoples have experienced and still go through, and we commit to allyship and solidarity.

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, Accepting Feedback, Active Listening, Analytical Thinking, Budgetary Management, Capital Management (CM), Capital Raising, Cash Flow Analysis, Communication, Contingency Planning, Contract Lifecycle Management, Contractor Management, Cost Estimate Preparation, Cost Management, Cost Reduction, Creativity, Embracing Change, Emotional Regulation, Empathy, Financial Management, Financial Modeling, Financial Risk Management, Inclusion, Intellectual Curiosity, Investment Management {+ 19 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

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.

#J-18808-Ljbffr

📌 Deals Real Assets, Data Engineering & Digital Solutions,Senior Associate (Calgary)
🏢 PwC
📍 Calgary