Data Analyst Associate: Data Lakehouse & ETL Analytics

Auxis LLC; Bogotá; On-site; COP 42,000,000 - 70,000,000; Full time

Job summary

Auxis LLC in Bogotá seeks a Data Analyst to interpret data from ERP, HCM, and CRM, supporting data-driven decisions and ensuring quality within the Data Lakehouse. The role emphasizes requirements translation, source-to-target mapping, and ELT/ETL validation to deliver reliable data pipelines.

Collaborate with data engineers and business teams to build secure data models and robust data lineage across Snowflake, REST APIs, and BI/reporting layers.

Qualifications

• BS in computer science or information systems (or equivalent work experience).
• 1-3 years of Data Analyst or Business Data Analyst experience in enterprise data environments.
• Experience with ETL/ELT tools (Informatica, DBT).
• Experience with BI/reporting tools (Power BI, Tableau, Excel).
• Experience with data modeling methodologies (Dimensional modeling, Data Marts, Data Warehousing, Star/Snowflake schema).
• Familiarity with cloud data platforms (Azure, AWS, GCP).
• Exposure to API testing tools (Postman, Swagger).
• Agile/Scrum delivery exposure.

Responsibilities

• Work closely with business stakeholders to gather, validate, and clarify data and reporting requirements.
• Translate business needs into detailed functional and technical requirement documents.
• Develop comprehensive Source-to-Target Mapping (STTM/STM) documents capturing field-level data logic.
• Create detailed Business Rules, Data Definitions, and Data Transformation documentation.
• Perform complete data lineage analysis across Snowflake, APIs, upstream sources, and reporting layers.
• Assist in data modeling and design aligned with Medallion architecture (Bronze/Silver/Gold).
• Conduct data profiling, validation, and reconciliation using Snowflake SQL.
• Work with REST API data integrations, including reading API specs and mapping to Snowflake tables.
• Collaborate with data engineers, ETL/ELT developers, and QA to ensure accurate interpretation.
• Support UAT and resolve data-related gaps through iterative testing and validation.

Skills

SQL

Python

Data profiling

Data validation

Data reconciliation

Analytical thinking

Communication

English B2+

Education

BS in CS or IS

Tools

Snowflake

Informatica

DBT

Power BI

Tableau

Excel

Postman

Swagger

Azure

AWS

GCP

Job description

Auxis LLC in Bogotá seeks a Data Analyst to interpret data from ERP, HCM, and CRM, supporting data-driven decisions and ensuring quality within the Data Lakehouse. The role emphasizes requirements translation, source-to-target mapping, and ELT/ETL validation to deliver reliable data pipelines.

Collaborate with data engineers and business teams to build secure data models and robust data lineage across Snowflake, REST APIs, and BI/reporting layers.