Data Analyst Associate

Auxis

Bogotá

On-site

COP 42,000,000 - 66,000,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Auxis seeks a Data Analyst to interpret data from ERP, HCM, and CRM, enabling data-driven decisions and ensuring data quality within the Data Lakehouse. You will translate requirements, map sources to targets, and support Medallion architecture across Bronze/Silver/Gold layers, collaborating with Business teams, Data Architects, and Engineers.

Strong SQL, Python, Snowflake experience, API data ingestion, and data modeling skills are required, with good English (B2+) communication and

Qualifications

  • English level B2+ or higher.
  • Experience with SQL and Python for data validation, profiling, reconciliation, and analytics.
  • Snowflake experience including writing complex SQL, JSON parsing, and schema/stage concepts.
  • Experience with API-based data ingestion (REST APIs, JSON/XML).
  • Familiarity with Medallion architecture (Bronze/Silver/Gold) and data flows across layers.
  • Ability to translate business needs into functional/technical requirements and BRDs/FRDs.

Responsibilities

  • Gather, validate, and clarify data and reporting requirements.
  • Translate business needs into functional and technical requirement documents.
  • Create Source-to-Target Mapping (STTM/STM) documents detailing data logic.
  • Document Business Rules, Data Definitions, and Transformations.
  • Analyze data lineage across Snowflake, APIs, and reporting layers.
  • Support data modeling and design in line with Medallion architecture.
  • Assist in REST API data integrations and map to Snowflake tables.
  • Collaborate with data engineers, ETL/ELT developers, and QA on requirements.
  • Support UAT and resolve data gaps through testing and validation.

Skills

SQL
Python
Snowflake
REST APIs
JSON parsing
Data lineage
Medallion architecture
BRDs/FRDs
Communication
Analytical thinking
Problem solving

Education

BS in Computer Science or Information Systems
1-3 years Data Analyst experience

Tools

Informatica
DBT
Power BI
Tableau
Excel
Postman
Swagger

Job description

The Data & Analytics function is dedicated to designing and delivering robust global 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 programming languages such as SQL and Python for data validation, profiling, reconciliation, and analytics.
  • Strong hands-on Snowflake experience is required, including:
  • Ability to construct & optimize complex SQL queries
  • Variant/JSON parsing
  • Schema and stage understanding
  • Performance analysis & troubleshooting
  • Working experience in Medallion Architecture (Bronze, Silver, Gold data layers) including mapping data flows across layers.
  • Proven experience with API-based data ingestion (REST APIs, JSON/XML).
  • Ability to interpret API documentation and create field mappings for Snowflake ingestion.
  • Experience building Source-to-Target mapping documents and transformation rules.
  • Strong understanding of data lineage, metadata traceability, and impact analysis.
  • Experience writing BRDs, FRDs, mapping documents, and business rule specifications.
  • Effective communication skills with ability to work directly with business stakeholders.
  • Excellent analytical and problem-solving skills.
Education / Professional Experience/ Qualifications
  • Bachelor of Science (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.
  • Preferred: Experience in professional services, accounting industry, or client service/consultative technology roles.
  • 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst Senior Associate
Data Analyst Senior Associate

Auxis LLC • Bogotá

On-site
COP 45,000,000 - 75,000,000
Data Analyst Senior Associate
Data Analyst Senior Associate

Auxis • Bogotá

On-site
COP 90,000,000 - 130,000,000
Data Analyst Associate
Data Analyst Associate

Auxis LLC • Bogotá

On-site
COP 42,000,000 - 70,000,000
Data Engineer Associate
Data Engineer Associate

Auxis • Bogotá

On-site
COP 60,000,000 - 90,000,000
Data Engineer Associate
Data Engineer Associate

Auxis LLC • Bogotá

On-site
COP 40,000,000 - 70,000,000
Senior Data Engineer (Snowflake) - AA
Senior Data Engineer (Snowflake) - AA

Gorilla Logic, Inc. • Colombia

Remote
COP 295,673,000 - 427,084,000
Analytics Lead Manager
Analytics Lead Manager

Auxis • Bogotá

On-site
COP 167,400,000 - 256,680,000
Senior Data Engineer (Snowflake) - AA, Remote: Colombia - Costa Rica, Fulltime
Senior Data Engineer (Snowflake) - AA, Remote: Colombia - Costa Rica, Fulltime

Gorilla Logic • Colombia

On-site
COP 295,751,000 - 394,335,000
Analytics Lead Manager
Analytics Lead Manager

Auxis LLC • Bogotá

On-site
COP 180,000,000 - 240,000,000
Data Engineer Sr- Remote Latam – ID #00199
Data Engineer Sr- Remote Latam – ID #00199

Werben HR • Bogotá

Remote
COP 100,000,000 - 120,000,000