Senior Analytics Engineer, Data Architecture & Governance

Medellin, Colombia

Job Description

Senior Analytics Engineer to join our Data Team as a senior individual contributor. This role is hands‑on and highly business‑facing, focused on building the trusted data architecture, models, documentation, and business logic that enable the company to make better decisions.

This is not a people‑management role, and it is not a front‑end dashboard or visualization role. The Data Team is responsible for creating the certified data foundation that downstream teams use for reporting, analysis, and self‑service.

The role will be accountable for designing and maintaining that foundation, ensuring the data is accurate, well‑structured, clearly documented, and connected to how the business actually operates.

A critical part of this role is connecting the dots. You will work across Sales, Marketing, Finance, Revenue Operations, Product, and other business teams to understand how processes, systems, data, and KPIs fit together. You will translate that understanding into scalable data models, clear definitions, and documentation that helps the business consume data consistently and safely.

Key Responsibilities

- Build and Own Core Data Models: Design, build, and maintain scalable data models in BigQuery using dbt. Create certified datasets, tables, and views that downstream teams can use confidently for reporting, analytics, and decision‑making.
- Serve as a Senior Individual Contributor: Operate as a hands‑on technical contributor responsible for solving complex data modeling, business logic, and data architecture challenges.
- Connect the Dots Across the Business: Work across teams to understand how business processes, systems, data flows, and KPIs connect. Identify misalignments and create a clear, consistent data structure reflecting the business.
- Leverage AI Securely to Optimize and Move Faster: Use approved AI tools, automation, and modern data practices to improve productivity, accelerate documentation, surface patterns, validate logic, and reduce manual effort.
- Define and Standardize Business KPIs:



Partner with business stakeholders to define, document, and standardize key business metrics across the data layer, including SaaS and subscription metrics such as ARR, MRR, churn, net revenue retention, gross revenue retention, expansion revenue, bookings, pipeline, conversion rates, and customer lifecycle metrics.
- Model the Sales and Revenue Funnel: Build data models that support the full go‑to‑market motion, including lead generation, marketing attribution, campaign performance, opportunity progression, pipeline creation, bookings, renewals, expansion, and retention.
- Own Documentation and Data Definitions: Create and maintain high‑quality documentation for datasets, fields, transformations, business rules, metric definitions, lineage, assumptions, and known limitations.
- Translate Business Logic into Data Architecture: Take complex business requirements and translate them into clean SQL logic, scalable schemas, reusable dbt models, and clear documentation.
- Strengthen Data Governance and Quality: Support data governance by enforcing modeling standards, naming conventions, testing, validation, documentation, and certification of production‑ready datasets. Proactively identify data quality issues and partner to resolve them.
- Partner on Data Platform Best Practices: Collaborate with the Senior Data Architect and broader Data Team on architecture decisions, modeling standards, dbt best practices, platform optimization, and long‑term data strategy.

Requirements

- 5+ years of experience in analytics engineering, data analytics, data modeling, business intelligence engineering, or data architecture‑focused roles.
- Strong hands‑on experience with Google BigQuery, including query optimization, partitioning, clustering,



performance tuning, and cost management.
- Advanced SQL skills, with the ability to write clean, efficient, scalable, and well‑documented queries.
- Hands‑on experience with dbt, including data modeling, testing, documentation, lineage, and deployment practices.
- Experience working with ELT pipelines and data ingestion tools such as Fivetran.
- Experience working in a SaaS, software, subscription, or recurring revenue business model.
- Strong understanding of SaaS business metrics, including ARR, MRR, churn, retention, expansion, bookings, pipeline, and revenue growth.
- Strong understanding of the B2B sales motion, including lead‑to‑opportunity conversion, pipeline stages, opportunity management, bookings, renewals, and customer expansion.
- Ability to connect business processes, source‑system data, and reporting requirements into a coherent data model.
- Strong documentation discipline, with the ability to explain complex data structures, business rules, dependencies, and metric definitions clearly.
- AI‑first mindset with the ability to securely leverage approved AI tools and automation to improve speed, documentation quality, analytical rigor, and team productivity while maintaining strong data privacy and governance standards.
- Ability to operate independently as a senior individual contributor with strong ownership, follow‑through, and judgment.
- Comfortable working across time zones in a distributed general team environment.

Languages

- Fluent English, both written and spoken.
- Ability to lead meetings, provide professional guidance, and manage business communications in both languages.

Benefits

- Competitive salary in Colombian pesos (COP).
- Continuous training and mentoring.
- Work with a leading global company.
- Growth opportunities: Join a growing team with plenty of room for career advancement.
- Collaborative culture: Work alongside passionate professionals in an innovative environment.
- In‑office role: Excellent opportunity to collaborate with leadership in Medellín’s modern office.

#J-18808-Ljbffr

📌 Senior Analytics Engineer, Data Architecture & Governance (Medellín)
🏢 Roca Alliances
📍 Medellín