Job Summary
The Data & Analytics function is dedicated to designing and delivering robust general data platforms that enable business solutions and high-quality analytics. The Data Analyst is responsible for interpreting and analyzing data from complex sources like ERP, HCM, and CRM to support data-driven decision making and ensure the accuracy, integrity, and usability of information within the organization’s Data Lakehouse. This hands-on role focuses on requirements translation, source-to-target mapping, dimensional modeling support, ELT/ETL validation, testing support and data quality. Working closely with Business teams, Data Architects, and Engineers, the Data Analyst transforms business processes into well-structured, secure, and reliable data models and pipelines, enabling the Data Lakehouse to serve as a trusted foundation for analytics, reporting and AI products.
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 layer separation).
- Conduct data profiling, validation, and reconciliation using Snowflake SQL.
- Work with REST API data integrations, including reading API specifications, understanding payloads, and mapping to Snowflake tables.
- Collaborate with data engineers, ETL/ELT developers, and QA to ensure accurate interpretation of the requirements.
- Support UAT and resolve data-related gaps through iterative testing and validation.
Skills and Experience
- English level B2+
- Proven experience with prog
📌 Data Analyst Associate (Bogotá)
🏢 Auxis
📍 Bogotá