Analytics Engineer Role at Lightspeed
Summary
Senior Analytics Engineer in Lightspeed's Data Office designing and maintaining scalable data models that power financial reporting, go-to-market, and product analytics, translating business needs from Finance, Marketing, and Product into technical solutions. Core stack is SQL with BigQuery/Snowflake and dbt or Dataform.
This senior role involves designing and maintaining scalable data models for financial reporting, GTM analytics, and operational insights. You will transform complex business requirements from Finance, Marketing, and Product into clear technical solutions. Your work directly influences critical decisions within the organization.
Key Responsibilities: • Design data models supporting financial reporting and analytics • Turn business requirements into well-defined technical solutions • Collaborate with various teams to ensure seamless integration • Document model specifications and architecture thoroughly • Monitor and maintain data pipeline health proactively
Requirements: • Expert-level SQL skills and advanced analytical techniques • Experience with cloud data warehouses like BigQuery or Snowflake • Hands-on modeling for SaaS/CRM/ERP systems • Proficient in Dataform or dbt for production use • Strong communication skills with technical and non-technical teams
Drive the development of key analytics models while mentoring others and ensuring data quality at Lightspeed.