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.
Requirements
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.
Tech Stack
ETL
Pandas
Python
SQL
Benefits
Competitive Total Rewards
Comprehensive compensation package that grows with you
Total Wellness
Health, dental, vision, and life insurance from day one
Recharge Time
Generous PTO, Summer Friday half-days, and unlimited sick days
Future Security
RRSP (Canada) and 401k (US) matching programs
Continuous Growth
$2,500 annual development fund, tuition assistance, and Book Bounty program
Team Connection
Annual company events and team offsites that bring us together
Complete Setup
MacBook + $800 to create your ideal home workspace