Avatar for TheMathcompany
build and enhance analytical capabilities for Fortune-500 organizations across the world
  • B2B
  • Scale Stage
    Rapidly increasing operations

Presales Solutions Architect

  • Old Toronto
  • |8 years of exp
  • |Full Time
Posted: 5 days ago
Job Location
Old Toronto
Remote Work Policy

In office

Visa Sponsorship

Not Available

RelocationAllowed
Skills
Python
Git
DevOps
Data Integration
Data Security
Data Warehouse Architecture
Azure
Monitoring
Supply Chain Analytics
Data Quality
testing
Apache Spark
AWS
Spark SQL
Customer Analytics
Dimensional Modeling
Pyspark
Advanced SQL
Airflow
ETL Design
Infrastructure as code
GCP
E-Commerce Analytics
Azure Data Factory
databricks
DBT
CI/CD
Data lake architecture
Observability
Delta Lake
Inventory Analytics
Pricing Analytics
Client-Facing Consulting
ELT Design
Large-Scale Data Processing
Databricks Workflows
Lakehouse Architecture
Snowflake Architecture
Databricks Notebooks
Retail Domain
Databricks Jobs
Snowflake Data Modeling
Spark Transformations
Spark Performance Tuning
Operational Support Frameworks
Snowflake RBAC
Snowflake Data Sharing
Enterprise Data Governance
End-to-End Solution Design
Snowflake Performance Tuning
Snowflake Dynamic Tables
Merchandising Analytics
Business Stakeholder Engagement
Business Requirement Translation
Snowflake Snowpark
Snowflake Security
Snowflake Governance
Snowflake Cost Optimization
Snowflake Snowpipe
Snowflake Warehouse Optimization
Technical Discussion Leadership
Technical Solution Proposal
Snowflake Streams and Tasks
Ingestion to Serving
Technology Option Evaluation
Snowflake Vs Databricks/Spark Evaluation
Technical Direction Recommendation
Architect Engagement
Engineering Team Engagement
Client Decision Influence
CPG Domain
Promotions Analytics
Store Operations Analytics
Category Management Analytics

About the job

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.

About the company

TheMathcompany company logo
build and enhance analytical capabilities for Fortune-500 organizations across the world501-1000 Employees
  • B2B
  • Scale Stage
    Rapidly increasing operations
Learn more about TheMathcompany image

Funding

AMOUNT RAISED
$50M
FUNDED OVER
1 round
Round
S
$50000000
Seed - Jan 2022