Summary: Join a specialized team to design, implement, and optimize data warehouse architectures and ETL/ELT processes for critical citizen security systems in Latin America. Highlights: 1. Opportunity to make a significant impact on public safety infrastructure 2. Work with cutting-edge data technologies in a challenging environment 3. Collaborate with cross-functional teams to deliver scalable BI solutions #### **This is us** At Avenga, we believe that human creativity empowers technology that matters. Operating globally, our 6000\+ specialists provide a full spectrum of services, including business and tech advisory, enterprise solutions, CX, UX and UI design, managed services, product development, and software development. #### **This is the job** We are seeking a senior **Data Analytics** based in **Mexico City** to join our team, working on citizen security systems in Latin America. This is an opportunity to make a significant impact on public safety infrastructure, working with cutting\-edge data technologies in a challenging and rewarding environment. #### **This is the team** You'll become a vital member of a specialized team dedicated to developing and maintaining critical data infrastructure for citizen security systems. Working across LATAM, you'll collaborate with cross\-functional teams to deliver robust, scalable BI solutions that support decision\-making in public safety operations. #### **This is you** **Required Skills:** * 5\-7 years of experience in Data Analytics \& Business Intelligence * Advanced **data modeling for Data Warehouses**: Dimensional modeling (Star/Snowflake schemas), Slowly Changing Dimensions (SCD), Data Vault 2\.0, and normalization techniques * Strong experience with **ETL/ELT tools**: Talend, DataStage, PowerCenter, SSIS, Pentaho or equivalent platforms, including job management, dependencies, and error handling * **Advanced SQL proficiency** (T\-SQL/PL/SQL/ANSI): Performance tuning, query optimization, partitions, indexes, statistics management, and best practices * Experience with **orchestration tools**: Apache Airflow, Control\-M, Azure Data Factory (ADF) or similar; pipeline development, scheduling, and monitoring * Hands\-on experience with **Data Warehouse platforms**: On\-premises, cloud, or big data environments such as BigQuery, Snowflake, Amazon Redshift, or Azure Synapse Analytics * **Spanish**: Advanced level (required) * **English**: Intermediate level (required) **Nice\-to\-have skills:** * Experience in public sector or security\-related projects * Knowledge of data governance and compliance frameworks * Familiarity with modern data stack tools (dbt, Fivetran, etc.) * Experience with data visualization tools (Power BI, Tableau, Looker) * Understanding of real\-time data processing and streaming architectures #### **This is your role** * Design and implement robust data warehouse architectures using dimensional modeling techniques, Data Vault 2\.0, and other industry\-standard methodologies. Ensure data models support both current requirements and future scalability. * Build, maintain, and optimize complex ETL/ELT processes using enterprise tools. Implement efficient data pipelines with proper error handling, logging, and dependency management to ensure reliable data flows. * Analyze and tune SQL queries, implement appropriate indexing strategies, manage partitions, and optimize database statistics to ensure optimal performance of data warehouse operations. * Develop and maintain automated data pipelines using orchestration tools. Implement monitoring, alerting, and recovery mechanisms to ensure high availability and reliability of data processes. * Work with modern cloud\-based data warehouse platforms to leverage scalable, cost\-effective solutions. Implement best practices for cloud data management and integration. * Work closely with data analysts, business stakeholders, and technical teams to understand requirements and deliver solutions. Maintain comprehensive documentation of data models, processes, and system architecture. * Contribute to critical citizen security systems serving communities across Latin America, ensuring data reliability, accuracy, and timely availability for public safety decision\-making. * Expected Duration: Long\-term #### **What awaits you at Avenga?** * Opportunity to work on impactful projects that contribute to public safety across LATAM * Collaborative, international work environment with talented professionals * Continuous learning and professional development opportunities * Competitive compensation and benefits package * Flexible work arrangements At Avenga, everyone matters. We provide equal opportunities in recruitment, career development, and leadership, regardless of race, ethnicity, gender identity, sexual orientation, disability, age, religion, or any other characteristic. We are committed to fostering a work environment where our diverse community of employees, candidates, and business partners actively shapes our growth. By bringing together people from different backgrounds and experiences, we build a workplace where everyone feels free to be themselves while honoring the boundaries of others.