Senior DB/BI Engineer

Avenga is a global digital transformation partner with over 6,000 specialists delivering comprehensive services in consulting, enterprise solutions, UX/UI design, managed services, product development, and software development. Senior Business Intelligence Engineer – Role Overview We are looking for an experienced Senior BI professional to develop and maintain data infrastructure for citizen security systems across Latin America. This role offers the chance to drive public safety initiatives through advanced data technologies in a challenging environment. Key Responsibilities Design and implement robust data warehouse architectures using dimensional modeling, Data Vault 2.0, and industry-standard methodologies to support current and future scalability. Build, maintain, and optimize complex ETL/ELT processes with enterprise tools, incorporating error handling, logging, and dependency management for reliable data flows. Analyze and tune SQL queries, implement indexing strategies, manage partitions, and optimize database statistics to maximize performance of data warehouse operations. Develop and maintain automated data pipelines using orchestration tools, implementing monitoring, alerting, and recovery mechanisms to ensure high availability and reliability. Leverage modern cloud-based data warehouse platforms to build scalable, cost‑effective solutions and ensure best practices for cloud data management and integration. Collaborate closely with data analysts, business stakeholders, and technical teams to understand requirements and deliver solutions, documenting data models, processes, and system architecture. Support 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. Required Qualifications 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 such as Talend, DataStage, PowerCenter, SSIS, Pentaho or equivalents, including job management, dependencies, and error handling. Advanced SQL proficiency (T‑SQL/PL/SQL/ANSI) with 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. Benefits & Perks Opportunity to work on impactful public safety projects across LATAM. Collaborative, international work environment with talented professionals. Continuous learning and professional development opportunities. Competitive compensation and benefits package. Flexible work arrangements. Job Details Seniority level: Mid‑Senior level. Employment type: Full‑time. Location: Latin America (Remote/Onsite flexibility). Industry: IT services and consulting. Job function: Business Development and Sales. 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. #J-18808-Ljbffr