Data Engineer with Expertise in SQL Development and Snowflake, Digital Platform

DataArt•Belgrade, MT

29d

About The Position

Our client is a leading global travel agency network specializing in luxury and experiential journeys. They are seeking to strengthen their relational database and Azure data platform through enhanced design, architecture, development, and the creation of new features. We seek a skilled Data Engineer with expertise in SQL development and Snowflake. This role focuses on building data ingestion pipelines, ensuring data integrity, and developing service layers that support external users. Azure Cloud, SQL / T-SQL, Python, Snowflake, SQL Server Analyze, plan, develop, deploy, and manage large, scalable, distributed data systems. Develop automated tests for unit, integration, regression, performance, and build verification. Understand and apply advanced principles of entity-relationship model design, proper data typing practices, index management, data management, and data security. Research and prototype new product and database features, design, and architecture ahead of mainstream development. Implement monitoring and logging solutions to ensure reliability and traceability of data flows. Ensure security, scalability, and performance of data services exposed to external users. Review designs, code, and test plans of other developers, providing recommendations for improvement or optimization. Develop and maintain microservices and stateless architectures. Follow defined software development lifecycle best practices. Collaborate with management and stakeholders to accurately identify requirements and establish priorities.

Requirements

More than 8 years of experience designing and developing solutions with SQL, including 3 years specializing in Snowflake cloud data warehouses, along with extensive work on other relational and cloud-based databases.
Intermediate-level knowledge of developing solutions using Python and REST APIs.
Experience in developing relational and non-relational data platforms/data pipelines using Azure cloud solutions.
Familiarity with ETL/ELT processes, data modeling, and data warehousing concepts.
Proficiency with Git and CI/CD tools (e.g., Azure DevOps).
Desire and ability to work as part of a team with minimal supervision in a results-oriented, fast-paced, dynamic environment.
Time zone alignment until 5 PM UTC-3 (exclusive).
Good spoken English.

Nice To Haves

Database architecture and designing experience.
Advanced Snowflake experience
Advance level knowledge in automation test creation
Experience working with foreign clients
Understanding of Agile methodologies' development
Microsoft certificates
Experience with the Travel domain
Team player

Responsibilities

Analyze, plan, develop, deploy, and manage large, scalable, distributed data systems.
Develop automated tests for unit, integration, regression, performance, and build verification.
Understand and apply advanced principles of entity-relationship model design, proper data typing practices, index management, data management, and data security.
Research and prototype new product and database features, design, and architecture ahead of mainstream development.
Implement monitoring and logging solutions to ensure reliability and traceability of data flows.
Ensure security, scalability, and performance of data services exposed to external users.
Review designs, code, and test plans of other developers, providing recommendations for improvement or optimization.
Develop and maintain microservices and stateless architectures.
Follow defined software development lifecycle best practices.
Collaborate with management and stakeholders to accurately identify requirements and establish priorities.