• Develop interactive dashboards and reports using tools like Power BI or Tableau • Translate business requirements into scalable data models and reporting solutions • Implement and validate complex business logic within reporting layers • Write and optimize advanced SQL queries for data extraction and transformation • Work with Snowflake (or similar cloud data warehouses) for data sourcing • Support User Acceptance Testing (UAT), including defect resolution and enhancements • Collaborate with business stakeholders, data engineers, and QA teams • Maintain and enhance existing BI solutions for performance and usability

• Develop and maintain ETL/ELT pipelines using PySpark and Python in Databricks • Build and extend data transformations across Bronze, Silver, and Gold layers of the medallion architecture • Write well-structured, readable, and testable code following team standards and review feedback • Troubleshoot and resolve data pipeline failures, with escalation to senior engineers for complex issues • Contribute to pipeline documentation including data flow diagrams and inline code comments • Write and optimize T-SQL queries, stored procedures, and views in SQL Server • Support data loads and transformations that feed the SQL Server data warehouse • Assist in identifying and resolving query performance issues with guidance from senior engineers • Apply basic indexing knowledge and understand schema design patterns used by the team • Write unit tests and data quality checks for pipelines developed or modified • Use established data quality frameworks and tooling consistent with team standards • Investigate and escalate data anomalies or quality issues found in pipelines • Participate in code reviews — both receiving and providing constructive feedback as skills develop • Collaborate with teammates during sprint planning, standups, and retrospectives • Communicate blockers and progress clearly to your manager and team • Work with data analysts and other stakeholders to understand requirements for assigned work

• Own how data moves from Inato's platform into the hands of the people who depend on it — our product squads, CS and Marketing teams, sponsors, and sites. • Enable trusted self-service at scale. • Prove the value of our new product offerings faster. • Ship data products directly into the user experience. • Partner with Product squads (PMs, engineers, designers), with regular touchpoints into CS, Marketing, and Sponsor / Site Ops. • Own metric definitions, build the semantic layer powering our AI-driven self-service in Hex. • Translate vague operational pains into working data assets in days — from real-data prototype to production-grade pipeline. • Own the tables consumed by the product itself, and the user-facing dashboards that sponsors, sites, and internal teams rely on day to day. • Automate the parts of data work that don't need a human in the loop so the team can keep pace as new offerings multiply and Inato grows.

Role Description Join Lightspeed's fast-growing Financial Services division as a talented and passionate Analytics Engineer on our FS Data team. In this key role, you'll be instrumental in overseeing all analytic and reporting needs, contributing directly to the success of every domain within Financial Services. If you have worked on data pipelines, have great communication skills, are familiar with data modeling and have helped teams to gather both predictive and historical insights, you might be a great fit for this role! This role also involves collaborating with multiple functions across Lightspeed, including Application Engineering, Product, Operations, Risk and Finance among others. For this role, you should be located in Canada, and able to work within EST/EDT hours. We offer a choice of fully remote, partially remote or fully office-based work environments (in cities with local offices). Responsibilities - Cleanse and transform raw data into business logic to help stakeholders build reports and data models - Analyze raw data and suggest data sources that best meet expressed business needs - Ensure the right data gets to the right people at the right time - Collaborate with the Central Data Team to build data pipelines in accordance with shared best practices and design, and feed data models for usage - Act as a champion for data quality and usability across the Financial Services organization - Ensure availability, quality and searchability of data and documentation - Write, clean and maintainable queries and scripts that are highly performing, well-structured and easy to understand and extend using version control and CI/CD - Automate testing of data models and add appropriate validations to ensure quality - Help define and improve our internal standards for data models and infrastructure - Ability to explain intermediate to complex information to other team members - Ability to maintain or develop simple report or dashboard in Looker Qualifications - Experience with SQL and Python coding (or equivalent language) - Experience with MPP data warehouse (we use BigQuery) - Experience with dbt or dataform - Experience in performing data profiling, data mapping and data quality validation - Experience with data orchestrator - Understanding of industry standards for data warehousing and data modelling - Knowledge of data environments (we use GCP) as well as containerization solutions - Experience in source control, CI/CD and automated testing - A security mindset with the ability to work with compliance protocols (SOX, GDPR) - Excellent communication skills and ability to communicate with technical and non-technical stakeholders - Excellent problem-solving skills - Ability to work independently and in teams - Self-motivated and great at taking initiative Requirements - Experience in the Payments or Financial Services domain - Experience in working with SaaS solutions - Solid knowledge of cloud services (AWS and GCP in particular) Benefits - A flexible work environment that empowers you to do your best work - A culture that celebrates performance - The chance to make an impact in a team that’s big enough for career growth, but lean enough to make your voice heard - Career-defining opportunities - Flexible paid time off and remote work policies - Equity options, because this is your company too - Contributions to your pension plan. Your future matters - Training opportunities to grow your skills and career - Health and wellness credit so you feel your best - Time off to volunteer and give back to your community - Interest groups, employee-led networks, social committees to sponsored sports teams - Computer purchase program to get your personal MacBook - Enhanced parental leave to support growing families - Lightspeed equity scheme (we are all owners) - Unlimited paid time off policy - People Experience - Our PX benefit allows you to work from pretty much anywhere in the world for 60 days a year - Health insurance: Immediate access to health, dental, vision, and life insurance for you and your 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 - Employee Technology Purchase Program: Ability to an interest-free loan to purchase certain Apple products - LinkedIn Learning: Free access to LinkedIn learning along with your career GPS to help you learn & grow - Paid leave and assistance for new parents - Mental health online platform and counselling & coaching services - Volunteer day - A variety of snacks, coffee, and teas are always accessible and available in the office kitchen