Analytics Engineer

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

📋 Description

• Execute the curated 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 thorough dbt testing methodologies, including unique, not_null, accepted_values, relationships, and custom tests to guarantee data quality and reliability.

• Create and enhance incremental models to efficiently process high-volume domains that handle billions of events.

• Produce and sustain comprehensive project documentation, such as column descriptions and lineage graphs, to foster transparency and team collaboration.

⛳️ Requirements

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

• Proficient SQL skills, with a robust ability to craft performant, 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, especially Athena and Redshift Serverless.

• Familiarity with Python for data engineering tasks and pipeline support.

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

• Proficient in English (required for effective communication with global teams).

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

🏝️ Benefits

• Learning Opportunities: Certifications in AWS (we are AWS Partners), Databricks, and Snowflake.

• Access to AI learning paths to keep current with the latest technologies.

• Customized study plans, courses, and additional certifications designed to enhance your role.

• Access to Udemy Business, offering thousands of courses to elevate your technical and soft skills.

• English lessons to enhance your professional communication.

• Travel opportunities to attend industry conferences and connect with clients.

• Mentoring and Development: Career development plans and mentorship programs to assist in shaping your career path.

• Celebrations & Support: Special rewards to celebrate birthdays, work anniversaries, and other personal milestones.

• Company-provided equipment.

• Flexible working options to achieve the right balance.

• Statutory Benefits: Social security coverage (IMSS).

• Christmas bonus (Aguinaldo) as per Mexican law.

• Vacation premium (Prima Vacacional).

• Remote work bonus.

• Paid leaves as per Federal Labor Law (LFT).