Deals Real Assets, Data Engineering & Digital Solutions, Senior Associate
About this role
The Opportunity:
As a Deals, Real Assets Senior Associate – Data Engineering & Digital Solutions, unlock your potential and embrace the chance to drive meaningful outcomes that'll elevate your career. Your role will include, but isn't limited to:
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
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.
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
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.
The use of artificial intelligence (AI) in recruiting is just getting started, so we know you have questions about how and why we use it. At certain points during our recruiting process, we rely on AI to improve your experience. This could be during resume review or curating personalized job recommendations, asking you clarifying questions via a chatbot or during our interview scheduling to improve your experience. Our use of AI helps ensure we combat bias by evaluating candidates equally and fairly, without seeing identity information, such as your name, or gender for example). AI also helps us better predict successful hires by reviewing all applicants for a role and the relationship between your skills, experience and likely success at PwC Canada. While AI supports parts of our recruitment process, final hiring decisions always involve human review. For more information about our use and protection of your data, please refer to our Privacy Policy (https://www.pwc.com/ca/en/privacy-policy.html).
Company at a glance
Welcome to PwC Canada's official LinkedIn page.
On this page, you'll get the latest news, thought leadership, events and what it's like to work at the firm.
Our purpose to build trust in society and solve important problems is brought to life by more than 7,800 partners and staff in locations across Canada.
With more than 110 years of excellence in Canada, we provide industry-focused professional services including audit assurance, risk assurance, tax. deals and consulting. We work to provide clients with the best of our collective thinking, experience, and solutions.
Top Benefits
- Competitive compensation
- Variable incentive pay programs
- Comprehensive total rewards package
- Flexibility programs
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Know someone who'd be great for this?