Analytics Engineer

Analytics Engineer

Trolley is growing quickly and we are hiring for a full-time Analytics Engineer to join our team.

Hybrid role based in our Montreal, Toronto, or Halifax office.

About us:

Trolley is the payouts platform for the internet economy. Our vision is to unlock the collective economic opportunity of the internet – for everyone – by building a truly global payouts ecosystem. Through our powerful platform and API, Trolley enables businesses to reach people from all corners of the world and offer creators, on-demand workers, and suppliers the ability to bring their specialized talents to a global market. Businesses use Trolley to automate and manage payouts, collect recipient tax and banking information, and mitigate fraud and risk. It is the go-to payouts solution for hundreds of businesses like Canva, Soundcloud, and Envato, ensuring creators, artists, and suppliers get paid efficiently. Trolley has processed millions of payments, supporting musicians, artists, makers, vendors, and suppliers worldwide.

Trolley is seeking a self-driven, analytical individual to join our team as an Analytics Engineer. Reporting to the Senior Manager, Analytics, this role manages the end-to-end data pipeline. You will be responsible for empowering data informed decisions throughout the Trolley team, our Merchants, and Recipients. The ideal candidate will have experience with the toolset required (ELT, Warehousing, BI, etc) and have driven healthy data cultures across organizations.

Responsibilities:

• Extract and Load through any means possible. Connectors, API, CSV, and more.
• Transform data for enabling others to query and service themselves with ever-expanding use-cases.
• Be fluent in modern AI tools and look for ways to apply them to real business problems.
• Champion AI adoption across the organization, spot opportunities, experiment with new approaches, and help others unlock value from AI.
• Scale the Data Pipeline to manage costs, speeds, and security trade-offs.
• Collaborate with internal and external stakeholders to design and develop reports that speak for themselves, enabling business operations and reporting.
• Own and lead Data Initiatives.
• Collaboration with the Engineering team for best practices, and improved technical management of Data Pipelines.
• Mature business-wide analysis acumen and enablement.
• Perform ROI Analysis on Trolley’s Key Initiatives.
• Complete other duties and responsibilities as defined by the management team.

Requirements:

• Experience with end-to-end management of data pipelines
• Excellent communication of data related topics
• Strong SQL Skills
• Experience with version control systems(eg Git)
• Experience using techniques that enable team code ownership (test-driven development, literate code, separation of concerns)

Nice-to-haves:

• Databricks (or Snowflake)
• Sigma Computing, our Business Intelligence tool
• Cloud Services (AWS, GCP)
• Spark
• Performance Logging and Monitoring

What we offer:

• Competitive base salary and meaningful equity (ESOP).
• Join an amazing team of diverse people working together on a common mission.
• Extended Healthcare benefits including dental, vision, LTD, etc. from day 1.
• 4 weeks paid vacation per year + public holidays (+ 1 extra vacation day per year of service).
• 30 days remote work from anywhere.
• Gym membership allowance.
• 1/2 day Fridays off during summer.
• Company-provided use of Apple MacBook Pro and Mac gear.

#LI-HYBRID