DATA ENGINEER - DATA CONVERSIONS JR-MID

Posted Yesterday
3 Locations
In-Office or Remote
Junior
Information Technology • Software • Consulting
The Role
Analyze, trace, reconcile, and migrate insurance policy data from legacy systems into a modern policy platform. Build source-to-target mappings and ETL transformations, perform data cleansing and validation, write complex SQL, use cloud databases (AWS RDS/S3), and collaborate with stakeholders using GitHub and Agile tools. Heavy daily use of AI tooling; mentorship provided throughout migration lifecycle.
Summary Generated by Built In

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 and ability to write and reason through complex queries
  • Proficiency in SQL Server: queries, views, stored procedures, CTEs, window functions
  • Experience with ETL (Extract, Transform, Load) processes
  • Building source-to-target data mappings and transformation logic
  • Data validation and data cleansing practices
  • Cloud database experience on AWS (RDS, S3, Secrets Manager)
  • Proficiency in Excel for data analysis and legacy data review
  • Experience with GitHub / version control
  • Familiarity with project management software (e.g., Jira)
  • Experience with Agile methodologies (Kanban, Scrum)
  • Secure handling of sensitive financial data and personally identifiable information (PII)
  • Experience using AI coding assistants (e.g., Claude, GitHub Copilot) for development workflows
  • Prior data migration / conversion project experience
  • Experience with policy administration systems
  • Experience in the insurance or financial industry
  • Excellent communication and interpersonal skills; ability to convey technical concepts to non-technical stakeholders
  • Strong problem-solving abilities and analytical thinking
  • Self-directed learner; coachable, adaptable, and team-first mindset
  • Ability to work on multiple projects simultaneously while ensuring high-quality delivery
  • Strong attention to detail, focused on accurate and validated data
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Houston, TX
187 Employees
Year Founded: 2005

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

Similar Jobs

TextUs Logo TextUs

Business Operations Analyst

Enterprise Web • HR Tech • Information Technology • Software
Easy Apply
Remote
USA
53 Employees
70K-85K Annually

Pfizer Logo Pfizer

Senior Director, Internal Medicine Portfolio Strategy Lead

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
In-Office or Remote
10 Locations
121990 Employees
215K-358K Annually

Pfizer Logo Pfizer

Director, Portfolio Strategy Inflammation & Immunology

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
In-Office or Remote
10 Locations
121990 Employees
177K-294K Annually

Pfizer Logo Pfizer

Cardiovascular Specialist, Health and Science Professional - Thousand Oaks, CA

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
In-Office or Remote
5 Locations
121990 Employees
76K-200K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account