You're using an older version of Internet Explorer that is no longer supported. Please update your browser.

Senior Consultant - Data Engineer

Vancouver, BC
Full Time
2 days ago
At KPMG, you'll join a team of diverse and dedicated problem solvers, connected by a common cause: turning insight into opportunity for clients and communities around the world.

The Opportunity
Our Vancouver team are looking for a highly motivated Data Engineer at a Senior Consultant level to join our team! As a member of KPMG Canada's Lighthouse team, you will be dedicated to enabling and optimizing our clients' functionality across our data, analytics, and software solutions. This role will be a rewarding experience for you if you:

  • Thrive in a growth focused environment, providing you exposure to rewarding projects that deliver impact to clients across different verticals.
  • Work well in a project team environment and have excellent collaboration and interpersonal skills
  • Have a "figure it out" mindset.

Innovate . Collaborate. Shine. Lighthouse - KPMG Canada's Center of Excellence for data valorization and advanced analytics- applies data science to solve real-word business problems, operationalize AI and optimize emerging technologies for its mission. Join a diverse team which is always curious and learning, thinking independently, working collaboratively, has a passion to solve difficult problems, and has fun doing it.

What you will do
As a Senior Consultant, you'll lead and work as part of a team of problem solvers with extensive consulting and industry experience, helping our clients solve complex business issues from strategy to implementation. Specific responsibilities include but are not limited to the following:

  • Work with various engagement teams to understand business and gather technical data strategy and solutions for client engagements.
  • Participate in architecture, development, deployment and maintenance of secure, extensive, scalable, repeatable and high-performing data platforms and optimal data pipelines to source data from variety sources within on-prem and cloud environments (MS Azure and AWS) to support streaming data, batch data flows.
  • Assemble large, complex data sets that meet functional / non-functional business requirements.
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
  • Perform data management tasks, including data architecture design and data modeling, master data/metadata/data security/privacy/data quality management, data operations, data integration and interoperability.
  • Develop standards for data processes and automate routine tasks.
  • Run queries for descriptive analytics and provide formatted result sets.
  • Proactively contribute to the creation of presentation materials relating to data activities for stakeholder discussions.
  • Create data tools for analytics and data scientist team members that assist them in developing and optimizing our product into an creative industry leader.
  • Take ownership of projects and pushing technological boundaries.
  • Establish and maintain effective working relationships with colleagues, existing clients, and prospective client organizations.
  • Engage in and contribute to the innovation, growth, and enhancement of KPMG Lighthouse services.
What you bring to the role
  • 3+ years of experience in data engineering (supporting data/data platform architecture, design, implementation, and/or support of complex data and application architectures that are scalable and repeatable) ideally within a services/consulting organization.
  • Experience with relational and non-relational databases, including query language (SQL).
  • Experience developing and optimizing data pipelines, architectures and data models for all data types, speed, and sizes.
  • Experience performing root cause analysis on internal and external data; processes to answer specific business questions and identify opportunities for improvement.
  • Experience supporting in development of standards, processes supporting data, data transformation, data structures, metadata, dependency, and workload management.
  • Experience manipulating, processing, and extracting value from large discrete datasets.
  • Working knowledge of message queuing, stream processing, parallel processing, and data lakes.
  • Experience deploying and maintaining high performance computing VMs in on-premise and cloud environment;
  • Experience using a combination of industry relevant software/tools including some of the following:
      • Relational SQL and NoSQL databases: MS SQL Server, PostgreSQL and Cosmos DB.
      • Data Warehousing Solutions (Azure Synapsepreferred).
      • Data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
      • Cloud data services (Azure preferred).
      • Object-oriented/object function scripting languages: Python(preferred), Java, C++, Scala.
      • Big data tools: Hadoop, Spark, and Kafkaare desired.
      • Stream-processing systems: Spark-Streaming, DataBricks, and Azure Event Hubsare desired.

Keys to your success
  • You recognize the big picture both as a consultant and as an internal contributor. You are motivated to create solutions that are practical and cost-effective solutions that are relevant to your clients' goals and challenges.
  • You have developed a reputation as a knowledgeable professional in your area, possess a solution orientated and critical thinking mindset, and enjoy guiding others through complex and at times ambiguous challenges.
  • You're a self-starter that takes initiative to constantly improve your skillset and contribute to the overall performance and success of the practice.
  • You are an exceptional communicator, both verbally and written, with the ability to deliver professional communications, presentations, reports and documentation.
  • You have developed a deep professional brand and presence in the community and enjoy contributing to and participating in events.

KPMG BC Region Pay Range Information
The expected base salary range for this position is $71,500 to $119,000 and may be eligible for bonus awards. The determination of an applicant's base salary within this range is based on the individual's location, skills, & competencies, and unique qualifications. In addition, KPMG offers a comprehensive and competitive Total Rewards program.


KPMG individuals Deliver Impact | Seek Growth | Inspire Trust and understand that a diverse workforce enables us to deepen relationships and strengthen our business.

Providing you with the support you need to be at your best
For more information about KPMG in Canada's Benefits and well-being, click here .

Our Values, The KPMG Way
Integrity, we do what is right | Excellence, we never stop learning and improving | Courage, we think and act boldly | Together, we respect each other and draw strength from our differences | For Better, we do what matters

KPMG in Canada is a proud equal opportunities employer and we are committed to creating a respectful, inclusive and barrier-free workplace that allows all of our people to reach their full potential. A diverse workforce is key to our success and we believe in bringing your whole self to work. We welcome all qualified candidates to apply and hope you will choose KPMG in Canada as your employer of choice. For more information about Inclusion, Diversity & Equity in Recruitment, please click here .

If you have a question about accessible employment at KPMG, or to begin a confidential conversation about your individual accessibility or accommodation needs through the recruitment process, we encourage you to visit our accessibility page .
Customer Service and Support