Back to results

Presales Solutions Architect

  • Toronto, ON, Canada

Full-time

Apply on LinkedIn About employer

Applications open in a new tab.

Job details

Job type
Full-time
Apply by
Posting language
English
Posted

Original job description

About MathCo

MathCo is a global Enterprise AI and Analytics company helping organizations build and scale data-driven decision-making. We combine deep domain expertise, advanced analytics, engineering, and AI capabilities to solve complex business challenges across Marketing, Customer, Supply Chain, Commercial, and Enterprise functions.

As part of our Marketing Analytics practice, we help leading consumer goods, retail, and enterprise organizations optimize marketing investments through advanced measurement, forecasting, and decision intelligence solutions.

Role Overview

MathCo’s resident technical leader at the Sobeys client location, responsible for driving solution architecture, technical governance, stakeholder engagement, and engineering excellence across multiple data and analytics programs. The role requires a strong mix of Snowflake expertise, Databricks/Spark experience, retail domain knowledge, consulting capability, and hands-on problem-solving skills.

Most of the client’s work is on Snowflake, with a meaningful share on Databricks and Spark, and some work on Palantir. The person will work with business and technical SMEs and leadership across business units, bridge them with onshore and offshore engineers, and stay hands-on. They build POCs, propose solutions, and unblock teams without relying on offshore for technical work.

Key Responsibilities

  • Serve as the onsite technical lead and trusted advisor across Sobeys projects and business functions.
  • Provide technical oversight across multiple concurrent projects and workstreams, ensuring consistency of architecture, engineering standards, and delivery quality.
  • Bridge client business SMEs, client technical SMEs, and onshore/offshore engineering teams, turning business needs into clear technical tasks.
  • Lead discovery sessions, architecture discussions, technical workshops, and solution reviews with client stakeholders.
  • Build POCs, prototypes, and accelerators on Snowflake and Databricks/Spark, and propose solution approaches and architectures to the client.
  • Define solution approaches, architecture standards, and engineering best practices across programs.
  • Review designs, code, and data models for scalability, performance, security, maintainability, and cost.
  • Mentor and guide engineers across engagements and troubleshoot critical issues hands-on.
  • Support estimation, technical planning, risk and dependency management, and solution governance.
  • Drive adoption of modern engineering practices, including CI/CD, automation, and IaC.
  • Identify opportunities for optimization, innovation, and expansion of work within the client.
  • Flag risks and blockers early to the engagement manager and delivery leads.

Must-Have Skills

  • Snowflake (primary): architecture, data modeling, Snowpipe, Streams and Tasks, Dynamic Tables, Snowpark, performance tuning, warehouse and cost optimization, RBAC, security, governance, and data sharing.
  • Apache Spark (mandatory): hands-on experience delivering at least one Spark-based project (PySpark or Spark SQL), including large-scale data processing, transformations, and performance tuning.
  • Databricks: working experience or solid familiarity with Delta Lake, notebooks, workflows/jobs, and Lakehouse architecture. Unity Catalog exposure is a plus.
  • Data engineering: advanced SQL and Python, ETL/ELT design, data integration, dimensional modeling, and data warehouse, data lake, and Lakehouse architectures.
  • Orchestration and transformation: Airflow, dbt, Azure Data Factory, or equivalent.
  • Cloud: hands-on with at least one of Azure, AWS, or GCP.
  • Engineering practices: Git, CI/CD, DevOps, Infrastructure as Code, testing, data quality, monitoring, and observability.
  • Architecture: end-to-end solution design (ingestion to serving), evaluating technology options (including when to use Snowflake vs Databricks/Spark), and recommending technical direction.
  • Governance: enterprise data governance, security, and operational support frameworks.
  • Client-facing consulting experience: proven experience leading technical discussions with business stakeholders, architects, and engineering teams. Ability to translate business requirements into technical solutions and influence client decisions.
  • Retail domain: experience in retail or CPG, such as merchandising, supply chain, inventory, pricing and promotions, loyalty, customer analytics, store operations, category management, or e-commerce analytics.

Good-to-Have

  • Advanced data modeling: experience with enterprise data models, conceptual/logical/physical modeling, Data Vault, or retail data models, and tools such as erwin or ER/Studio.
  • Palantir: exposure to Palantir Foundry (data integration, pipelines, ontology, or application building).
  • BI exposure (Power BI, Tableau).
  • AI/ML or GenAI on Snowflake (Cortex, Snowpark ML).
  • SnowPro or Databricks certifications.

Experience

  • L3 (Senior Data Engineer): 6-8 years in data engineering or architecture, with 3+ years on Snowflake, at least one Spark project delivered, and prior client-facing exposure. Hands-on delivery and technical support across projects.
  • L4 (Lead Data Engineer): 8-12 years, with proven ownership of architecture across Snowflake and Spark/Databricks, experience leading workstreams or teams, and engaging client leadership.
  • Prior onsite, consulting, or customer-facing delivery experience is strongly preferred, as is experience leading offshore or distributed teams.

Soft Skills

  • Strong communication and presentation skills for both technical and business audiences, including senior leadership.
  • Stakeholder management across multiple concurrent threads.
  • Consulting mindset: structured problem solving, ownership, and a proactive approach.
  • Ability to influence technical decisions and guide teams without formal authority.
  • Self-driven and comfortable with ambiguity when working independently on site.
More about this job

Responsibilities

Lead technical architecture, governance, and delivery quality across multiple Sobeys data and analytics programs, serving as an onsite advisor and connecting business stakeholders with engineering teams. Build prototypes, review designs and code, mentor engineers, troubleshoot issues hands-on, and guide technical planning, optimization, and innovation.

Requirements

Requires 6–12 years of data engineering or architecture experience, strong Snowflake expertise, and hands-on delivery of at least one Apache Spark project, with Databricks familiarity and cloud experience. Candidates should also bring client-facing consulting and stakeholder leadership skills, advanced SQL and Python, engineering and governance practices, and retail or CPG domain experience.

Skills

  • Snowflake
  • Apache Spark
  • Databricks
  • Data Engineering
  • Solution Architecture
  • Advanced SQL
  • Python
  • Data Modeling
  • ETL/ELT
  • Cloud Platforms
  • Data Governance
  • CI/CD
  • Infrastructure as Code
  • Client-Facing Consulting
  • Retail Analytics
  • Stakeholder Management

Visa sponsorship

Not detected in the job text

Categories

  • Data & Analytics
  • Technology
  • Software
  • Consulting
  • Retail

Keywords

  • Snowflake
  • Apache Spark
  • PySpark
  • Spark SQL
  • Databricks
  • Delta Lake
  • Unity Catalog
  • Palantir Foundry
  • Snowpark
  • Snowpipe
  • Streams And Tasks
  • Dynamic Tables
  • Advanced SQL
  • Python
  • ETL/ELT
  • Dimensional Modeling
  • Data Warehousing
  • Lakehouse Architecture
  • Airflow
  • dbt
  • Azure Data Factory
  • Azure
  • AWS
  • Google Cloud Platform
  • CI/CD
  • Infrastructure As Code
  • Data Governance
  • Retail Analytics
  • Marketing Analytics
  • Power BI

Report this job

Get in touch
MovoJobs

How can we help?