Data Conversion Engineer

Accountabilities: Lead and coordinate ETL data migration activities across multiple projects, ensuring efficient workflows, high-quality results, and timely delivery. Develop, maintain, and optimize data extraction, transformation, and loading scripts using Python, SQL, pandas, and other relevant engineering tools. Analyze and profile source database structures, including relational and non-relational legacy systems, to identify data relationships and establish accurate migration mappings. Perform data validation, quality assurance, and conversion audits to ensure migrated information is accurate, complete, consistent, and reliable. Identify opportunities to improve migration processes by incorporating feedback from clients and internal stakeholders, enhancing performance, automation, and overall data quality. Collaborate with technical and client experience teams to integrate customer data into modern utility software platforms and support successful implementation and go-live activities. Contribute to the development of data migration standards, technical documentation, reusable scripts, and best practices. Improve process automation and observability to increase the reliability, efficiency, and scalability of data conversion workflows. Participate in daily stand-ups, weekly reviews, and collaborative technical discussions, communicating progress, identifying blockers, and sharing recommendations. Work alongside other engineers through knowledge sharing, pair programming, and continuous improvement initiatives. Requirements Experience developing with Python, particularly using the pandas library for data manipulation, transformation, and analysis. Practical experience with SQL and relational databases, including querying, analyzing, and validating structured datasets. Understanding of ETL methodologies, data migration processes, scripting, and workflow automation. Knowledge of system design, database structures, and technical analysis, with the ability to understand complex legacy environments. Strong analytical and problem-solving abilities, with a creative and methodical approach to investigating data inconsistencies and technical challenges. Attention to detail and a commitment to delivering accurate, reliable, and high-quality data solutions. Ability to collaborate effectively with technical and non-technical stakeholders, communicate progress clearly, and incorporate constructive feedback. Strong organizational skills and the ability to manage multiple tasks and project priorities in an iterative environment. Curiosity, adaptability, and enthusiasm for learning new technologies, developing engineering practices, and contributing to team success. Benefits Remote-first flexibility: Work remotely with flexible working hours across North America. Competitive compensation: Comprehensive total rewards package designed to grow with your experience and contributions. Home office equipment: Company-provided MacBook and an $800 allowance to create your ideal home workspace. Health and wellness: Comprehensive health, dental, vision, and life insurance coverage from day one. Paid time off: Generous paid vacation and unlimited sick days. Retirement savings: RRSP matching program for Canadian employees. Professional development: Annual $2,500 learning and development budget, tuition assistance, and access to a book reimbursement program. Team connection: Annual company-wide events and team offsites to encourage collaboration and strengthen relationships. Flexible work environment: Access to hub offices in Charlottetown and Atlanta, alongside a distributed North American team. Career growth: Opportunities to develop technical expertise, work on complex data migration projects, and learn from experienced engineering professionals.