Intregrations Engineer

Extraordinary opportunity. Exceptional experience.

Sometimes in life, you find yourself in the right place, at the right time, looking at an opportunity so extraordinary it cannot be ignored. At Trucordia, our company is built on wildly successful businesses in our communities across the country, and now we’ve come together to create the next great insurance brokerage. We offer an unrivaled combination of people, tools and solutions, and deliver exceptional experiences and unrivaled opportunities for our employees, clients and stakeholders.

We celebrate both individual successes and collective accomplishments, making sure the industry recognizes the remarkable company we’re building together, as well as the impact we’re having on our clients and communities. Ranked as one of the fastest-growing companies in the U.S. for three consecutive years, we have more than 5,000 team members across 200 offices across the country, who actively, genuinely care about our clients, each other and the quality of our work, and in every interaction, represent a company that people want to work for and do business with.

Trucordia Values

• We actively, genuinely CARE about our clients, each other and the quality of our work, and in every interaction, represent a company that people want to work for and do business with.
• We COLLABORATE continuously because, together, we are more powerful and make amazing things happen for our clients and company.
• We LEAD with intelligence, hunger, curiosity, energy and a future-focused attitude of “what’s next”?
• We are RESULT-ORIENTED
  , growth-focused and driven to out-perform expectations of what an insurance brokerage can achieve.
• We CELEBRATE both individual successes and collective accomplishments, making sure the industry recognizes the remarkable company we’re building together, as well as the impact we’re having on our clients and communities.

Trucordia is a rapidly growing insurance brokerage that acquires agencies nationwide and migrates their data into a centralized Agency Management System (AMS
360). We are hiring an Integration/Migration Engineer to own the technical execution of data conversions, from source system extraction through transformation, mapping, validation, and loading into AMS
360 via API and direct data operations.

This role sits within the Data and Technology team and works closely with our AMS
360 Admin team, which brings deep domain expertise. You will be the engineering counterpart to that team, responsible for building and running ETL processes that move data accurately and  immediate focus is agency migration work driven by ongoing M&A activity, with longer-term opportunities to expand into bulk data operations, CRM and marketing integrations, and other data products across the organization.

Duties and Responsibilities:

• Design and execute ETL pipelines that extract data from acquired agency source systems (AMS
  360, EPIC, TAM, Applied, Hawk Soft, and others), transform it to meet Trucordia standards, and load it into our centralized AMS
  360 instance.
• Work with Vertafore AMS
  360 API products including oData, WSAPI 3.0, and EMS to programmatically create and update customer records, policy shells, attachments, suspenses, and related data.
• Build transformation logic for carrier mapping, employee/producer mapping, cancel reason standardization, line of business alignment, and client deduplication.
• Extract, profile, and validate source system data, including database backups and exports from systems Trucordia has not previously encountered.
• Develop validation and QA processes to verify converted data meets quality requirements before, during, and after migration.
• Produce  and mapping tables that link source system records to new AMS
  360 identifiers, supporting operational traceability and data warehouse ingestion.
• Collaborate with the AMS
  360 Admin team on mapping decisions, preview validation, and issue resolution throughout each conversion project.

• 7+ years of professional experience in data engineering, ETL/ELT, or integration engineering, building pipelines that move and transform data across disparate systems.
• Strong SQL skills, including…