Analytics Engineer

Hi there! Thanks for stopping by Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place!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).What you’ll be responsible for: Cleanse and transform raw data into business logic to help stakeholders build reports and data modelsAnalyze raw data and suggest data sources that best meet expressed business needsEnsure the right data gets to the right people at the right timeCollaborate with the Central Data Team to build data pipelines in accordance with shared best practices and design, and feed data models for usageAct as a champion for data quality and usability across the Financial Services organizationEnsure availability, quality and searchability of data and documentationWrite, clean and maintainable queries and scripts that are highly performing, well-structured and easy to understand and extend using version control and CI/CDAutomate testing of data models and add appropriate validations to ensure qualityHelp define and improve our internal standards for data models and infrastructure Ability to explain intermediate to complex information to other team membersAbility to maintain or develop simple report or dashboard in LookerWhat you will bring to the team:Experience with SQL and Python coding (or equivalent language)Experience with MPP data warehouse (we use BigQuery)Experience with dbt or dataformExperience in performing data profiling, data mapping and data quality validationExperience with data orchestratorUnderstanding of industry standards for data warehousing and data modellingKnowledge of data environments (we use GCP) as well as containerization solutionsExperience in source control, CI/CD and automated testingA security mindset with the ability to work with compliance protocols (SOX, GDPR)Excellent communication skills and ability to communicate with technical and non-technical stakeholdersExcellent problem-solving skillsAbility to work independently and in teamsSelf-motivated and great at taking initiativeAs a global company with employees and clients outside of Quebec, fluency in English as a working language is required for this position.Some additional things that would be a bonus:Experience in the Payments or Financial Services domainExperience in working with SaaS solutionsSolid knowledge of cloud services (AWS and GCP in particular)What’s in it for you: Be a changemakerYou’ll enjoy:A flexible work environment that empowers you to do your best workA culture that celebrates performanceThe chance to make an impact in a team that’s big enough for career growth, but lean enough to make your voice heardCareer-defining opportunitiesPlus benefits designed to keep you happy, healthy and fulfilled.Flexible paid time off and remote work policies Equity options, because this is your company tooContributions to your pension plan. Your future mattersTraining opportunities to grow your skills and careerHealth and wellness credit so you feel your bestTime off to volunteer and give back to your communityInterest groups, employee-led networks, social committees to sponsored sports teamsComputer purchase program to get your personal MacBookEnhanced parental leave to support growing familiesLightspeed equity scheme (we are all owners)Unlimited paid time off policyPeople 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 yearEmployee Technology Purchase Program: Ability to an interest-free loan to purchase certain Apple productsPaid leave and assistance for new parentsMental health online platform and counselling & coaching servicesVolunteer dayWe got you covered! A variety of snacks, coffee, and teas are always accessible and available in the office kitchen - Tuesday - Thursday: Lunch is served, and Thursday is Happy Hour with a variety of drinks and snacks.Fuel your growth. Find your people.At Lightspeed, your growth is our priority. We invest in you with continuous learning opportunities, global mobility and benefits designed to support you—all within a driven, diverse and inclusive team that’s passionate about empowering our communitiesPlease note that we ask applicants to disclose any criminal convictions, and we conduct criminal record checks as part of our hiring process for this role.At Lightspeed, we carefully consider a wide range of factors when determining compensation, including your skill set, qualifications, experience, and market data. These considerations can cause your compensation to vary. We reasonably expect the total compensation for this position to be in the range of $100,000 TO $115,000 CAD. Lightspeed also provides a variety of employee benefits including, but not limited to, medical, dental, wellness, life and disability insurance, RRSP plan and match, paid parental leave top-up, and paid time off.Please note that this compensation information is solely for candidates hired to perform work within Ontario (update to BC if posted in Vancouver) and reflects the amount Lightspeed is willing to pay at the time of this posting. This role represents an existing vacancy at Lightspeed. Lightspeed uses artificial intelligence–enabled tools to support certain aspects of the recruitment process; all hiring decisions are made by our recruiting and hiring teams.To all recruitment agencies: Lightspeed does not accept unsolicited agency resumes. If we have not directly engaged your company in writing to supply candidates for a specific vacancy, Lightspeed will not be responsible for any fees related to unsolicited resumes.Lightspeed is a proud equal opportunity employer and we are committed to creating an inclusive and barrier-free workplace. Lightspeed welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.Where to from here?Obviously, this has to be mutually beneficial: we want you to step into a role you love, and we want to offer you a place you’re proud to come to every day. For a glimpse into our world check out our career page here.Lightspeed is building communities through commerce, and we need people from all backgrounds and lived experiences to do that. We were founded in 2005, in Montreal’s gay village and our original members were all part of the LGBTQ+ community. The ethos of our business has been about inclusion from the very beginning, and we strive to provide a workplace where everyone belongs.Who we are: Powering the businesses that are the backbone of the global economy, Lightspeed's one-stop commerce platform helps merchants innovate to simplify, scale, and provide exceptional customer experiences. Our cloud commerce solution transforms and unifies online and physical operations, multichannel sales, expansion to new locations, global payments, financial solutions, and connection to supplier networks.Founded in Montréal, Canada in 2005, Lightspeed is dual-listed on the New York Stock Exchange (NYSE: LSPD) and Toronto Stock Exchange (TSX: LSPD). With teams across North America, Europe, and Asia Pacific, the company serves retail, hospitality, and golf businesses in over 100 countries.Lightspeed handles your information in accordance with our Applicant Privacy Statement.