Analytics Engineer
New
D
DoiTData analytics
Based remotely in Mexico or Colombia as a full-time employee or in other LATAM locations as a contractor, working hours that overlap meaningfully with US time zonesFull-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Languages
- Fluent English. Both written and spoken
- Experience
- 3–5 years in analytics engineering, data engineering, or BI engineering
- Required Skills
- PythonSQLApache AirflowCI/CDTerraformData modelingBigQuerydbt
Requirements
- Have 3–5 years of experience in analytics engineering, data engineering, or BI engineering.
- Have a track record of delivering data models that other people depend on.
- Write, read, and optimize complex analytical SQL queries; reason about grain and joins.
- Design layered data models and understand where staging, business logic, and consumption-layer logic belongs.
- Have professional experience building and maintaining dbt projects, including packages, macros, incremental strategies, snapshots, seeds, and CI/CD.
- Understand staging, intermediate, and mart patterns, deferred builds, state comparison, and slim CI.
- Use version control, code review, automated testing, and CI/CD to make changes safe to ship.
- Debug data issues to their root cause and consider freshness, volume, duplicates, and late-arriving data.
- Translate business needs into data requirements and work with non-technical stakeholders, including Finance.
- Be comfortable working across multiple repositories for transformation, infrastructure, orchestration, connectors, and cloud resources.
- Have a proven track record of using AI coding tools in a daily workflow.
- Work independently in a remote team, communicate clearly in writing, document work, and be fluent in written and spoken English.
Responsibilities
- Own routine model changes, the engineering backlog, new data source onboarding, CI/CD maintenance, and infrastructure operations.
- Build, test, and maintain data models and pipelines for dashboards, finance and investor reporting, and the AI analytics layer.
- Provision and configure BigQuery datasets, views, GCS buckets, and IAM permissions through Terraform.
- Extend RBAC, maintain data catalog metadata, and keep documentation up to date.
- Strengthen testing standards, observability, and alerting to improve platform reliability.
- Support Airflow DAG scheduling of dbt builds and troubleshoot failures in Cloud Composer.
- Build and maintain Python-based Fivetran SDK connectors, including pagination, rate limiting, error handling, and automated tests.
- Partner with BI analysts to turn ambiguous questions into well-modeled datasets and improve engineering practices through code review and shared standards.
- Use AI tooling to draft code and accelerate routine work.
View Full Description & ApplyYou'll be redirected to the employer's site
