Analytics Engineer

This is a fully remote position, open to applicants in Colombia.

📋 Description

• Execute the tailored data model layer in dbt across 18 data domains, collaborating closely with the Onshore Analytics Engineering Lead.

• Design and construct dbt models throughout the complete layered architecture: staging, intermediate, and mart layers.

• Establish robust dbt testing strategies, which include unique, not_null, accepted_values, relationships, and custom tests to guarantee data quality and reliability.

• Create and enhance incremental models to efficiently manage high-volume domains processing billions of events.

• Produce and maintain detailed project documentation, encompassing column descriptions and lineage graphs, to foster transparency and facilitate team collaboration.

⛳️ Requirements

• Advanced expertise in dbt, encompassing model development, testing frameworks, macros, and incremental strategies.

• Exceptional SQL skills, with a strong capacity to write efficient, maintainable queries across extensive datasets.

• Strong understanding of data modeling principles, including dimensional modeling and best practices for layered architecture.

• Practical experience with AWS data services, particularly Athena and Redshift Serverless.

• Proficient in Python for data engineering tasks and pipeline support.

• Ability to collaborate cross-functionally across various data domains and articulate technical concepts clearly to stakeholders.

• Proficiency in English: Advanced (essential for effective communication with global teams).

• Over 3 years of experience in Analytics Engineering or Data Modeling roles, with hands-on expertise in developing layered dbt pipelines and engaging with cloud-based analytical data platforms.

🏝️ Benefits

• Health and Well-being: At-home medical assistance via EMI (or similar provider) through Asobursatil, accessible for all employees from AllStar to Analyst level.

• Private healthcare plans for Lead-level roles and above.

• Celebrations and Recognitions: Christmas kit delivered to all employees. One day off for academic graduation. Family Day: one day off every semester (must be taken within the same semester).

• Financial Health and Savings (Work Together, Get Together Program): Savings incentive program via Asobursatil: Year 1: Blend contributes 50% of your monthly savings. Year 2: Blend contributes 100% of your monthly savings. Year 3+: Blend contributes 150% of your monthly savings. Savings can be withdrawn in July and December.

• Educational Loans and Subsidies: Forgivable education loans subject to committee approval and budget availability.