Senior DB/BI Engineer

Avenga

General Pacheco - hace 3 días

jobrapido.com
Esta oferta de trabajo no se encuentra disponible en tu país.
Descripción de la vacante
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 professional to join our team working on citizen security systems across Latin America. This is an opportunity to make a meaningful impact on public safety infrastructure while 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.

#J-18808-Ljbffr
Empleos similares
Qinshift

About Avenga 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,...

Unosquare

A leading technology consultancy in Argentina is seeking a highly motivated Senior Data Engineer to enhance business intelligence initiatives. The role involves collaborating with teams, designing modern data solutions, and supporting key projects. Ideal candidates will...

ExporTalent

A tech consulting firm in Argentina seeks a Full-Stack Developer to create end-to-end analytics solutions. This role requires deep knowledge of .NET and Power BI Embedded. You will build scalable microservices, secure embedding, and optimize dashboards for web applications....

Baufest

Una empresa de tecnología en Argentina busca un SSR Data Engineer para diseñar e implementar procesos de ingesta y modelado de datos. Se requiere al menos 3 años de experiencia en el desarrollo de soluciones de datos, con conocimientos en SQL, herramientas ETL/ELT y...

Eleks

A leading custom software development company is seeking a skilled developer to design and maintain high-performance software solutions. The role involves analyzing project requirements, improving code, collaborating with a professional team, and supporting junior...

Luxoft

Project Description The primary goal of the project is the modernization, maintenance and development of an eCommerce platform for a big US-based retail company, serving millions of omnichannel customers each week. Solutions are delivered by several Product Teams focused...

Bunker db®

En BUNKER DB buscamos un Senior Software Engineer (backend) LATAM! Sumate a una de las empresas en análisis de datos con mayor proyección y crecimiento de LATAM! Si eres un profesional proactivo, enfocado en soluciones y con ganas de aplicar nuevas tecnologías, ¡esta...

ITRex Group

Overview THE PLACE ITRex - AI pioneers who build systems that actually work in the real world, not just in demos. We're 250+ people spread across the US and Europe, creating solutions for companies like P&G and Shutterstock. We keep it simple, build it right, and focus on...

EPAM Systems

We are looking for a skilled and experienced Senior Data Quality Engineer to join our team. In this role, you will play a critical part in ensuring the accuracy, reliability, and efficiency of our data systems and processes at scale. If you are passionate about leading...

Builder.io

About the Role We are looking for a builder who speaks the language of business. We need a Senior Analytics Engineer to own the data architecture and modeling that powers our Finance, RevOps, and Executive decision‑making. In this role, you will sit at the intersection of...

Caylent

Senior Machine Learning Engineer Caylent is a cloud native services company that helps organizations bring the best out of their people and technology using Amazon Web Services (AWS). We provide a full-range of AWS services—including workload migrations, modernization,...

Sovos

Build your future with Sovos. If you're seeking a career where innovation meets impact, you've come to the right place. As a global leader, Sovos is transforming tax compliance from a business requirement to a force for growth while revolutionizing how businesses navigate...

Trafilea

Senior Analytics Engineer Trafilea is a Consumer Tech Platform for Transformative Brand Growth. We’re building the AI Growth Engine that powers the next generation of consumer brands. With over $1B+ in cumulative revenue, 12M+ customers, and 500+ talents across 19...

Galileo Financial Technologies

Senior Software Engineer Manager, Risk Engineering Operations Welcoming, collaborative and having the opportunity to make an impact - is how our employees describe working here. Galileo is a financial technology company that provides innovative and revolutionary software...

Alpaca

Who We Are: Alpaca is a US-headquartered self-clearing broker-dealer and brokerage infrastructure for stocks, ETFs, options, crypto, fixed income, 24/5 trading, and more. Our recent Series C funding round brought our total investment to over $170 million, fueling our...

HeyClue

📍LATAM - 100% Remote 🤝Contract - USD 🗣️Advanced English Skills Is Required About the Role The Senior iOS Software Engineer will design, build and optimize advanced iOS applications that support Regal Entertainment Group’s digital products and customer experiences. This...

Zencore

Overview Zencore is a fast growing company founded by former Google Cloud leaders, architects and engineers. We are looking for candidates that have significant experience with Google Cloud to join our team. Our engagements are designed to unblock, remove risk and...

Bunker db®

💻 Fullstack Developer – Bunker DB (LATAM) ¿Te gusta crear productos escalables y ver cómo tu código tiene impacto real en miles de usuarios? 🚀 En Bunker DB estamos buscando a nuestro/a próximo/a Senior Software Engineer (Fullstack) para sumarse al equipo de Technology, y...

Eleks

ELEKS Software Engineering and Development Office is looking for a Senior Data Engineer (SSIS) in Argentina. About Project Our client is a top U.S. financial services and investment firm with 120+ years of history. They help global companies unlock value, drive growth,...

Qinshift

A dynamic technology firm is seeking a Senior Business Intelligence professional in Argentina to enhance citizen security systems across Latin America. Your focus will be on developing robust data infrastructures, optimizing ETL processes, and collaborating with...

Menu