Remote Analytics Engineer: Data Modeling & Dashboards

Rankings; Bogotá; Remote; COP 117,560,000 - 146,059,000; Full time

Job summary

Rankings.io is seeking an Analytics Engineer to transform data from multiple sources into clean, tested models in BigQuery. You will collaborate with a US-based team to deliver fast, reliable dashboards and AI-ready data workflows.

The role emphasizes scalable data modeling, quality tests, and cross-functional collaboration while maintaining security requirements. This is a remote independent contractor engagement with long-term potential.

Qualifications

• 3+ years of hands-on experience in analytics engineering, data engineering or BI development.
• Advanced SQL skills (CTEs, window functions, complex joins, query optimization).
• Data Modeling: experience structuring modular layers (staging marts), writing schema and data tests, and documenting models with dbt or similar.
• Programming: solid Python for data manipulation (pandas), API integrations and automation.
• Data Warehousing: hands-on cloud data warehouse experience; BigQuery preferred; Snowflake/Databricks/Redshift welcome.
• BI & Dashboarding: experience building clean, performant reports in Looker Studio, Power BI or Tableau.
• Version Control: proficient with Git, CI/CD workflows and code reviews.
• Communication: clear written English for documentation and async work with US-based team.
• Technology & Security: maintain endpoint security software (Huntress) while engagement lasts.

Responsibilities

• Data Modeling: co-own BigQuery marts and dbt models from staging to reporting layers.
• New Data Sources: onboard sources into tested marts to speed reporting.
• Data Quality & Testing: write schema/data tests and monitoring for accuracy and lineage.
• Reporting: build clean dashboards/reports in Looker Studio for client teams and Finance.
• Performance Tuning: optimize SQL/model runtimes; use partitioning, clustering, and incremental models.
• AI-Ready Data: keep models documented and AI-friendly; facilitate AI-assisted work.
• Cross-Functional Collaboration: translate business requirements into data solutions via Git PRs and reviews.

Skills

Advanced SQL

Data modeling

Python

Data warehousing

BI dashboards

Git

English communication

Tools

BigQuery

dbt

Cloud Run

Terraform

Looker Studio

GitHub Actions

Job description

Rankings.io is seeking an Analytics Engineer to transform data from multiple sources into clean, tested models in BigQuery. You will collaborate with a US-based team to deliver fast, reliable dashboards and AI-ready data workflows.

The role emphasizes scalable data modeling, quality tests, and cross-functional collaboration while maintaining security requirements. This is a remote independent contractor engagement with long-term potential.