We are seeking a dynamic and self-motivated Database Specialist to join our Knowledge Management and Information Technology Department. This role will design, implement, and manage advanced database systems to ensure scalable, efficient, and secure solutions for CIMMYT’s data needs.

This position is based at CIMMYT’s headquarters in Texcoco, near Mexico City.

Responsibilities:

• Manage and optimize SQL Server databases, implementing indexing, performance tuning, and monitoring for availability and efficiency.
• Enhance database infrastructure by recommending and applying best practices, tools, and technologies for scalability and reliability.
• Oversee the complete Data Warehouse (DWH) lifecycle, including ETL processes, and automate workflows using tools like SSIS.
• Design and maintain ETL processes, ensuring high-quality data integration and consistency from various sources.
• Integrate and optimize systems using SQL Server, cloud platforms, and analytics tools, creating data pipelines for smooth data processing and transformation.
• Establish and enforce data security policies, including governance measures, quality assurance, and accessibility compliance.
• Serve as an internal consultant, offering technical solutions for data access and usability across departments.
• Provide training and guidance on data governance and best practices to enhance team efficiency.
• Maintain documentation for data models, ETL pipelines, and other processes, while generating performance and compliance reports.
• Support troubleshooting, performance tuning, and additional tasks as assigned by the supervisor.

Requirements:

• Bachelor’s degree in Information Technology, Computer Science, Software Engineering, Data Engineering, or related field.
• At least 5 years of experience in database management with a proactive, results-driven attitude.
• Proven ability to collaborate with business intelligence and IT teams to support data integration and analytics projects.
• Advanced expertise in SQL Server and T-SQL, including optimization of stored procedures, views, and queries.
• Strong understanding of data warehousing concepts, data modeling, and schema design, with hands-on experience in robust data architectures.
• Skilled in ETL processes and data integration, particularly with tools like SSIS or equivalent platforms.
• Solid knowledge of data governance, security protocols, and compliance standards, including data protection and encryption.
• Experience with data analytics and visualization tools such as Power BI, Azure Machine Learning, R, or Python.
• Familiarity with cloud platforms like Azure or AWS for data management and integration.
• Strong problem-solving and analytical skills for database and pipeline challenges.
• Preferred certifications: Microsoft Certified: Azure Database Administrator or equivalent.
• Upper-intermediate proficiency in English (minimum CEFR level B2).
• Competencies: Organization, Critical Thinking, Teamwork, Problem-solving, Client Orientation, and Communication.

Benefits:

CIMMYT offers a competitive remuneration package and opportunities for professional growth. Benefits include:

• Year-end bonus (40 days).
• Vacation premium (56%).
• Life and medical insurance.
• Supermarket vouchers.
• Savings fund.
• Social security benefits (IMSS, SAR/Infonavit).