Data Analytics

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
Business Intelligence professiona
l based in
Mexic
o 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
• Advanc
  ed data modeling for Data Warehou
  ses: Dimensional modeling (Star/Snowflake schemas), Slowly Changing Dimensions (SCD), Data Vault 2.0, and normalization techniques.
• Strong experience wi
  th ETL/ELT to
  ols: 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 wi
  th orchestration to
  ols: Apache Airflow, Control-M, Azure Data Factory (ADF) or similar; pipeline development, scheduling, and monitorig.
• Hands-on experience wi
  th Data Warehouse platfo
  rms: On-premises, cloud, or big data environments such as BigQuery, Snowflake, Amazon Redshift, or Azure Synapse Analytics.
• Spanish: Advanced 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