Job Summary: This role focuses on designing, optimizing, and maintaining data flows, models, and databases, ensuring data quality and availability. Key Highlights: 1. Design and optimization of scalable data flows and models. 2. SQL Server database management and query optimization. 3. Construction and maintenance of ETL processes in Azure Data Factory. **Job Description** ---------------------- Design, structure, and optimize data flows and models to support reliable and scalable analytics. Design, manage, and optimize databases in SQL Server. Build and maintain ETL processes in Azure Data Factory or equivalent tools. Optimize queries, indexes, and execution plans. Manage data storage and resources in Azure. Document data models, structures, and processes. Ensure data quality, integrity, and availability. **Candidate Requirements** -------------------------- * Degree in Systems Engineering, Data Engineering, or related fields. * SQL Server (modeling, stored procedures, functions) * Query optimization * Azure (Data Factory, Storage, Azure SQL) * ETL and pipeline orchestration **Selection Process** ------------------------ The selection process is conducted via Aira — a recruitment platform designed to enhance your application experience. To apply, you only need: 1. Apply to the job posting 2. Check your email 3. Log in to Aira and respond to the requested questions and/or tests Then, if we determine your profile matches our requirements, we will contact you by email (via Aira) to proceed to the in-person stage. **About Us** ------------------ At CALA Analytics, we drive organizational success across Latin America through the power of data. With over 30 years of experience, we are the preferred analytics partner for companies in Colombia, Mexico, and Peru, delivering advanced analytics and artificial intelligence solutions that empower strategic decision-making. **Our Benefits** ----------------------- * Wellness activities * Training and courses * Life insurance * Financial loans