FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Senior Analytics Engineer
Lightspeed Commerce. Design and build data models supporting financial reporting, GTM analytics, and product and operational insights .
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in designing and building data models for financial reporting and analytics, with a strong focus on SQL, cloud data warehouses, and collaboration across teams. Proficient in mentoring junior engineers and managing data pipeline health while ensuring compliance with data regulations.
Highest-signal resume keywords
Expert-Level SQLEnterprise-Grade Dimensional ModelingDataform or dbt Production ExpertiseUnderstanding of GDPR and SOXExperience with CI/CD and Automated Testing
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQLDimensional ModelingDataformDbtBigQuerySnowflakePythonJavaScriptLookMLData Contracts
Soft Skills
CollaborationMentoringProblem-SolvingDocumentation
Tools & Technologies
CI/CDAutomated TestingLintingDeployment Workflows
Industry Keywords
Financial ReportingGTM AnalyticsCRMERPRevenue OpsData Access ControlsAI/LLM-Assisted DevelopmentRevenue Domain Knowledge
Tech Stack
Tools & technologiesBigQueryCloudERPJavaScriptPythonSQL
About the role
Key responsibilities & impact- 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
What you’ll need- 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
Comp & perks- 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