Data Analyst Associate
Posted Updated
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.
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. 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.Skills
Sign in to read and join the discussion.