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

PwC•Vancouver, BC

9d•CA$58,400 - CA$97,500

About The Position

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.

Requirements

Relevant years of experience in data engineering, software development, or a related technical role (internships, co-ops, and academic projects count)
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
Awareness of Azure security best practices
Bachelor's degree in Computer Science, Engineering, Information Technology, or related field is ideal
Willingness to travel when required

Nice To Haves

Exposure to or interest in capital projects, engineering consulting, project management, or construction management environments is an asset
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
MBA or and interest in obtaining a professional designation (e.g., PMP, P.Eng., etc.) would be an asset
Experience with construction claims is a plus

Responsibilities

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