Presales Solutions Architect

17 hours ago

Winnipeg, Manitoba, Canada Mathco Full-time
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