Manager, Data and Analytics Solution Architect

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.

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

• Thrive on challenges and work best in a fast-paced environment where each day is different.
• Work well in a project team environment and have strong collaboration and interpersonal skills.
• Have a natural “figure it out” mindset.

Innovate. Collaborate. Shine. Lighthouse – KPMG Canada’s Center of Excellence for data advanced analytics and AI — applies data engineering, data science, AI/ML and software development expertise to architect data and analytics solution 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.

As a manager, you’ll lead and work as part of a team of problem solvers with extensive consulting and industry experience, helping our clients solve their complex business issues from strategy to execution. Specific responsibilities include but are not limited to:

• Work with cross functional engagement teams to translate business and analytics requirements into a data, analytics and AI strategy and requirement for the engagement.
• Architect and develop overall end-to-end design of data and analytics solutions across Data Lakes, Data Warehouses, Data Lakehouses, pipelines on modern data platforms such as Microsoft Fabric, Databricks and Snowflake (with a focus on the first two) on Azure, AWS and GCP (with a focus on the first) and lead the deployment and delivery of the solution.
• Enforce technical architecture and documentation standards, policies, and procedures
• Analyze, implement, and resolve issues with existing modern data platforms
• Provide mentorship to a team of data engineers, software developers, and data scientists with a focus is on modern data analytics platform.
• Lead the team to 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, analytics and AI-related technical issues and support their data analytics 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 building and optimizing our product into an innovative industry leader.
• Take ownership of projects and pushing technological boundaries.
• Presales, estimating and proposal writing, responding to RFPs
• Assist in scoping, estimation, and task planning for assigned projects
• Remaining up to date in new and emerging technologies

We will look to you to bring a blend of knowledge, training, and experience, including:

• 6+ years of experience in data engineering, analytics, and AI (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.
• Expertise in leading and mentoring team members toward developmental objectives and resilience to overcome challenges or setbacks to achieve team, project, and client goals.
• Expertise in relational and non-relational databases, including query language (SQL);
• Expertise in building and optimizing data pipelines, architectures and data models for all data types, speed, and sizes.
• Expertise in performing root cause analysis on internal and external data; processes to answer specific business questions and identify opportunities for improvement.
• Expertise in building standards, processes supporting data, data transformation, data structures, metadata, dependency, and workload management.
• A successful history of manipulating, processing, and extracting value from large discrete datasets.
• Working knowledge of message queuing, stream processing, parallel processing, and data lakes.
• Expertise in deploying and maintaining high performance computing VMs in on-premises and cloud environment.
• Experience using a combination of industry relevant software/tools including some of the following:
• Modern Data Analytics Platforms: Microsoft Fabric, Synapse, Databricks, Snowflake
• Big data tools: Hadoop, Spark, Kafka, etc.
• Relational SQL and NoSQL databases, including MS SQL Server, PostgreSQL, and Cosmos DB.
• Data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
• Azure, AWS and GCP cloud data services.
• Stream-processing systems: Spark-Streaming, Azure Event Hubs, etc.
• Object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.

Desired experience, certifications, and abilities:

• Relevant post-secondary education in a related field.
• Azure Certifications: Azure Data Engineer Associate, Azure Solutions Architect Expert.
• Databricks Certifications: Databricks Certified Data Engineer Associate, Databricks Certified Professional Data Engineer
• Experience in analytics, statistics, data mining, machine learning, natural language processing and/or mathematics is an asset.
• Experience in visualization, visualization related technology (Tableau, PowerBI, D3, plotyldash, plotly.js) and data modeling within these tools is an asset.

What makes you stand out:

• You have fine-tuned your leadership skills and are comfortable leading diverse teams, overseeing a variety of engagements, as well as managing and coordinating expectations of stakeholders.
• You see 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’ objectives and challenges.
• You have developed a reputation as a knowledgeable professional in your area, possess a solution orientated and analytical 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 strong 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 $93,000 to $155,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.

#LI-Hybrid

Providing you with the support you need to be at your best

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.

Adjustments and accommodations throughout the recruitment process

At KPMG, we are committed to fostering an inclusive recruitment process where all candidates can be themselves and excel. We aim to provide a positive experience and are prepared to offer adjustments or accommodations to help you perform at your best. Adjustments (informal requests), such as extra preparation time or the option for micro breaks during interviews, and accommodations (formal requests), such as accessible communication supports or technology aids, are tailored to individual needs and role requirements. You will have the opportunity to request an adjustment or accommodation at any point throughout the recruitment process. You will have an opportunity to request an adjustment or accommodation at any point throughout the recruitment process. If you require support, please contact KPMG’s Employee Relations Service team by calling 1-888-466-4778.