Data Analyst II

Summary

Join Lightspeed as a Data Analyst 2 and become a key player in shaping the company's future. Collaborate with cross-functional teams to deliver data-driven solutions, lead advanced analyses, and develop data warehouse solutions using Python and SQL. Build and optimize dashboards, mentor junior analysts, and translate complex data into actionable business insights. This role requires 5+ years of experience in data analysis with Python and SQL, along with expertise in data warehousing and visualization. Lightspeed offers a flexible work culture, career growth opportunities, and a range of benefits including a share scheme, flexible working policy, health and wellness benefits, and LinkedIn Learning license.

Requirements

• 5+ years of professional experience using Python for data analysis, including advanced scripting and real-time data processing
• 5+ years of experience with SQL, with familiarity in BigQuery and Dataform as a plus
• Experience scripting and accessing data in DynamoDB
• Expertise in data extraction, processing, and advanced analyses (Pydantic, Scikit-learn, Poetry)
• Advanced skills in SQL for querying large datasets and data manipulation
• Experience with Git, including collaborating through commits, pull requests (PRs), and code reviews
• Strong knowledge of data warehouse development and testing using Python and SQL, with experience in cloud-based platforms such as BigQuery
• Experience with real-time data visualization tools like Matplotlib, Plotly, or Dash

Responsibilities

• Collaborate 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
• Perform and lead complex analyses, such as segmentation, customer health assessments, and impact measurements of development initiatives, guiding product direction and business decisions
• 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
• Script advanced interactions with DynamoDB to extract data and develop real-time visualizations that provide critical business insights
• Build, optimize, and innovate dashboards using tools like Heap and BigQuery to visualize key performance indicators (KPIs) and inform data-driven decisions
• Mentor and guide data analysts, fostering a collaborative, growth-oriented environment while exemplifying technical expertise and effective problem-solving
• Take ownership of complex data challenges, proactively supporting Product teams with data-driven insights that empower informed decision-making
• Translate complex data sets into actionable business insights, helping teams understand product performance through behavioral analysis and key metrics
• Optimize the data flow through platforms like Segment to ensure effective use of customer data in product development and customer success strategies

Preferred Qualifications

• Experience with customer data platforms like Segment and analytics tools such as Heap
• Familiarity with AWS CLI and SDKs (e.g., Boto3 for Python) to interact with AWS
• Experience working with data warehouses, particularly Dataform or similar data transformation frameworks
• 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

Benefits

• 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
• Lightspeed share scheme (we are all owners)
• Flexible working policy
• 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!