Responsibilities
- Develop, design, tune, and maintain SSIS packages;
- Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process;
- Write scripts for automated testing of data in the target facts and dimensions;
- Capture audit information during all phases of the ETL process;
- Write and maintain documentation of the ETL processes via process flow diagrams;
- Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues;
- Collaborate with business users, support team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse;
- Maintain documentation on all SSIS packages developed and deployed;
- Assist in the development of data integration strategies for new data sources;
- Keep abreast of new features and functionality in SSIS and make recommendations on how they can be utilized to improve ETL processes;
- Provide training and support to other team members on the use of SSIS.
For more information, send an email to
Essential Skills
- Experience in developing, designing, tuning and maintaining SSIS packages;
- Experience in developing complex SQL queries for data analysis;
- Knowledge in design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process;
- Experience with Azure Data Factory (ADF) and Power BI;
- Bachelor s complete or Master’s degree in a technology/business/engineering/computer science is a must.
Languages
- Advanced English for conversation is mandatory
- Advanced Spanish for conversation is mandatory
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: Home Office, but residence in Mexico required
