Data Integration Lead (SSIS)

Fixed contract directly with the company (México), Monterrey OU Saltillo OU Guadalajara OU Cidade do México Hybrid

📌 For more information, send an email to talent@mollicait.com

Requirements

Essential skills:

  • Experience in Datawarehousing technologies and in Data Engineering;
  • Experience building Data Warehouses;
  • Experience managing and developing in SQL Analysis Services;
  • Team lead experience in Data Warehouse/BI data environment including project management, resource assignment, architectural design;
  • Experience creating data models and translating into a DW design and Analysis Services model to support analytical requirements;
  • Experience managing all technical aspects of a production DW;
  • Extensive experience with SQL Databases: Stored Procedures, Views and T-SQL;
  • Experience using the Microsoft Data integration tools including SSIS/IR, ADF and ADO;
  • Experience with Azure DevOps, ADF (Running SSIS from ADF and native ADF pipelines);
  • Proven experience with data warehousing and data modeling;
  • Proven ability to build out, enhance, and maintain data environment, including modifications and maintenance of various ETLs, transactional data sets, and company data assets;
  • Bachelor's complete or Master’s degree in Computer Science, or a related discipline is a must.

 ðŸŒŽ Languages:

  • Advanced English for conversation is mandatory
  • Advanced Spanish for conversation is mandatory
Benefits

Benefits:

✔️One hundred percent nominal salary (bi-weekly pay)

✔️Major Medical Insurance for you with coverage abroad and your family (spouse and children under 25) with National coverage and Ground Ambulance

✔️Children under 25 years of age) with National coverage and Ground Ambulance

✔️Life Insurance of 24 months of salary in case of natural death and 48 months in case of accidental death

✔️Funeral Insurance for employees or direct family members (registered beneficiaries)

✔️Integral Health Plan

✔️3 weeks of vacation per year (15 working days)

✔️Vacation bonus 25% of 15 days

✔️Holidays in addition to the LFT

✔️1 week of paid sick leave per year (5 days)

✔️Christmas bonus (15 days of salary)

✔️Referral bonus (in accordance with current internal policy)

✔️Gym bonus

✔️Pantry bonus

✔️Salary advancement (conditions apply)

✔️Training to reinforce English (virtual classes)

✔️Relocation bonus ($1500 USD) (if required only applies to relocate to Saltillo or Monterrey)

✔️TN Visa sponsored by the company (applies for relocation to US) in specific projects

✔️Legal benefits such as: IMSS, AFORE and Infonavit

✔️More than 30 online certifications with curricular value

 

Additional Information:

Contract: Fixed contract directly with the company

Contract Term: Indeterminate

Work Location: Hibrid (2x/week in-office, 3 remote days), where you can choose the following locations:

  • México - Monterrey
  • México - Saltillo
  • México - Guadalajara
  • México - Cidade do México 
About the company
A International Talent Resources Inc. (ITR) conquistou uma reputação invejável pela alta qualidade de serviço e dedicação à satisfação dos clientes. A ITR possui uma base de conhecimento de mais de trinta e cinco anos em Serviços de TI, Construção, Petróleo e Gás e Telecom. Os principais mercados da ITR estão nos setores local, regional e internacional. Sua sede está localizada em Toronto, Ontário (Canadá), enquanto outras filiais estão localizadas em Fort McMurray (Alberta), Sheridan (Wyoming) EUA, Hamilton (Bermudas), Cidade do México (México) e San Jose (Costa Rica).