Auxis

Back-office optimization consulting and outsourcing

Data Integration Engineer

Data EngineeringPosted on Nov 5

Full-timeBogotá, Bogota, ColombiaNo salary listedIn-person

About the Job

Requirements

English proficiency at B2 level or higher is required.
At least 5 years of relevant data integration and platform engineering experience is required.
Hands-on experience administering the Informatica platform, including Informatica IDMC and CIH, is required.
Hands-on Snowflake experience focused on ELT and ETL development and maintenance is required.
Strong hands-on experience with dbt for building and maintaining data transformation models is required.
Proficiency in SQL and Python for data processing and automation is required.
Experience with API-based data ingestion using REST APIs and JSON/XML, and integrating diverse source systems, is required.
Understanding of ETL/ELT patterns, data modeling, and the end-to-end data lifecycle is required.
Experience implementing and maintaining CI/CD and environment management for data integration solutions is required.
Operational discipline in incident management, problem management, and release/change practices is required; familiarity with Azure or AWS cloud data platforms is expected.
Exposure to Agile/Scrum delivery is required.
A bachelor's degree in Information Technology, Computer Science, Engineering, or a related discipline is required.
Experience with enterprise authentication and authorization patterns, role-based access control (RBAC), and secrets management is required; exposure to FinOps practices for platform consumption is also required.

Responsibilities

Administer, configure, and maintain the Informatica IDMC platform, including environment setup, upgrades, patching, connectivity, monitoring, and platform health.
Design, develop, and maintain ELT and ETL data integration workflows using Informatica, dbt, and Snowflake, with efficient, reusable, and documented transformation logic.
Build and maintain scalable ingestion, orchestration, and transformation patterns to integrate data from diverse sources into the enterprise data platform, and develop reusable templates and modules to accelerate onboarding and delivery.
Build and maintain CI/CD for data integration assets and pipeline deployments to promote consistent, automated, and reliable releases.
Partner with security and governance stakeholders to administer platform access, including RBAC, user onboarding, connection management, and remediation of Informatica platform security incidents.
Optimize Informatica cost and performance through proactive resource and IPU monitoring and mapping, transformation, and task optimization.
Optimize cost and performance across Snowflake warehouses, queries, and data loads; recommend and deploy schema changes, including tables, views, and materialized views; and tune and optimize queries for ELT and ETL workloads.
Implement data quality and observability checks within integration pipelines and integrate them with enterprise monitoring and alerting.
Manage service requests, change requests, and incidents, including Major Incident Management (MIM), root cause analysis (RCA), and remediation; create and maintain documentation for Informatica configurations, dbt models, integration workflows, and operational runbooks.
Provide weekly operational reporting on service request status, incident management, RCA tickets, platform improvements, and platform consumption monitoring (FinOps).
Mentor associate engineers and contribute to data integration standards, best practices, and documentation.

Job Summary

Data & Analytics function is dedicated to designing and delivering robust global data platforms that enable business solutions and high-quality analytics. The Data Integration Engineer - Senior Associate is responsible for the administration of the Informatica platform and for the development and maintenance of ELT and ETL data integration solutions built on Informatica, dbt and Snowflake. This role focuses on integration pipeline delivery, platform administration, reliability, and standardization, enabling scalable delivery and maintenance of trusted data products aligned to the Data & Analytics strategy.

Responsibilities

Administer, configure, and maintain the Informatica platform (Informatica IDMC), including environment setup, upgrades, patching, connectivity, monitoring, and overall platform health.
Design, develop, and maintain ELT and ETL data integration workflows using Informatica, dbt and Snowflake, ensuring efficient, reusable, and well-documented transformation logic.
Build and maintain scalable ingestion, orchestration, and transformation patterns to integrate data from diverse sources into the enterprise data platform and develop reusable templates/modules to accelerate onboarding and delivery.
Build and maintain CI/CD for data integration assets and pipeline deployments, promoting consistent, automated, and reliable releases.
· Partner with security and governance stakeholders to administer platform access, icluding role-based access control (RBAC), user onboarding, connection management, and remediation of security incidents on the Informatica platform.
Optimize cost and performance in Informatica through proactive resource and IPU monitoring and mapping, transformation and task optimization.
Optimize cost and performance across Snowflake warehouses, queries, and data loads; recommend and deploy schema changes (tables, views, materialized views, etc.); and perform query tuning and optimization for ELT and ETL workloads.
Implement data quality and data observability checks within integration pipelines and integrate with enterprise monitoring and alerting.
Manage service requests, change requests, and incident management, including Major Incident Management (MIM) with Root Cause Analysis (RCA) and remediation; create and maintain documentation for Informatica configurations, dbt models, integration workflows, and operational runbooks.
Weekly operational reporting on service request status, incident management, RCA tickets, platform improvements, and platform consumption (FinOps) monitoring.
Mentor associate engineers; contribute to data integration standards, best practices, and documentation.

Skills and Experience

Skills

English level B2+
Strong data integration and platform engineering background with 5+ years of relevant experience.
Hands-on experience administering the Informatica platform (Informatica IDMC, CIH) is required.
Hands-on Snowflake experience is required, with a focus on ELT and ETL development and maintenance.
· Strong hands-on experience with dbt for building and maintaining data transformation models.
Proficiency in SQL and Python for data processing and automation.
Proven experience with API-based data ingestion (REST APIs, JSON/XML) and integrating diverse source systems.
Strong understanding of ETL/ELT patterns, data modeling, and the end-to-end data lifecycle.
Experience implementing and maintaining CI/CD and environment management for data integration solutions.
Strong operational discipline: incident management, problem management, and release/change practices; familiarity with cloud data platforms (Azure, AWS).
Agile/Scrum delivery exposure.

Education / Professional Experience/ Qualifications

Bachelor’s degree in Information Technology, Computer Science, Engineering, or related discipline.
Hands-on experience administering and supporting the Informatica platform (Informatica IDMC) in enterprise environments.
Hands-on experience with Snowflake and dbt for ELT and ETL development and maintenance.
Experience with enterprise authentication/authorization patterns, RBAC, and secrets management; exposure to FinOps practices for platform consumption.

#LI-FV1

About the Company

Auxis

Back-office optimization consulting and outsourcing

Auxis provides management consulting and outsourcing services to optimize back-office functions for senior executives. It helps clients become more scalable, cost-effective, and innovative by offering customized solutions such as nearshore outsourcing from Latin America (finance & accounting, customer service, IT), shared services, robotics process automation (RPA), and business intelligence (BI). Its approach combines advisory insights with hands-on outsourcing work, enabling rapid paybacks, 30%+ cost savings, improved controls, better operational visibility, and a stronger focus on value-creating activities. With over 22 years in the field, Auxis differentiates itself by its dual role as advisor and operator and by delivering real-world ROI, backed by recognition as a Top 100 Global Outsourcing Provider for multiple years. The company’s goal is to help senior leaders achieve Peak Performance in their back office.

Company size: 1,001-5,000
Company stage: Not listed
Total funding: Not listed
Headquarters: Fort Lauderdale, FL
Founded: 1997

Recently Posted Jobs

Explore more opportunities at Auxis

See more jobs