Senior Consultant, Advanced Analytics

MNP; Calgary, Edmonton, Dartmouth; On-site; CAD 110,000 - 140,000; Full time

Benefits offered by this job

Vacation time

Group pension plan 4% matching

Bonus programs

Professional development assistance

Job summary

MNP Digital is seeking a Senior Consultant, Advanced Analytics in Calgary to design and deliver modern cloud data platforms enabling BI, AI, and data science. You will lead workstreams, translate requirements into analytics solutions, and collaborate with client teams across Azure, Fabric, Snowflake, GCP, and AWS.

You will guide solution architecture, mentor colleagues, and stay current with cloud analytics trends while contributing to client engagements and internal best practices.

Qualifications

• Bachelor's degree in computer science, engineering, mathematics, statistics, data science or related field.
• Approximately 5+ years of progressive experience in data and analytics, data engineering, cloud data platforms or a related field, ideally in a consulting or client-facing environment.
• Strong hands-on experience designing and implementing cloud-based data and analytics solutions.
• Experience with Microsoft Azure and related data technologies; exposure to Fabric, Databricks, Snowflake, GCP or AWS is a plus.
• Experience implementing data pipelines, data integration, data transformation and cloud-based storage/processing.
• Knowledge of data modeling concepts for analytical/mixed workloads.
• Experience with data warehouses, lakehouses, MDM, data catalogs and governance.
• Experience implementing production cloud analytics platforms, preferably in Microsoft ecosystem.
• SQL and programming/data engineering tech like Python, PySpark or Spark.
• BI/visualization tools such as Power BI or Tableau.
• Understanding of CI/CD, DevOps, and containers (Docker/Kubernetes) is a plus.
• Strong problem-solving and communication skills for technical and non-technical audiences.
• Ability to build relationships with clients, team members and stakeholders across an organization.
• Cloud or data engineering certifications across Azure, AWS, Google Cloud, Databricks or Snowflake are assets.

Responsibilities

• Design and implement cloud-based data architectures, integration patterns and data solutions using Azure Data Factory, Event Hubs, Databricks, Fabric, Synapse, Snowflake and BigQuery.
• Lead defined technical workstreams and contribute to design/development of data platforms, pipelines, warehouses and lakehouse solutions.
• Translate complex business/technical requirements into structured analytics use cases.
• Collaborate with client stakeholders to understand challenges and recommend approaches.
• Support delivery of client engagements by managing deliverables, risks, and cross-team collaboration.
• Contribute to proposals, estimates, statements of work, and business development opportunities.

Job description

What do you think of when you hear the name MNP? We are more than a prominent consulting firm in tax and accounting, we are redefining how organizations succeed in the digital age by bridging strategic vision, technical innovation, and operational execution to deliver transformative results.

Make an impact with MNP Digital as a Senior Consultant, Advanced Analytics. You will collaborate with our Business Intelligence, Data & Analytics team to design and deliver modern cloud data platforms that enable business intelligence, artificial intelligence, advanced analytics and data science. Working with platforms including Microsoft Azure, Microsoft Fabric, Snowflake, Google Cloud Platform and Amazon Web Services, you will help clients transform complex data requirements into scalable, practical solutions. You will bring strong technical expertise, contribute to solution architecture and lead key workstreams through design, development and implementation.

At MNP Digital, our strength is our people. An investment in our people is an investment in our success. You will have the opportunity to work alongside experienced leaders and technical specialists, expand your skills, contribute to meaningful client engagements and build relationships that support your career growth.

Responsibilities:

