FREE ACCESS
5,000–10,000 jobs/day

See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Tech Stack
Tools & technologiesAmazon RedshiftAWSCloudPythonSQL
About the role
Key responsibilities & impact- Implement the curated data model layer in dbt across 18 data domains, working closely with the Onshore Analytics Engineering Lead.
- Design and build dbt models across the full layered architecture: staging, intermediate, and mart layers.
- Implement comprehensive dbt testing strategies, including unique, not_null, accepted_values, relationships, and custom tests to ensure data quality and reliability.
- Develop and optimize incremental models to handle high-volume domains processing billions of events efficiently.
- Generate and maintain thorough project documentation, including column descriptions and lineage graphs, to support transparency and team collaboration.
Requirements
What you’ll need- Advanced proficiency in dbt, including model development, testing frameworks, macros, and incremental strategies.
- Expert-level SQL skills, with strong ability to write performant, maintainable queries across large datasets.
- Solid understanding of data modeling principles, including dimensional modeling and layered architecture best practices.
- Hands-on experience with AWS data services, particularly Athena and Redshift Serverless.
- Working knowledge of Python for data engineering tasks and pipeline support.
- Ability to work cross-functionally across multiple data domains and communicate technical concepts clearly to stakeholders.
- English: Advanced (required for effective communication with global teams).
- 3+ years of experience in Analytics Engineering or Data Modeling roles, with hands-on expertise building layered dbt pipelines and working with cloud-based analytical data platforms.
Benefits
Comp & perks- Learning Opportunities: Certifications in AWS (we are AWS Partners), Databricks, and Snowflake.
- Access to AI learning paths to stay up to date with the latest technologies.
- Study plans, courses, and additional certifications tailored to your role.
- Access to Udemy Business, offering thousands of courses to boost your technical and soft skills.
- English lessons to support your professional communication.
- Travel opportunities to attend industry conferences and meet clients.
- Mentoring and Development: Career development plans and mentorship programs to help shape your path.
- Celebrations & Support: Special day rewards to celebrate birthdays, work anniversaries, and other personal milestones.
- Company-provided equipment.
- Flexible working options to help you strike 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).
ATS Keywords
✓ Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
dbtSQLdata modelingdimensional modelingincremental modelsdata testing strategiesPythondata pipeline supportperformance optimizationdata quality
Soft Skills
communicationcollaborationcross-functional teamworktechnical concept explanation
