Senior Lead, Product Finance

Name*

Email*

Resume*

Linkedin Profile*

Location*

Start typing and select a location from the dropdown.

Do you have the right to work in your listed location?

Which track are you interested in pursuing with Shopify?*

Please confirm you've read and agree with our candidate NDA

NDA here

Please confirm you've read our applicant privacy notice

Privacy notice here

Please confirm if you agree to your Shopify interview(s) being recorded and transcribed to help improve our hiring process. Agreeing/not agreeing to recording has no impact on our hiring decision.

What was Shopify’s gross profit dollars for Q1 2023?*

In which quarter of 2019/2020 did Shopify record positive net income for the first time as a public company?*

Do you have experience working in one of the following industries? Select all that apply.*

Investment BankingManagement ConsultingCorporate FP&ACorporate FinanceTech

Do you have experience working on a company’s reporting cycle?*

Do you have experience working in the payments, online banking, or fintech space?*

Do you have experience using Microsoft Excel or Google Sheets to create a financial model? If so, how would you characterize your skill level?*

Please rate your SQL knowledge/expertise.*

In 200 words or less, please describe what motivated you to apply to Shopify?*

Please identify and explain why this query wouldn’t work, and then provide a corrected version of the query:*

SELECT field1, COUNT(field2) AS field2_count, SUM(field3) AS field3_sum AVG(field4) AS field4_avg

FROM table1

LIMIT 10

INNER JOIN table2 ON table1.id = table2.id

LEFT JOIN table3 ON table1.id = table3.id

WHERE condition is 'value'

ORDER BY field2_count DSC

Application