Senior Data Analyst - Data Lakehouse & API Mastery

Auxis; Bogotá; On-site; COP 90,000,000 - 130,000,000; Full time

Job summary

Auxis is seeking a Data Analyst to design and operate robust data platforms supporting analytics and AI products. You will interpret data from ERP, HCM, and CRM sources, translate requirements, and help build secure data models and pipelines within a modern Data Lakehouse.

You will collaborate with Data Architects, Engineers, and business teams to ensure data quality and lineage, and to enable data-driven decision making across the enterprise.

Qualifications

• BS in Computer Science or Information Systems or equivalent work experience.
• 5+ years in Data Analyst or Business Data Analyst roles in enterprise environments.
• Experience with ETL/ELT tools (Informatica, DBT).
• Experience with BI/reporting tools (Power BI, Tableau, Excel).
• Experience with data modeling methods (Dimensional modeling, Data Marts, Data Warehousing).
• Familiarity with cloud data platforms (Azure, AWS, GCP).
• Exposure to API testing tools (Postman, Swagger).
• Agile/Scrum delivery exposure.

Responsibilities

• Work with stakeholders to gather, validate, and clarify data requirements.
• Translate needs into functional and technical requirement documents.
• Create Source-to-Target Mapping documents with data logic.
• Document business rules, data definitions, and transformations.
• Perform data lineage analysis across Snowflake, APIs, and layers.
• Assist in data modeling and Medallion architecture design.
• Analyze data quality, profiling, and reconciliation in Snowflake.

Skills

SQL

Python

Snowflake

Medallion Architecture

REST APIs

ETL/ELT

Data Modeling

Data Lineage

BI Tools

English B2+

Communication

Education

BS in CS/IS

Equivalent experience

Tools

Informatica

DBT

Power BI

Tableau

Excel

Postman

Swagger

Job description

Auxis is seeking a Data Analyst to design and operate robust data platforms supporting analytics and AI products. You will interpret data from ERP, HCM, and CRM sources, translate requirements, and help build secure data models and pipelines within a modern Data Lakehouse.

You will collaborate with Data Architects, Engineers, and business teams to ensure data quality and lineage, and to enable data-driven decision making across the enterprise.