Data Insights Team Lead

The Company

Simply put SpryPoint provides Smart Solutions for Smart Utilities.

Founded in 2011 SpryPoint is a leading provider of cloud-based solutions for the utility sector. Our team of experts has extensive experience serving utilities across North America and we are dedicated to helping our clients improve their operations and better serve their customers. Our solutions include advanced billing and customer relationship management tools as well as powerful analytics and data management capabilities. We are proud to have been recognized by industry experts and our clients alike for the value and innovation we bring to the market.

In February of 2023 SpryPoint received a strategic investment from Norwest a leading venture and growth equity investment firm. With this investment SpryPoint will build on its significant business momentum over the past three years expanding its team and positioning the company to continue increasing market share of its mission-critical cloud-native solutions for smart utilities.

Position Overview

SpryPoint builds fantastic web and mobile applications using cutting-edge technologies. As a Data Insights Team Lead at SpryPoint you will be leading a team of data developers responsible for designing developing and maintaining data reporting solutions leveraging tools such as Metabase. You will work closely with cross-functional teams to ensure data accuracy integrity and availability for reporting and analytics purposes. This role is pivotal in driving data-driven decision-making and optimizing our clients' operations.

You'll provide leadership technical guidance and mentorship to your team members. Your leadership will foster a culture of innovation collaboration and continuous improvement empowering your team to deliver exceptional results.

Responsibilities

• Design develop and optimize data pipelines to support reporting and analytics requirements.

• Implement and manage reporting solutions using tools like Metabase ensuring user-friendly dashboards and visualizations.

• Collaborate with business stakeholders to gather requirements define KPIs and deliver actionable insights through reports.

• Perform data cleansing transformation and aggregation to prepare datasets for reporting purposes.

• Monitor and troubleshoot data pipelines and reporting processes to ensure reliability and performance.

• Provide clear direction guidance and mentorship to a team of data developers

• Foster a collaborative and innovative environment encouraging knowledge sharing and professional growth within the team.

• Conduct regular one-on-one meetings and performance evaluations offering constructive feedback and supporting career growth.

• Work closely with team members to support data-driven decision-making initiatives.

• Stay updated with emerging technologies and best practices in data engineering reporting and analytics.

• Plan prioritize and allocate tasks to team members ensuring efficient use of resources and timely project delivery.

• Provide technical expertise and guidance to the team assisting with architecture decisions code reviews and problem-solving.

• Stay updated on industry trends emerging technologies and best practices and encourage their adoption within the team.

• Ensure the team follows coding standards best practices and quality guidelines.

• Conduct thorough code reviews to maintain high code quality identify potential issues and promote continuous improvement.

• Facilitate effective communication within the team and across other teams or departments.

• Identify skill gaps within the team and provide training guidance and opportunities for skill development.

• Promote a culture of learning and growth encouraging team members to enhance their technical and soft skills.

Qualifications and Competencies

• Bachelor's degree in Computer Science Information Technology Data Science Statistics Mathematics or a related field.

• Advanced degrees such as a Master's or PhD are advantageous but not required.

• Relevant certifications in data management database administration or data analytics are a plus.

• Hands-on experience with relational databases such as PostgreSQL including database design query optimization.

• Proficiency in writing complex SQL queries stored procedures and triggers.

• Experience with data visualization tools like Metabase Tableau or Power BI.

• Strong understanding of database design data modeling and ETL processes.

• Experience with Python programming language is preferred and some understanding of API development is considered a bonus

• Familiarity with cloud platforms (e.g. AWS Azure Google Cloud) and data warehousing solutions.

• Excellent analytical problem-solving and communication skills with a focus on scalability performance and security.

• Effective communication skills and ability to collaborate with cross-functional teams in a fast-paced Agile environment.

Our Exciting Hiring Process!

We know that looking for a new role can be both exciting and time-consuming and we truly appreciate your effort. Here’s a peek into our hiring process for this position so you know exactly what to expect:

👋 Stage 1: 30-minute Recruiter Interview

We'll dive into your professional background and experience share more about SpryPoint and the role and answer any burning questions you might have.

🧑‍💻 Stage 2: Take Home Skills Assessment

We’re flexible! You can set the deadline that works best for you to complete the take-home coding assessment. We use TestDome and the test needs to be done in one sitting. It includes live coding and multiple-choice questions focusing on SQL and Python. We’re not looking for perfection; we’re interested in how you approach problem-solving.

👥 Stage 3: 1-hour Technical Interview
with Maryam Software Engineering Manager

If the assessment goes well you'll move on to the technical interview. This is a great opportunity to show off your technical skills. We value collaboration so we'll discuss the assessment together. We’re interested not just in your final solution but also in your thought process and how you got there.

👥 Stage 4: 45-minute Final Interview with Jason Director of Software Engineering

This is your chance to discuss your career goals and learn how we can support your growth and aspirations.

📝 Stage 5: References

We'll check your references to confirm all the great things we've learned about you.

🚀 Stage 6: Offer!

If all goes well we’ll be thrilled to extend an offer and welcome you to the team!

Why SpryPoint?

🚀 Remote-first and autonomous working environment with flexible working hours

💰Competitive compensation package

💻 Macbook + $500 towards your home office setup

🏥 Health dental vision and life insurance

🏝️ Generous PTO ½ day Summer Fridays and unlimited sick days

📈 RRSP matching program

🧠 Professional development courses $2500 annual tuition assistance and a book bounty program

🧳 Annual company events (SpryPalooza!) and team offsites

SpryPoint is an equal-opportunity employer. We do not discriminate and encourage applications from everyone regardless of race religion colour national origin ancestry sex sexual orientation gender identity age physical or mental disability medical condition genetic characteristics veteran or marital status pregnancy or any other classification protected by applicable local state or federal laws.

If you need any accommodations or adjustments throughout the interview process and beyond please let us know and we will work with you to provide the necessary support and make reasonable accommodations to facilitate your participation.