Data Migration Engineer

Job Overview
Applied Systems, Inc., a worldwide leader in insurance technology, is currently searching for a Data Migration Engineer. This role will be responsible for developing and executing Applied Epic custom form conversion projects as well as executing data migration initiatives. This hybrid role demands strong technical expertise in programming and data management, attention to detail, excellent communication skills, and effective time management to handle multiple concurrent projects. As a key member of the data migration team, the candidate will perform data extractions, data merges, data mapping, migration programming and data cleanup/quality services. The role will involve interaction with various internal technical and business teams supporting migration projects, including Services, Development, Operations and Support.
What You'll Do
Technical Development & Programming:

• NET Development: Write and maintain code in VB.NET to build and enhance our custom form solutions. Ability to develop XML and JSON imports via API's and SOAP services is essential.
• SQL Development: Lead and participate in data conversion and data migration from legacy systems to target SaaS product, producing sample and final deliveries using SQL tools.
• Data Mapping: Using the existing Applied Epic data model and external system data models, effectively map 1-1, 1-many, many-1 and many-many migration scenarios.
• Data Cleanup & Quality: Perform data extractions, acquisition merges, and cleanup services to ensure customer needs are met.

Project & Time Management:

• Multitasking Across Projects: Manage several custom/Epic form conversion projects simultaneously, prioritizing tasks effectively and meeting all deadlines.
• Adaptability: Collaborate with stakeholders to ensure new systems satisfy user requirements and expectations while remaining adaptable to contingency project plans when rescheduling is required.

What You'll Need to Succeed
We're looking for someone who:

• Can work remote in the United States or Canada
• Travel is less than 10%

Your experience should include some or all the following:

• Proficiency in VB.NET programming.
• Experience with developing imports in XML and JSON format to web services including Rest API and SOAP.
• Experience with Visual Studio or other development environments. GITHUB/GITLAB is a plus.
• Intermediate knowledge in database structure and SQL skills and capabilities.
• Familiarity with ETL concepts.
• Proven ability in time management and juggling multiple projects concurrently.
• Bachelor's degree or equivalent work experience in the areas of Information Systems, Computer Science, Data Science, Software Engineering, or related disciplines. Equivalent work experience will be considered (minimum 2-year SaaS data migration / ETL experience).
  • We proudly support and encourage people with military experience, as well as military spouses, to apply.

Additionally, you may have:

• Experience with Google Cloud Platform/Storage and BigQuery.
• Experience with Jira and SharePoint.
• Bilingual language skills in French.
• The role may require occasional direct client contact to ensure that all project requirements are met, and any issues are quickly addressed.
• A proactive approach to troubleshooting and problem resolution is highly valued.

What You'll Gain
Benefits from Day One

• Health insurance plans, dental, and vision
• Wellness incentives
• 401(k) and/or RRSP retirement savings plans with employer match.

Work-Life Balance

• Competitive paid vacation time and a free day for your birthday
• Personal/sick time
• Paid holidays
• Flex Time
• Paid parental leave (U.S. candidates)
• Volunteer time off

Empowering Career Growth and Success - We invest in talent, care about our people and are empowered by the results of our work. We grow our teams from within and give our employees opportunities to advance.
What We Value
We strive for excellence at every turn to be the best at what we do. We invest in talent, care about our people and are empowered by the results of our work. We fulfil the promise of insurance - safeguarding and protecting what matters most in people's lives. And there is no more important job than that.
Our focus on the workforce, workplace and marketplace gives us a qualified individual in an environment in which they can be productive while we maintain our position in the industry. To help drive that change toward a vibrant, modern workplace, we have employee-driven networks with commonalities in ethnicity, gender, sexual orientation, and military status.
Who We Are
For more than 35 years, Applied Systems has created innovative technology for the global insurance industry. Today, we are a rapidly growing software leader that is revolutionizing the way agencies and brokerages succeed.
We are smart and curious people in a tech-first environment that champions bold and powerful thinking. We are transforming a complex industry through digitization, automation, and innovative new partnerships. Together we are driving the industry fearlessly forward.
It's an exciting time at Applied. You can do big things here, in an environment that supports creative thinking and bold ideas. Visit http://www.AppliedSystems.com for more information on how you can challenge what's possible.
EEO Statement
Applied Systems is proud to be an Equal Employment Opportunity and Affirmative Action Employer. Diversity and Inclusion is a business imperative and is a part of building our brand and reputation. At Applied, we don't discriminate, and we are committed to recruit, develop, retain, and promote regardless of race, religion, color, national origin, sexual orientation, gender identity, disability, age, veteran status, and other protected status as required by applicable law.
#LI-Remote