Key skills
Amazon RedshiftAWSPythonSQLAIData EngineeringAnalyticsSnowflakeRedshiftDatabricksdbtServerlessAthenaMentoringCommunicationCollaboration
About this role
Role Overview
- 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
- 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).
Tech Stack
- Amazon Redshift
- AWS
- Python
- SQL
Benefits
- 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.
- Other benefits may vary according to your location in LATAM.