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 (Canada) and 401k (US) matching program Professional development courses, $2,500 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. Please note that to maintain our SOC II compliance, we ask all candidates to complete background check and identity verification as a final step in our interview process.

#J-18808-Ljbffr