Senior Analytics Engineer building scalable data pipelines and AI - native analytics foundations at Mercury, a fintech company. Supporting agentic tooling, self - service analytics, governance, and data products.
About the role
- Senior Analytics Engineer designing financial, GTM, and product data models for Lightspeed’s cloud commerce platform. Owning pipelines, documentation, and analytics foundations used across the business.
Responsibilities
- Design and build data models supporting financial reporting, GTM analytics, and product and operational insights
- Design scalable and maintainable solutions while shipping incremental value and iterating based on feedback
- Translate ambiguous requirements from Finance, Revenue Ops, Marketing, and Product into scoped technical solutions with effort estimates
- Collaborate across the Hub & Spoke architecture with upstream data owners, downstream Looker/LookML developers, and domain pods
- Produce documentation including column descriptions, model contracts, and architectural notes
- Diagnose root problems and drive systemic fixes
- Own pipeline health through proactive monitoring, incident response, and risk identification
- Manage sprint commitments and contribute to team planning, task breakdown, estimation, and prioritization
- Mentor junior engineers through coaching, code reviews, and technical sessions
- Design canonical data models unifying fragmented systems across CRMs, ERPs, and product platforms
Requirements
- Expert-level SQL, including query performance, maintainable code, and advanced analytical techniques such as window functions
- Experience designing enterprise-grade dimensional models on modern cloud data warehouses such as BigQuery or Snowflake
- Knowledge of partitioning, incremental patterns, and performance optimization
- Hands-on experience modelling SaaS, CRM, or ERP source systems such as Salesforce or NetSuite
- Understanding of translating CRM/ERP object models into dimensional schemas
- Proven production expertise with Dataform or dbt, including materializations, incremental strategies, snapshots, and macros
- Understanding of GDPR, SOX, and data access controls
- Experience with CI/CD, automated testing, linting, and deployment workflows is a bonus
- Python or JavaScript for data engineering tooling is a bonus
- LookML or equivalent semantic layer experience is a bonus
- Familiarity with data contracts for pipeline validation is a bonus
- Experience using AI/LLM-assisted development tooling is a bonus
- Revenue and finance domain knowledge is a bonus
- Applicants must disclose criminal convictions; criminal record checks are part of the hiring process
- Must be legally eligible to work in the country where the role is advertised, with visa sponsorship requirements addressed
Benefits
- Flexible work environment and remote work policies
- Flexible paid time off
- Equity options and Lightspeed equity scheme
- Pension plan contributions / employer RRSP contribution of up to 4% of base salary to a maximum of $5,000
- Training opportunities and continuous learning
- Health and wellness credit of $500 per year
- Time off to volunteer / volunteer day
- Interest-free loan through the Employee Technology Purchase Program for certain Apple products
- Enhanced parental leave and paid leave and assistance for new parents
- Health, dental, vision, life, and disability insurance for employees and eligible dependents
- Mental health online platform and counselling and coaching services
- Global mobility
- Interest groups, employee-led networks, social committees, and sponsored sports teams
- Computer purchase program for a personal MacBook
- Unlimited paid time off policy
- Ability to work from pretty much anywhere in the world for 60 days a year
- Office snacks, coffee, tea, weekly pancakes, lunch, and happy hour
- Career growth opportunities
- Developer experience and tooling investment
Job title
Job type
Experience level
Salary
Degree requirement
No Education Requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Senior Analytics Engineer shaping Fleetio’s fleet - management data platform. Building dbt models, semantic layers, dashboards, and AI - enabled analytics solutions.
Senior Business Systems Analyst modernizing Boeing Canada’s defence sustainment systems and cloud data platforms. Translating mission needs into requirements, analytics, integrations, and reporting solutions.
Senior Analytics Engineer building GTM pipelines, metrics, dashboards, and AI data tools. Supporting Motive’s platform for safer, more productive physical operations.
Data Analytics Engineer building trusted SQL data systems for Toptal, a global talent network. Owning transformation, governance, warehousing, and AI - enabled analytics foundations.
Analytics Engineer building dbt models, AI - ready datasets, and Tableau reporting for Movable Ink’s content personalization platform. Translating stakeholder needs into trusted metrics and business intelligence.
Principal leading client relationships and delivery teams for Teragonia’s AI operating system for private equity. Driving engagement outcomes, account growth, and cross - functional analytics solutions.
Staff Analytics Engineer leading analytics architecture, dbt models, and semantic layers at Render. Building trusted data foundations for AI - assisted decision - making across the developer cloud platform.
Lead Data/Analytics Engineer powering analytics and AI products for Dutch’s veterinary telemedicine platform. Owning event instrumentation, experimentation, data pipelines, and trusted metrics.
Senior Analytics Engineer building Fulfillment IQ’s Workbench data and analytics engine. Automating messy supply chain data processing into product - ready datasets.