Analytics Engineer – Data & Analytics (Remote, Latam)

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

Description

This is a remote independent contractor opportunity working closely with our US-based team. Candidates should have strong English communication skills and availability for scheduled collaboration during US Central or Eastern Time hours.

Rankings.io helps elite law firms dominate first-page search results through SEO, paid media and data-driven insight. We're a remote-first team, and our Data & Analytics group runs the warehouse, dashboards and AI tools that client teams and leadership rely on every day.

As our Analytics Engineer, you'll turn raw data from more than a dozen sources into clean, tested models in BigQuery, the layer every dashboard, report and AI workflow is built on. Success looks like new data sources reaching reporting faster, models the team trusts without second-guessing, and dashboards that stay fast and accurate as we grow.

Our Stack: Google Cloud (GCP) — BigQuery (GoogleSQL), dbt, Python on Cloud Run, Terraform and GitHub Actions — with Looker Studio for reporting and Claude for AI-assisted work.

Responsibilities

• Data Modeling: Share ownership of our BigQuery marts with the Data & Analytics team, building and maintaining dbt models from staging through marts and reporting layers, designed for business intelligence, reporting and downstream analytics.

• New Data Sources: Turn newly onboarded sources into tested, documented marts, working from the team's field inventory, so new reporting can start sooner.

• Data Quality & Testing: Write schema and data tests and monitoring that protect accuracy and lineage. Connect disparate data sets, such as accounting, CRM and marketing data, into unified models for cross-system reporting.

• Reporting: Build clean, performant dashboards and reports in Looker Studio for client teams and internal stakeholders, including Finance.

• Performance Tuning: Troubleshoot and optimize SQL and model runtimes for speed and BigQuery cost, using partitioning, clustering and incremental models.

• AI-Ready Data: Keep models documented and reliable for the AI tools that query our warehouse, and use AI assistants to speed up SQL, testing and documentation work.

• Cross-Functional Collaboration: Partner with stakeholders and the Data & Analytics team to translate business requirements into data solutions, working through Git pull requests and code reviews.

Requirements

• 3+ years of hands-on experience in analytics engineering, data engineering or BI development.

• SQL: 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 a similar framework.

• Programming: Solid Python for data manipulation (pandas), API integrations and automation.

• Data Warehousing: Hands-on experience with a cloud data warehouse. BigQuery preferred; Snowflake, Databricks or Amazon Redshift experience is welcome.

• BI & Dashboarding: Experience building clean, performant reports in Looker Studio, Power BI or Tableau.

• Version Control: Proficient with Git, standard CI/CD workflows and code review practices.

• Communication: Clear written English for documentation, pull requests and async work with a U.S.-based team.

• Technology and Security Requirement: Contractors accessing Rankings.io systems and client data are required, under the terms of the Contractor Services Agreement, to maintain endpoint security software (Huntress) for the duration of the engagement. This does not grant Rankings.io remote access to, or control over, contractor devices.

Preferred:

• AI Tools: Hands-on use of AI assistants (such as Claude, ChatGPT or Copilot) in day-to-day data work.

• Cloud Platforms: Working knowledge of Google Cloud (Cloud Run, Cloud Scheduler), Terraform or Docker.

• Domain Data: Experience with marketing data (GA4, Search Console, Google Ads, CallRail, HubSpot) or accounting data.

• Industry: Experience at a marketing agency or with legal-industry clients.

Compensation & Work Environment

• Monthly retainer of $3,300 - 4,100 USD, invoiced by the contractor.

• Fully Remote

• Long-term engagement opportunity

Engagement Type

This opportunity is structured as an independent contractor engagement. Contractors are responsible for their own taxes, insurance, and compliance with applicable laws and regulations in their country of residence. Nothing in this posting should be interpreted as creating an employment relationship. The selected candidate will provide services to Rankings.io as an independent contractor pursuant to a written contractor agreement. Contractors must reside in an eligible country. We are unable to engage contractors located in Cuba, Iran, North Korea, Syria, Russia, Belarus, or the Crimea, Donetsk, Luhansk, Kherson, or Zaporizhzhia regions. #LI-Remote

What to Expect in the Interview Process

1. Human Resume Review: Your resume will be reviewed by our Talent Acquisition team: Real people, not AI.

2. One-Way Video Interview: Selected candidates will be sent a link to complete a one-way video interview. Please plan to record in your typical work-from-home environment, ensuring it is well-lit and free of distractions.

3. Live Zoom Interview: Candidates who move forward will meet with Talent Acquisition and the Hiring Manager for a live Zoom interview to discuss experience, role expectations, and project fit.

4. Skills Assessment: Candidates who advance will complete a practical, role-specific technical assessment designed to evaluate their SQL, data modeling, problem-solving, and analytics engineering skills. This assessment will give you an opportunity to demonstrate your technical expertise through real-world scenarios relevant to the position.

5. Final Zoom Interview: Finalists will meet with the Hiring Manager and key team members to review their skills assessment, discuss their technical approach, and explore how their experience aligns with the team's goals and expectations.