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
Skills Required
- Strong hands-on command of SQL, including complex data analysis, tracing, and transformation queries.
- Proficiency with SQL Server, including queries, views, stored procedures, CTEs, and window functions.
- Experience with ETL processes.
- Ability to build source-to-target data mappings and transformation logic.
- Experience with data validation and data cleansing practices.
- Cloud database experience with AWS RDS, S3, and Secrets Manager.
- Proficiency in Excel for data analysis and legacy data review.
- Experience with GitHub or version control.
- Experience with project management software such as Jira.
- Knowledge of Agile methodologies such as Kanban or Scrum.
- Ability to securely handle sensitive financial data and personally identifiable information.
- Experience using AI coding assistants such as Claude or GitHub Copilot, including prompt engineering and automated analysis.
- Prior data migration or conversion project experience.
- Experience with policy administration systems.
- Experience in the insurance or financial industry.
- Excellent communication and interpersonal skills.
- Strong problem-solving abilities and analytical thinking.
- Ability to work independently, learn through mentorship, and adapt to team processes.
- Ability to manage multiple projects while maintaining high-quality delivery.
- Strong attention to detail and focus on accurate, validated data.
What We Do
We are a group of top-notch gurus that bring together years of experience, cutting edge technology skills and cost-effective frameworks into a single place, we fuse them and deliver a sexy and perfectly fitted solution for all of our partners. We guide our clients for preparation and execution of critical projects and sourcing plans to: Minimize risks Drive Innovation Ensure the highest ROI Create value