• Design and implement cloud-based data architectures, integration patterns and data solutions using technologies such as Azure Data Factory, Event Hubs, Databricks, Microsoft Fabric, Synapse, Snowflake and BigQuery.
• Lead defined technical workstreams and contribute to the design and development of modern data platforms, pipelines, warehouses and lakehouse solutions.
• Apply data modelling techniques, including normalized and denormalized models, star schemas, schema-on-read, Data Vault and other approaches appropriate to client requirements.
• Design and implement data solutions using native cloud capabilities, established architecture patterns and engineering best practices.
• Support the development of cloud data migration, integration and modernization plans by assessing clients’ on-premises and cloud data environments.
• Gather, assess and translate complex business and technical requirements into structured analytics use cases and practical data solutions.
• Work directly with client stakeholders to understand business challenges, explain technical concepts and recommend appropriate approaches.
• Contribute to the successful delivery of client engagements by managing assigned deliverables, identifying risks and collaborating with project and client teams.
• Help clients understand their broader data and analytics journey and contribute to the design of capabilities that support business intelligence, analytics and artificial intelligence.
• Provide technical guidance, coaching and knowledge sharing to consultants and other team members.
• Collaborate with architects, developers, analysts and business stakeholders to ensure solutions meet business and technical requirements.
• Contribute technical expertise to proposals, estimates, statements of work and business development opportunities.
• Stay current with emerging cloud, data and analytics technologies and contribute to the development of internal best practices, reusable solutions and delivery approaches.

Skills & Qualifications

• Bachelor’s degree in computer science, engineering, mathematics, statistics, data science or another related technical or quantitative field, or an equivalent combination of education and experience.
• Approximately 5+ years of progressive experience in data and analytics, data engineering, cloud data platforms or a related field, ideally including experience in a consulting or client-facing environment.
• Strong hands‑on experience designing and implementing cloud‑based data and analytics solutions.
• Experience with Microsoft Azure and related data technologies. Exposure to Microsoft Fabric, Databricks, Snowflake, Google Cloud Platform or Amazon Web Services is considered an asset.
• Experience implementing data pipelines, data integration, data transformation and cloud‑based storage and processing solutions.
• Strong knowledge of data modelling concepts and techniques used to support analytical and mixed workloads.
• Experience with enterprise data concepts such as data warehouses, lakehouses, master data management, data catalogues and data governance.
• Experience implementing production cloud analytics platforms, preferably within the Microsoft ecosystem.
• Working knowledge of SQL and programming or data engineering technologies such as Python, PySpark or Spark.
• Experience with business intelligence and visualization technologies such as Power BI or Tableau.
• Understanding of continuous integration and deployment, DevOps practices and container technologies such as Docker or Kubernetes is considered an asset.
• Strong problem‑solving skills with the ability to translate business requirements into scalable technical solutions.
• Strong written and verbal communication skills, with the ability to explain technical concepts to both technical and non-technical audiences.
• Ability to build effective relationships with clients, team members and stakeholders across different areas of an organization.
• Cloud or data engineering certifications across Microsoft Azure, AWS, Google Cloud, Databricks or Snowflake are considered an asset.

Desired Skills

• Experience with modern data architecture approaches, including medallion architecture, lakehouse architecture and data governance.
• Experience working with Microsoft Fabric, Purview, Databricks, Azure and/or Snowflake.
• Experience contributing to or leading technical workstreams within complex data modernization or transformation projects.
• Ability to facilitate technical discussions and workshops with client stakeholders.
• Strong collaboration skills and the ability to work effectively within multidisciplinary and geographically dispersed teams.
• Experience with project and collaboration tools such as Microsoft 365, Teams, Visio and Smartsheet.
• Ability and willingness to travel based on client and business needs and to work from an MNP office or client site as required.

MY REWARDS @ MNP

With a focus on high-potential earnings, MNP is proud to offer customized rewards that support our unique culture and a balanced lifestyle to thrive at work and outside of the office. You will be rewarded with generous base pay, vacation time, 4 paid personal days, a group pension plan with 4% matching, voluntary savings products, bonus programs, flexible benefits, mental health resources, exclusive access to perks and discounts, professional development assistance, MNP University, a flexible ‘Dress For Your Day’ environment, firm sponsored social events and more

Diversity@MNP

We embrace diversity as a core value and celebrate our differences. We believe each team member contributes unique gifts and amplifying their potential makes our business stronger. We encourage people with disabilities to apply!