Data Engineer - Data Conversions Jr-Mid

Enroute

2d•Remote

About The Position

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 (able to independently write and reason through complex queries to analyze, trace, and transform data).
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 using AI coding assistants (Claude, GitHub Copilot, or similar) for development workflows, prompt engineering, and automated analysis.
Excellent communication and interpersonal skills; able to convey complex technical concepts to non-technical stakeholders.
Strong problem-solving abilities and analytical thinking.
Self-directed learner who thrives with mentorship.
Coachable, adaptable, and team-first; values flexibility and willingness to learn over tenure.
Strong attention to detail, focused on accurate and validated data.

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.
Utilize AI tooling to accelerate data analysis and transformation work.
Communicate complex technical concepts to non-technical stakeholders.
Work on multiple projects simultaneously while ensuring high-quality delivery.
Ensure secure handling of sensitive financial data and personally identifiable information (PII).

Benefits

Monetary compensation
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