Data Engineer Data Conversions

Enroute; Mexico; On-site; PHP 2,213,000 - 3,320,000; Full time

Benefits offered by this job

Year-end Bonus

Health Insurance

Work-from-home Bonus

Laptop Policy

English Classes

Certifications

Educational Agreements

Job summary

Enroute invites a Data Engineer - Data Conversions to join our high-impact engineering team in Mexico. You will migrate insurance policy data from legacy administration systems to a modern policy platform, performing deep data analysis, tracing, and building source-to-target mappings and transformations.

The role blends data engineering with analysis, relies on SQL mastery, daily use of AI coding assistants, and collaboration with a conversion manager through the full data migration lifecycle,

Qualifications

• Strong SQL writing and data transformation skills.
• Experience with SQL Server including views and procedures.
• ETL processes and source-to-target data mappings.
• Data validation, cleansing, and safeguarding PII data.

Responsibilities

• Migrate policy data from legacy systems to a modern platform.
• Build mappings and transformations to ensure validated loads.
• Collaborate with the conversion manager through the data lifecycle.

Skills

SQL

SQL Server

ETL

Data Mapping

Data Validation

Cloud AWS

Excel

GitHub

Jira

Agile

PII Security

AI Coding Assistants

Tools

GitHub

Jira

AWS RDS / S3

Job description

We love technology, and we enjoy what we do. We are always looking for innovation. We have social awareness and strive to improve it daily. We make things happen. You can trust us. Our Enrouters are always up for a challenge. We ask questions, and we love to learn. We pride ourselves on having great benefits and compensations, a fantastic work environment, flexible schedules, and policies that positively impact the balance of work and life outside of it.

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

Technical

• Strong, hands-on command of SQL as a language (the core skill for this role) - 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
• ETL (Extract, Transform, Load) processes
• Building source-to-target data mappings and transformation logic
• Data validation and data cleansing practices
• Cloud database experience - AWS: RDS, S3, Secrets Manager
• Proficiency in Excel for data analysis and legacy data review
• GitHub / version control
• Project management software (e.g., Jira)
• Agile methodologies (e.g., Kanban, Scrum)
• 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

Highly Preferred (domain)

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

Soft Skills / Competencies

• 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
• Ability to work on multiple projects simultaneously while ensuring high-quality delivery
• Strong attention to detail, focused on accurate and validated data

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