Data Analyst II - Hospitality Data Team

Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place!

Lightspeed is a forward-thinking company dedicated to driving innovation in the hospitality industry through data. We leverage data insights to support strategic decisions and enhance our product offerings. As a Data Analyst 2, you will bring your expertise to an expanding team within the Hospitality unit's product department. This team acts as a strategic data partner, working closely with diverse product squads to provide expert insights and data-driven solutions that inform development decisions and optimize product performance. As a key player in shaping Lightspeed’s future, you’ll play an integral role in building actionable data expertise within our forward-looking organization.

What You'll Do:

1. Collaborate with Cross-Functional Teams: Partner with Product Managers, Developers, Designers, and other stakeholders to understand their data needs, delivering tailored, strategic data solutions. Clearly communicate complex data insights to both technical and non-technical audiences, ensuring alignment across teams.
2. Lead Advanced Data Analysis: Perform and lead complex analyses, such as segmentation, customer health assessments, and impact measurements of development initiatives, guiding product direction and business decisions.
3. Develop Data Warehouse Solutions: Create, maintain, and test scalable data warehouse solutions using Python to ensure data integrity and reliability. Implement automated testing frameworks and leverage CI/CD pipelines to proactively identify opportunities for continuous improvement in data infrastructure.
4. DynamoDB Data Extraction and Visualization: Script advanced interactions with DynamoDB to extract data and develop real-time visualizations that provide critical business insights.
5. Dashboard and Report Development: Build, optimize, and innovate dashboards using tools like Heap and BigQuery to visualize key performance indicators (KPIs) and inform data-driven decisions.
6. Innovative Problem-Solving: Take ownership of complex data challenges, proactively supporting Product teams with data-driven insights that empower informed decision-making.
7. Generate Business Insights: Translate complex data sets into actionable business insights, helping teams understand product performance through behavioral analysis and key metrics.
8. Customer Data Platform Management: Optimize the data flow through platforms like Segment to ensure effective use of customer data in product development and customer success strategies.

What You'll Bring:

1. Experience: 5+ years of professional experience using Python for data analysis, including advanced scripting and real-time data processing.
2. 5+ years of experience with SQL, with familiarity in BigQuery and Dataform as a plus.
3. Experience scripting and accessing data in DynamoDB.
4. Technical Skills:
5. Python Proficiency: Expertise in data extraction, processing, and advanced analyses (Pydantic, Scikit-learn, Poetry).
6. SQL Proficiency: Advanced skills in SQL for querying large datasets and data manipulation.
7. Version Control: Experience with Git, including collaborating through commits, pull requests (PRs), and code reviews.
8. Data Warehousing: Strong knowledge of data warehouse development and testing using Python and SQL, with experience in cloud-based platforms such as BigQuery.
9. Data Visualization: Experience with real-time data visualization tools like Matplotlib, Plotly, or Dash.
10. As a Plus:
11. Experience with customer data platforms like Segment and analytics tools such as Heap.
12. Familiarity with AWS CLI and SDKs (e.g., Boto3 for Python) to interact with AWS.
13. Experience working with data warehouses, particularly Dataform or similar data transformation frameworks.

Business Acumen & Creativity: Ability to translate complex data into actionable business insights and present them effectively, with a creative approach to solving data challenges.

Thrive in a dynamic, cross-functional environment, working closely with various teams to meet business needs.

What’s in it for you:

• Lots of autonomy, flexible work culture with the option of working remotely or from one of our beautiful offices.
• Genuine career growth opportunities within a company that's continuously expanding.
• Be part of a team large enough for growth yet agile enough for real impact.
• Work on high-traffic products with a global user base.
• Opportunity to work alongside other highly skilled engineers, learn and expand your skill set, forge wonderful relationships and make your mark within the diverse and inclusive Lightspeed culture, a true Canadian tech success story.

and enjoy a range of benefits that’ll keep you happy and healthy:

• Lightspeed share scheme (we are all owners).
• Mental health online platform and counseling & coaching services.
• Health and wellness benefits.
• LinkedIn Learning license (learning is always ongoing).
• Volunteer day to be able to give back to society!