Analytics Engineer

This is a fully remote position, open to applicants in Colombia, +1 more country.

📋 Description

• Share accountability for the engineering of the data platform, which includes model modifications, managing the engineering backlog, onboarding data sources, maintaining CI/CD, and overseeing infrastructure operations.

• Construct, test, and uphold data models and pipelines that drive dashboards, finance and investor reporting, as well as the AI analytics layer across more than 15 business domains.

• Provision and set up BigQuery datasets, views, GCS buckets, and IAM permissions using Terraform.

• Onboard data ingestion destinations, manage access controls, and address schema drift on source tables.

• Own and enhance RBAC implementation, while maintaining data catalog metadata and documentation.

• Enhance platform reliability through improved testing standards, observability, and alerting mechanisms.

• Support Airflow orchestration and scheduling, including resolving Cloud Composer build failures.

• Develop and maintain Python-based Fivetran SDK connectors that incorporate pagination, rate limiting, error handling, and automated testing.

• Collaborate with BI analysts to transform ambiguous inquiries into well-structured, reliable datasets.

• Elevate engineering practices through code reviews and adherence to shared standards.

• Utilize modern AI tools to draft code and expedite routine tasks.

• Report to the Head of Business Intelligence and work alongside BI analysts, engineers, and business partners.

⛳️ Requirements

• 3–5 years of experience in analytics engineering, data engineering, or BI engineering.

• Strong skills in SQL and data modeling, including the ability to handle complex analytical queries, grain, joins, and layered models.

• Professional experience with dbt, encompassing packages, macros, incremental strategies, snapshots, seeds, CI/CD, and staging → intermediate → mart patterns, deferred builds, state comparison, and slim CI.

• Software engineering expertise, including version control, code review, automated testing, and CI/CD.

• Ability to troubleshoot data issues to their root cause while considering freshness, volume, duplicates, and late-arriving data.

• Capability to translate business requirements into data specifications and engage with non-technical stakeholders, including those in Finance.

• Comfortable navigating various repositories across transformation, data infrastructure, orchestration, custom connectors, and foundational cloud resources.

• Demonstrated success in integrating AI coding tools into daily workflows.

• Ability to work independently within a remote, global team, maintaining clear written communication and documentation practices.

• Proficiency in written and spoken English.

• Knowledge of additional languages is a bonus.

• Bonus: Hands-on experience with BigQuery, Fivetran, Apache Airflow/Cloud Composer, or equivalent AWS/Azure services.

• Bonus: Familiarity with data catalog or data observability tools.

• Bonus: Experience with Git-based CI/CD workflows for data projects.

• Bonus: Proficiency in Terraform for data infrastructure.

• Bonus: Experience with Python REST API integrations.

• Bonus: Understanding of the dbt build lifecycle, BigQuery performance tuning, Docker, Kubernetes, SQLFluff/pre-commit, and experience with SaaS source systems.

🏝️ Benefits

• Unlimited Vacation

• Flexible Working Options

• Health Insurance

• Parental Leave

• Employee Stock Option Plan

• Home Office Allowance

• Professional Development Stipend

• Peer Recognition Program