DATA ENGINEER - DATA CONVERSIONS JR-MID

Enroute

15h•Remote

About The Position

At Enroute, we are looking for a Data Engineer - Data Conversions to join a high-impact engineering team. As a Data Engineer on the Conversions team, this person will play a critical role in migrating insurance policy data from administration systems to a modern policy administration platform. This is an analysis-first role with a data engineering component: the primary work is to deep-dive into data, trace and reconcile information across multiple data layers (databases and files), build the mappings and transformations that move legacy data into the target format, and resolve data quality issues to deliver validated loads. Strong, hands-on command of SQL as a language is essential, and the role makes heavy, daily use of AI tooling to accelerate that work. The position offers direct mentorship from an experienced conversion manager and exposure to the full data migration lifecycle, from initial discovery through production cutover. It requires technical fluency combined with effective communication to support iterative delivery cycles, and it suits someone adaptable who is eager to learn the team's conversion methodology.

Requirements

Strong, hands-on command of SQL as a language.
Proficiency in SQL Server: queries, views, stored procedures, CTEs, window functions.
Experience with ETL (Extract, Transform, Load) processes.
Experience building source-to-target data mappings and transformation logic.
Experience with data validation and data cleansing practices.
Cloud database experience (AWS: RDS, S3, Secrets Manager).
Proficiency in Excel for data analysis and legacy data review.
Experience with GitHub / version control.
Experience with project management software (e.g., Jira).
Familiarity with Agile methodologies (e.g., Kanban, Scrum).
Experience with secure handling of sensitive financial data and personally identifiable information (PII).
Experience using AI coding assistants (Claude, GitHub Copilot, or similar) for development workflows, prompt engineering, and automated analysis.
Excellent communication and interpersonal skills.
Strong problem-solving abilities and analytical thinking.
Self-directed learner.
Coachable, adaptable, and team-first attitude.
Ability to work on multiple projects simultaneously.
Strong attention to detail.

Nice To Haves

Prior data migration / conversion project experience.
Experience with policy administration systems.
Experience in the insurance / financial industry.

Responsibilities

Deep-dive into data to analyze, trace, and reconcile information across multiple data layers (databases and files).
Build mappings and transformations to move legacy data into the target format.
Resolve data quality issues to deliver validated loads.
Write and reason through complex SQL queries to analyze, trace, and transform data.
Develop and maintain ETL processes.
Build source-to-target data mappings and transformation logic.
Perform data validation and data cleansing.
Utilize AI coding assistants for development workflows, prompt engineering, and automated analysis.
Handle sensitive financial data and personally identifiable information (PII) securely.
Work on multiple projects simultaneously while ensuring high-quality delivery.
Communicate complex technical concepts to non-technical stakeholders.
Adapt to new methodologies and learn the team's conversion process.

Benefits

Year-end Bonus
IMSS, AFORE, INFONAVIT
Major Medical Expenses Insurance
Life Insurance
Funeral Expenses Coverage
TDU Membership
MediAccess
Health Check-Up Subsidy
Preferential rates for car insurance
Vacations
Official Mexican Holidays
Life Happens Days
Bereavement Leave
Civil Marriage Leave
English Classes
Certifications
Educational Agreements (Talisis, U-ERRE, UNID, TecMilenio, Tec de Monterrey, UDEM, SPIS)
Corporate Agreements & Discounts (Sorteos Tec, Envia Flores, TopGolf)
Taquitos Rewards
Birthday Bonus
Work-from-home Bonus
Laptop Policy