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 for financial reporting, GTM analytics, product insights, and operational insights .
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in SQL and data modeling for financial reporting and analytics, with a strong focus on designing scalable solutions and collaborating across teams. Proficient in managing data pipeline health and mentoring junior engineers while ensuring compliance with security standards.
Highest-signal resume keywords
Expert-Level SQLData Modeling on BigQuery or SnowflakeProduction Expertise with Dataform or dbtSecurity and Compliance KnowledgeEffective Communication with Stakeholders
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQLData ModelingDimensional ModelsPerformance OptimizationDataformDbtLookMLPythonJavaScriptIncremental Strategies
Soft Skills
Effective CommunicationMentoringCollaboration
Tools & Technologies
BigQuerySnowflakeSalesforceNetSuiteLookerCI/CD
Industry Keywords
Financial ReportingGTM AnalyticsSaaSCRMERPGDPRSOX
Tech Stack
Tools & technologiesBigQueryERPJavaScriptPythonSnowflakeSQL
About the role
Key responsibilities & impact- Design and build data models for financial reporting, GTM analytics, product insights, and operational insights
- Design scalable and maintainable models while shipping incremental value and iterating based on feedback
- Translate ambiguous requirements from Finance, Revenue Ops, Marketing, and Product into technical solutions with effort estimates
- Collaborate with upstream data owners, downstream Looker/LookML developers, and domain pods across the Hub & Spoke architecture
- Produce documentation including column descriptions, model contracts, and architectural notes
- Diagnose root problems and implement systemic fixes
- Own pipeline health, proactively monitor systems, lead incident response, and surface risks
- Manage sprint commitments and contribute to task breakdown, estimation, and priority sequencing
- Mentor junior engineers through coaching, code reviews, and technical sessions
- Help evolve team standards and canonical data models relied upon by leadership
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 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 source-system object models into dimensional schemas
- Proven production expertise with Dataform or dbt, including materializations, incremental strategies, snapshots, and macros
- Effective communication with technical and non-technical stakeholders
- Security and compliance knowledge, including GDPR, SOX, and data access controls
- Fluency in English as a working language
- Applicants must disclose criminal convictions and undergo criminal record checks
- CI/CD experience, Python or JavaScript, LookML, data contracts, AI/LLM-assisted tooling, and revenue/finance domain knowledge are bonuses
Benefits
Comp & perks- Flexible work environment
- Flexible paid time off and remote work policies
- Equity options
- Contributions to pension plan
- Training opportunities
- Health and wellness credit
- Time off to volunteer
- Interest groups, employee-led networks, social committees, and sponsored sports teams
- Computer purchase program for a personal MacBook
- Enhanced parental leave
- Lightspeed equity scheme
- Unlimited paid time off policy
- Ability to work from pretty much anywhere in the world for 60 days a year
- Health, dental, vision, and life insurance for eligible dependents
- Employer RRSP contribution of up to 4% of base salary to a maximum of $5,000
- Health and wellness benefit of $500 per year
- Interest-free loan to purchase certain Apple products
- Paid leave and assistance for new parents
- Mental health online platform and counselling & coaching services
- Volunteer day
- Snacks, coffee, teas, Tuesday pancakes, Wednesday lunch, and Thursday happy hour in the office kitchen
- Continuous learning opportunities
- Global mobility
- Inclusive and diverse workplace