Junior Data Modeler

We love technology, and we enjoy what we do. We are always looking for innovation. We have social awareness and try 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. We care about who you are in the office and as an individual. We get involved, we like to know our people, we want every Enrouter to become part of a great community of highly driven, responsible, respectful, and above all, happy people. We want you to enjoy working with us.

We are seeking a Jr. Data Modeler with strong hands-on experience in cloud data platforms to join our growing data architecture team. This role will be responsible for designing conceptual, logical, and physical data models across multiple platforms including SQL Data Warehouses, Spark, Databricks Delta Lakehouse, and other modern cloud-native environments. The ideal candidate will combine deep domain knowledge (Customer, Sales, Finance, Supplier) with technical expertise to create scalable and reusable data models that power enterprise analytics and data products.

Requirements

• Expertise in data modeling tools (ER/Studio, Erwin, IDM/ARDM models, CPG / Manufacturing/Sales/Finance/Supplier/Customer domains )
• Experience with at least one MPP database technology such as Databricks Lakehouse, Redshift, Synapse, Teradata, or Snowflake.
• Experience with version control systems like GitHub and deployment & CI tools.
• Experience of metadata management, data lineage, and data glossaries is a plus.
• Working knowledge of agile development, including DevOps and DataOps concepts.

• Working knowledge of SAP data models, particularly in the context of HANA and S/4HANA, Retails Data like IRI, Nielsen Retail.
  
  Responsibilities
  
  Design conceptual, logical, and physical data models for SQL Data Warehouse, Spark, Delta Lakehouse, and other cloud data platforms.

• Govern data modeling standards, metadata documentation, and database object creation for baseline and funded projects.
• Develop deep business domain expertise (Customer, Sales, Finance, Supplier) to drive reusable, business-aligned solutions.
• Lead design and code reviews for data models, security, and data product development.
• Work across structured, unstructured, analytical, and low-latency data (including SAP).
• Build cloud-centric, reusable data models using code-first approaches.
• Collaborate with data stewards on discovery, lineage, and stakeholder engagement.
• Support data analysis, sourcing, profiling, and transformation.
• Define Source-to-Target Mappings (STTM) for ETL/BI teams.

Benefits

• Monetary compensation
• Year-end Bonus
• IMSS, AFORE, INFONAVIT
• Major Medical Expenses Insurance
• Minor Medical Expenses Insurance
• Life Insurance
• Funeral Expenses Insurance
• Preferential rates for car insurance
• TDU Membership
• Holidays and Vacations
• Sick days
• Bereavement days
• Civil Marriage days
• Maternity & Paternity leave
• English and Spanish classes
• Performance Management Framework
• Certifications
• TALISIS Agreement: Discounts at ADVENIO, Harmon Hall, U-ERRE, UNID
• Taquitos Rewards
• Amazon Gift Card on your Birthday
• Work-from-home Bonus
• Laptop Policy
  

Equal employment

Enroute is committed to providing equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.