Data Analyst Associate - Lakehouse & API-Driven Analytics

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

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Analyst - Data Lakehouse & API Mastery
Senior Data Analyst - Data Lakehouse & API Mastery

Auxis • Bogotá

On-site
COP 90,000,000 - 130,000,000
Senior Data Analyst: Snowflake & Data Lakehouse Specialist
Senior Data Analyst: Snowflake & Data Lakehouse Specialist

Auxis LLC • Bogotá

On-site
COP 45,000,000 - 75,000,000
Data Analyst Associate: Data Lakehouse & ETL Analytics
Data Analyst Associate: Data Lakehouse & ETL Analytics

Auxis LLC • Bogotá

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

Auxis • Bogotá

On-site
COP 42,000,000 - 66,000,000
Data Analyst Senior Associate
Data Analyst Senior Associate

Auxis LLC • Bogotá

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

Auxis LLC • Bogotá

On-site
COP 42,000,000 - 70,000,000
Data Analyst Senior Associate
Data Analyst Senior Associate

Auxis • Bogotá

On-site
COP 90,000,000 - 130,000,000
Data Engineer Associate: Pipelines & Analytics
Data Engineer Associate: Pipelines & Analytics

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
Data Engineer Associate
Data Engineer Associate

Auxis • Bogotá

On-site
COP 60,000,000 - 90,000,000