AWS Data and AI Consultant

PwC - Global; Ottawa; On-site; CAD 172,000; Full time

Job summary

A leading consulting firm in Ottawa is seeking an experienced AWS Data and AI Consultant to design and implement scalable, cloud-native data solutions. You will solve complex challenges and drive digital transformation for clients while ensuring data governance and security. With strong AWS and Python skills, you will contribute to cutting-edge data strategies that enhance business value. Join a collaborative environment that fosters innovation and a commitment to excellence.

Benefits

Competitive compensation

Flexible work environment

Diversity and inclusion programs

Qualifications

• Experience building enterprise-level data engineering solutions on AWS.
• Proficiency in Python and data orchestration tools.
• Hands-on experience with distributed data frameworks and streaming technologies.

Responsibilities

• Design, develop, and deploy AWS-based data solutions.
• Maintain secure data lake and warehouse solutions.
• Build efficient ETL/ELT workflows for data availability.

Skills

AWS cloud technologies

Data pipelines

Analytics

Python

Apache Airflow

Data modeling

Education

Bachelor's degree in Computer Science or related fields

AWS certification(s)

Tools

AWS services (S3, Lambda, Kinesis, Redshift, EMR, Glue)

Apache Spark

Kafka

Hive

Job description

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Analytics

Management Level

Manager

Job Description & Summary

At PwC, we are committed to building trust in society and solving important problems. Our Data & Analytics Practice combines market-leading expertise with innovative technology solutions to help clients transform their business by making smarter, data-driven decisions. As part of our global network, you’ll join a diverse and collaborative team dedicated to delivering impactful, scalable data solutions on the AWS cloud platform.

Meaningful work you'll be part of

As an AWS Data and AI Consultant, you’ll work as part of a team of problem solvers, helping to solve business issues, deliver high quality client service and operational efficiency. PwC is seeking a highly skilled AWS Data and AI Consultant, to join our Cloud, Data & AI practice and play a key role in delivering cutting-edge, cloud-native data solutions for our clients across industries. In this role, you will design and implement scalable, secure, and resilient data architectures on AWS that enable actionable insights and operational efficiencies. As an integral member of multi-disciplinary teams, you will work closely with business leaders, data scientists, and technologists to solve complex challenges and accelerate clients’ digital transformation journeys. Your expertise in AWS cloud technologies, data pipelines, and analytics will ensure PwC continues to uphold its reputation for delivering data solutions that drive sustainable business value and competitive advantage.

Responsibilities

• Design, develop, and deploy robust, scalable, real-time AWS-based data solutions aligned with PwC’s high standards and client business objectives.
• Architect and maintain secure, compliant data lake and warehouse solutions utilizing AWS services such as S3, Redshift, EMR, Lambda, Kinesis, and more.
• Build efficient ETL/ELT workflows that support diverse, complex data sources, and enable timely data availability for analytics and reporting.
• Lead the creation and optimization of event-driven, streaming data pipelines that support advanced analytics, AI/ML models, and decision-making processes.
• Partner with PwC consultants, data scientists, BI engineers, and client teams to translate business problems into effective technical solutions.
• Ensure adherence to PwC’s rigorous data governance, security, and privacy policies throughout the solution lifecycle.
• Implement automation and DevOps best practices within data engineering pipelines to enhance reliability, scalability, and deployment velocity.
• Stay abreast of AWS innovations and industry trends to continually bring new opportunities to PwC’s data practice and clients.

Experiences and skills you'll use to solve

• Proven experience building enterprise-level data engineering solutions on AWS, supporting large-scale data initiatives.
• Proficiency in Python and hands‑on experience with data orchestration tools (Apache Airflow, AWS Step Functions, or equivalent).
• Solid hands‑on experience of distributed data frameworks and streaming technologies such as Apache Spark, Kafka, and Hive.
• Hands‑on expertise with AWS ecosystem including S3, Lambda, Kinesis, Redshift, EMR, Glue and SQS.
• Strong data modeling skills and experience designing ETL/ELT pipelines for batch and real‑time ingestion.
• Familiarity with CI/CD pipelines, version control, and infrastructure‑as‑code tools (CloudFormation, Terraform).
• Exceptional analytical skills with a proactive, problem‑solving approach and a strong customer orientation.
• Excellent communication and collaboration skills suited for a consulting environment involving clients and internal teams.
• Bachelor’s or higher degree in Computer Science, Information Systems, Engineering or related fields; AWS certification(s) highly desirable.
• PwC Canada is committed to cultivating an inclusive, hybrid work environment. Exact expectations for your team can be discussed with your interviewer.

PwC BC Region Pay Range Information

The salary range* for this position is $103,000.00 - 137,400.00 - 171,800.00 CAD Annual, plus individuals may be eligible for an annual bonus payment. Actual compensation within the range will be dependent upon your skills, experience, qualifications and geographic location.

* Please note that the salary range for this position is reflected for our British Columbia region. Given our national recruiting approach, we recruit (and may hire) in other regions and therefore the salary range may differ depending on the work location. PwC is committed to competitive compensation and sharing salary ranges in accordance with applicable pay transparency legislation as they arise.

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 a bout our Application Process and Total Rewards Package at: https://jobs-ca.pwc.com/ca/en/life-at-pwc

Indigenous Recognition & Accommodation Statement

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.

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.

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/fr/about-us/diversity-inclusion.html. Faites partie de La Nouvelle équation.

Optional Skills

• Accepting Feedback
• Active Listening
• Analytical Thinking
• Artificial Intelligence
• Big Data
• C++ Programming Language
• Coaching and Feedback
• Communication
• Complex Data Analysis
• Creativity
• Data‑Driven Decision Making (DIDM)
• Data Engineering
• Data Lake
• Data Mining
• Data Modeling
• Data Pipeline
• Data Quality
• Data Science
• Data Science Algorithms
• Data Science Troubleshooting
• Data Science Workflows
• Deep Learning
• Embracing Change
• Emotional Regulation
• 23 more