Analytics Engineer
Hi there! Thanks for stopping by 👋
Analytics Engineer
What you’ll be responsible for
- 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
What 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 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
- As 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 domain
- Experience in working with SaaS solutions
- Solid knowledge of cloud services (AWS and GCP in particular)
What’s in it for you
Be a changemaker You'll enjoy:
- 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
Plus benefits designed to keep you happy, healthy and fulfilled.
- 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
- Paid leave and assistance for new parents
- Mental health online platform and counselling & coaching services
- Volunteer day
- We 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 communities Please 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.
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?
Who we are
Not included in the source posting: what you'll do, qualifications, benefits.
Skills
Who can apply
The employer didn't state any visa, work authorization, citizenship or clearance requirements in this posting. Confirm with the employer before applying.
Read automatically from the employer's posting text. Always confirm with the employer — requirements can change after a job is published.