Snowflake Integration Developer

Xanterra; Greenwood Village (CO); On-site; USD 105,000 - 115,000; Full time

Job summary

An established industry player in travel and leisure is seeking a detail-oriented Snowflake Integration Developer to join their Data and Analytics Team. In this role, you will design and implement scalable data integration pipelines, collaborating with a dynamic team to deliver robust data solutions. You will optimize data flows and ensure secure access to data across the organization, all within a collaborative and inclusive environment. This position offers a unique opportunity to grow your career while making a significant impact on data-driven decision-making. Join a company committed to sustainability and innovation, where your contributions will shape unforgettable experiences for guests.

Benefits

Medical, Dental & Vision

HSA & FSA

Life & Disability Insurance

401(k) with Company Match

Paid Time Off

Employee Assistance Plan

Education Assistance

RTD-Denver transit pass

Employee Discounts

Travel Deals

Qualifications

• 3+ years experience with Snowflake in data engineering or integration role.
• Strong knowledge of cloud database systems and ETL tools.
• Proficiency in SQL and scripting languages.

Responsibilities

• Designing and implementing scalable data integration pipelines using Snowflake.
• Collaborating with stakeholders to gather requirements for data solutions.
• Optimizing data flows and ensuring secure access to data.

Skills

Snowflake

SQL

Python

ETL/ELT processes

Data integration

Scripting (Bash)

Data warehousing best practices

Cloud platforms (AWS, Azure, GCP)

Documentation skills

Education

Bachelor’s degree in Information Technology

Bachelor’s degree in Computer Science

Tools

Informatica

Fivetran

dbt

Talend

Microsoft SQL Server

Azure SQL Database

Azure Synapse

Oracle (19 and forward)

Job description

Overview

Xanterra Travel Collection is a growing, exceptional group of travel and leisure businesses operating across the globe. Our properties/services combine dramatic settings and landmark buildings with exceptional service to deliver unforgettable experiences. We are inspired by our guests, our environment, and each other. Headquartered in our beautiful Greenwood Village, Colorado offices, we strive to create a collaborative experience and a transformational journey for our valued team members. We have a high commitment to sustainability, growth and are seeking driven, innovative individuals who value offerings in career development and professional advancement. Our Travel Collection includes lodging, food and beverage, Windstar Cruises, short-line railroad, and adventure travel companies. Please visit xanterra.com for more information on the company and its environmental initiatives.

We are currently seeking a detail-oriented and driven professional to join us as a Snowflake Integration Developer within our Data and Analytics Team. Our technology team is dynamic, with a strong sense of dedication to our customers. In our collaborative and inclusive work environment, individuals strong on aptitude and attitude will have an opportunity to grow their professional careers.

Responsibilities

In this role, you will be responsible for designing and implementing scalable data integration pipelines using Snowflake. You will collaborate with data architects, analysts, and business stakeholders to gather requirements and deliver robust data solutions. You will play a key role in optimizing data flows, and ensuring secure, reliable access to data across the organization. Per our company policy, we will require this position to be in office 5 days a week.

You Will Make an Impact By:

1. Implementing secure and cost-effective strategies to integrate data across enterprise-scale technology platforms.
2. Developing ETL/ELT processes to ingest structured and unstructured data from diverse sources (e.g., APIs, databases, data lakes).
3. Automating data ingestion and transformation processes using SQL, Python, and scripting tools.
4. Ensuring data quality, consistency, and security throughout the integration lifecycle.
5. Documenting integration processes, data flows, and technical specifications.
6. Optimizing performance and cost of Snowflake workloads (warehouse sizing, clustering, query tuning).
7. Implementing monitoring and alerting for data pipelines and Snowflake environments.
8. Engaging in continual learning to remain abreast of industry best practices, new technologies, and emerging standards.

Qualifications

• Education/Experience: Bachelor’s degree in Information Technology or Computer Science with a concentration in Information Technology, Programming or Database Management. 3+ years of experience working with Snowflake in a data engineering or integration role. Significant work experience can substitute for formal education.
• Technical Knowledge: Strong knowledge/experience with on-premises and cloud database systems, including Snowflake, Azure SQL Database, Azure Synapse, Fabric, Microsoft SQL Server and Oracle (19 and forward). Advanced SQL development and query optimization skills. Hands-on experience with data integration/ETL tools (e.g., Informatica, Fivetran, dbt, Talend). Proficiency in scripting languages such as Python or Bash. Experience working with cloud platforms (AWS, Azure, or GCP). Knowledge of data warehousing best practices and modern data architecture (e.g., ELT, Data Lakehouse).
• Security Knowledge: Knowledge and prior experience with common security and privacy standards – PCI-DSS, GDPR, CCPA, HIPAA — and implicit integration of these security standards in all aspects of your work. Understanding of security and access controls in Snowflake (RBAC, data masking, etc.).
• Documentation Toolset Skills: Strong oral and written communication skills with the ability to synthesize and present information clearly. Proficiency in the Microsoft Office suite of products for authoring and collaboration is required.

What Will Set You Apart

Our preferred candidate will also bring one or more of the following skills:

1. Snowflake certification(s) (e.g., SnowPro Core or Advanced).
2. Critical thinking and problem-solving skills, including planning, organizing and adaptability.
3. Familiarity with DevOps practices, CI/CD for data pipelines.
4. Ability to interact with team members at all levels of the organization and with cross functional teams.
5. Experience in travel, hospitality and/or cruise industries.

COMPENSATION: The salary range for this position is $105,000.00 to $115,000.00.

BENEFITS: For full-time employees, Xanterra offers a comprehensive benefits package including: Medical, Dental & Vision; HSA & FSA; Life & Disability; Accident, Hospital & Critical Illness; Pet Insurance; PTO and paid Holidays; 401(k) with Company Match; Employee Assistance Plan; Education Assistance; RTD-Denver transit pass for in-office employees, and Employee Discounts & Travel Deals.

EEO: Xanterra is committed to a diverse and inclusive workplace. We are an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, pregnancy, genetic information, protected veteran status, or any other legally protected status.