Sr. Data Engineer

MAKE STRATEGY A REALITY | ACCELERATE YOUR GROWTH | CHOOSE YOUR PATH

As the world's leading change and transformation consultancy, we're helping businesses move from strategy to reality by taking a pragmatic and practical approach to build solutions that last.
We're seeking a Sr. Data Engineer in Quito to help us take vision to value and create lasting impact.

SUMMARY

We're modernizing enterprise data infrastructure by migrating legacy automation systems into a modern Snowflake-based data warehouse with dbt transformations. You'll be at the forefront of this transformation, building scalable data pipelines and analytics models that power executive decision-making across multiple resort properties. 

YOU WILL:

• Design and implement data ingestion pipelines using dlt (data load tool) to migrate SQL Server and API data sources into Snowflake, ensuring data quality and reliability 

• Develop and maintain dbt models following medallion architecture (bronze/silver/gold layers) to transform raw data into business-ready analytics models across multiple location schemas 

• Analyze legacy Python automation scripts to extract business logic and reimplement them as modern, scalable data transformations in dbt 

• Deliver code across three integrated repositories (legacy automation, Snowflake ingestion, dbt transformations) while maintaining version control best practices and documentation 

• Participate in daily standups to communicate progress, blockers, and technical decisions to cross-functional teams 

• Implement data quality tests and monitoring to ensure transformation accuracy and maintain trust in analytics outputs 

• Collaborate with stakeholders to understand reporting requirements and translate them into efficient data models

• 3+ years of experience with SQL and data modeling, with strong understanding of dimensional modeling and analytics schema design 

• Hands-on experience with dbt (data build tool) including model development, testing, documentation, and deployment across environments (dev/test/prod) 

• Proficiency in Python for data engineering tasks, including experience with data pipeline frameworks and working with APIs and database connections 

• Experience with cloud data warehouses (Snowflake preferred) and understanding of modern data stack architectures 

• Strong understanding of ETL/ELT patterns and medallion architecture (bronze/silver/gold layers) 

• Ability to read and reverse-engineer legacy code to extract business logic and data transformation requirements 

• Excellent communication skills with ability to articulate technical concepts and provide clear status updates in standup meetings 

• Experience with Git version control and collaborative development workflows 

IDEALLY, WE'D LIKE:

• Hands-on experience with dlt (data load tool) framework or similar data ingestion tools (Airbyte, Fivetran, etc.) 

• Experience migrating legacy systems to modern cloud-based data platforms, particularly from on-premise to Snowflake 

• Familiarity with hospitality or retail analytics, including POS systems, revenue management, or business intelligence reporting 

• Knowledge of data quality frameworks, testing strategies, and data observability best practices 

• Experience with multi-tenant or multi-location data architectures requiring schema 

Applicants must be authorized to work in Ecuador, without the need for visa sponsorship by North Highland. Work visa sponsorship will not be provided, either now or in the future, for this position.

North Highland is an equal opportunity employer, and we adhere to all applicable laws and regulations to ensure a fair and equitable workplace. All qualified applicants will receive fair and impartial consideration without regard to race, color, sex, gender identity, religion, national origin, age, sexual orientation, disability, veteran status, or any other characteristic protected by law. We handle all information in accordance local privacy standards and maintain strict confidentiality.