Data Analyst

PayJoy, Inc; Bogotá; On-site; COP 90,000,000 - 130,000,000; Full time

Benefits offered by this job

Health insurance

Life Insurance

Indefinite-term contract

20 days vacations

Unlimited sick leave

Co-working Travel perk

Professional Development perk

Phone finance

Headphone benefit

Home office equipment allowance

Wellness perks

Catered lunches

Job summary

PayJoy, Inc is seeking a Data Analyst to design and maintain data infrastructure, pipelines, and models that deliver clean, reliable data across the organization. You will transform raw data into structured datasets in the warehouse/lake, enabling analytics, reporting, and data-driven products.

The role focuses on accuracy, timeliness, scalability, and governance to support analysts, data scientists, and business teams making informed decisions.

Qualifications

• Proficient in SQL and Python for data engineering tasks.
• Experience with ETL/ELT and orchestration tools (Airflow, dbt).
• Knowledge of cloud data warehouses (BigQuery, Snowflake, Redshift).
• Version control experience (Git) and data modeling fundamentals.

Responsibilities

• Design, build, and maintain scalable data pipelines (ETL/ELT) into data warehouses/lakes.
• Develop data models, schemas, and transformations for analytics-ready datasets.
• Ensure data quality, governance, validation, monitoring, and documentation.

Skills

SQL

Python

ETL/ELT

Airflow

dbt

BigQuery

Snowflake

Redshift

Git

Tools

Airflow

dbt

BigQuery

Snowflake

Redshift

Git

Job description

About PayJoy

PayJoy, a Public Benefit Corporation, is a mission-first credit provider dedicated to helping under-served customers in emerging markets to achieve financial stability and success. Our patented technology for secured credit provides an on-ramp for new customers to enter the credit system. Through PayJoy’s point-of-sale financing and card offerings, customers gain access to a modern quality of life. PayJoy’s credit also allows our customers to seize opportunities as micro-entrepreneurs, and acts as insurance for tough times. Through our cutting-edge machine learning, data science, and anti-fraud AI, we have served over 18 million customers as of 2025 while achieving solid profitability for sustainable growth.

This role

The Data Analyst is responsible for designing, building, and maintaining the data infrastructure, pipelines, and models that make clean, reliable data available across PayJoy. This role transforms raw data from multiple sources into well-structured, trustworthy datasets in the data warehouse/lake, enabling analytics, reporting, and data-driven products. As the foundation of the data stack, the Data Engineer ensures data is accurate, timely, scalable, and well-governed so analysts, data scientists, and business teams can rely on it to make informed decisions.

Responsibilities

• Design, build, and maintain scalable data pipelines (ETL/ELT) that ingest, clean, transform, and load data from multiple sources into the data warehouse/lake.
• Develop and maintain data models, schemas, and transformations (e.g., with dbt) that produce reliable, well-documented, analytics-ready datasets.
• Ensure data quality, integrity, and governance: implement validation, testing, monitoring, alerting, and documentation across the data platform.
• Optimize storage, query performance, and pipeline cost/efficiency, and troubleshoot failures with robust error handling and retries.
• Partner with data analysts, data scientists, and business stakeholders to understand their needs and deliver the datasets and infrastructure they require.
• Apply security and compliance best practices to data handling (access controls, encryption, PII protection), coordinating with Security/IT as needed.

Requeriments

• Software / tools: Strong SQL and proficiency in Python for data engineering; hands-on experience with ETL/ELT and orchestration tools (e.g., Airflow, dbt), cloud data warehouses (BigQuery, Snowflake, or Redshift), and a major cloud (GCP/AWS/Azure). Version control (Git).
• Specific knowledge: Data modeling and warehousing (dimensional modeling, star schemas), batch and streaming patterns, data quality and governance, and performance optimization. Experience in fintech or high-volume transactional environments is valued.
• Expected results: Reliable, well-documented, high-quality data pipelines and datasets with strong uptime; timely, accurate data available to downstream teams; and efficient, cost-effective data infrastructure.
• Skills: Strong analytical and problem-solving skills, attention to detail, ownership and reliability, clear communication, and collaboration across technical and business teams.
• Desirable (not essential): Experience with streaming (Kafka / Pub/Sub), infrastructure-as-code, data catalog/observability tools, and system integrations; intermediate/advanced English (Portuguese a plus); and prior experience in a similar Data Engineer role.

Benefits

• 100% Company-funded Health for employees and immediate family members
  
• Life Insurance
  
• Indefinite-term contract
  
• 20 days of vacations, unlimited sick leave
  
• $2,000 USD annual Co-working Travel perk
  
• $2,000 USD annual Professional Development perk
  
• Phone finance, headphone benefit, home office equipment allowance and wellness perks
  
• Catered lunches

PayJoy is proud to be an Equal Employment Opportunity employer and we welcome and encourage people of all backgrounds. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

PayJoy Principles

Finance for the next billion * Ownership * Break Through Walls * Live Communication * Transparency & Directness * Focus on Scale * Work-Life Balance * Embrace Diversity * Speed * Active Listening