Manager, Data and Analytics Solution Architect

at  KPMG

Overview:
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.
What you will do:

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

What you bring to this role:

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.

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

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 technologie