Job description
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
As a Data Conversion Engineer I at SpryPoint you will play a key role in supporting the transformation and migration of utility billing data from legacy systems into our modern utility and billing platform.
You will work in the Technical Services department alongside the rest of the Data Conversion team to extract, transform, and load (ETL) customer data, ensuring accuracy, efficiency, reliability, and quality. You will have opportunities to collaborate with pair programming, learn best practices in data migration, and contribute to process improvements.
This role is a great opportunity for someone early in their data engineering career who wants to build strong foundations in data transformation, conversion auditing, and process optimization within a collaborative and iterative environment.
Responsibilities
- Lead and manage ETL migration processes across multiple concurrent projects, ensuring robust data pipeline development and timely project delivery.
- Develop and maintain efficient extraction, transformation, and loading scripts, utilizing Python, SQL, and related data engineering tools to ensure high-quality data migrations.
- Implement feedback-driven improvements from clients and internal teams, enhancing data conversion quality, performance, and reliability.
- Actively contribute to data quality assurance processes and review datasets for accuracy, completeness, and consistency.
- Conduct in-depth analysis and profiling of diverse source database schemas (including relational and non-relational legacy systems) to accurately map and facilitate successful data extraction and migration.
- Collaborate closely with the broader Client Experience team to seamlessly integrate client data into SpryPoint products, enabling smooth and timely go-live processes.
- Work with the Data Conversion team to establish and promote best practices, create documentation, and drive continuous improvement in data migration processes, automation, and observability.
- Actively participate in daily standups and weekly review sessions, clearly communicating progress, raising blockers, and incorporating feedback to continuously improve data engineering tasks and processes.
Qualifications and Competencies
- Development experience with Python and the pandas module.
- Development experience with SQL and relational databases.
- Experience in data migration, ETL processes, process scripting, and automation.
- Understanding of system design and analysis.
- A creative approach to problem-solving and learning, and an enjoyment of solving puzzles.
Our 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-minutes 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: Assignment
You’ll have 5 days to complete the assignment, which focuses mainly on Python and Pandas. We’re not expecting perfection, what matters most is how you approach problem-solving!
👥 Stage 3: 1-hour Final Technical Interview
with Shaun Coulter, Data Conversion Manager, Noah Murphy, Data Conversion Team Lead & John Rooff, Director, Technical Services
This is a great chance to dive into your career goals, technical experience, and how we can support your growth. You’ll walk the team through your assignment, we’re just as interested in your final solution as we are in your thought process. It’s also an opportunity to showcase your skills and see if there’s a strong team fit!
🚀 Stage 4: References/Offer
We’ll check your references to confirm all the great things we’ve learned about you. 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 flexible 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 2 compliance, we ask all candidates to complete background check and identity verification as a final step in our interview process.
