Search 25,712 current hospitality jobs

Cloud Data Engineer



Posted March 23, 2023

Best Friends Roadhouse and Mercantile
Kanab, UT
Save this job


$90,000 to $110,000

About This Job

Location: Remote

Hiring Range:  This position hiring range is anticipated to be $90,000 to $110,000 annually, depending on experience.  

All staff in Information Technology Services – regardless of their unique position - are expected to perform their assigned duties in a manner consistent with professional standards, with full awareness of responsibilities toward managing personal and organizational data, with priority regard to delivering customer service, as leaders in learning and adapting to new technologies and in constructive and effective collaboration with colleagues.

Position Summary: The Cloud Data Engineer is responsible for building data pipelines that translate data from its raw form into curated data structures for use in data science, analysis, and visualization. This role is responsible for working with business and technical stakeholders from across the organization to ensure data is ingested from source systems, persisted in the data lake, and curated for downstream analytics purposes. This role also maintains existing solutions in our SQL data warehouse environment, to include databases and ETL processes.

Essential Duties/Responsibilities

  • Use the AWS big data stack (S3, Glue, Python, etc) and third party tools (Snowflake, Matillion, Fivetran, Tableau) while following Best Friends’ best practices, policies, and standard operating procedures to design, code, test, document, and deploy data pipelines to ingest, transform, and curate raw source data into data useable for analytics.
  • Ensure data pipelines have appropriate monitoring and alerting to guarantee data availability to downstream analytics processes.
  • Recommend improvements to the information architecture of the data lake to ensure the security and findability of the information.
  • Maintain expertise on current and future offerings from AWS, Snowflake, Matillion, Fivetran and others as it relates to data engineering. Make recommendations to improve and optimize data processing.
  • Work with other IT and business teams to troubleshoot, determine root cause, troubleshoot, and solve operational issues.
  • Maintain consistent project and standards documentation for data pipelines and development practices.
  • Treat people around you with Kindness and Compassion, build trust by demonstrating authenticity and following through on your commitments, prioritize your well-being like you do our mission, and work to build strong relationships with your colleagues by participating in communication loops to share and receive honest feedback. You are responsible and accountable for the culture you add to your team dynamic.

Skills & Experience

  • A minimum of 5 years of experience in data processing using a combination of SQL, NoSQL, and AWS data platforms.
  • Understanding of and experience with traditional SQL data warehouses as well as modern cloud data lake platforms and technologies.
  • Demonstrated ability designing and building data pipelines with the AWS serverless big data stack (S3, Glue, Python, Lambda, Athena, Cloud Formation)
  • Experience with Snowflake and ETL/ELT pipeline tools (Fivetran, Matillion, etc) strongly preferred.
  • Expertise in the Microsoft BI Stack, including: 
    • Experience in developing SSIS and SSDT packages in Visual Studio
    • Demonstrated ability designing and building ETL plans using MS SSIS
    • Experience with complex T-SQL queries and data relationships
  • Ability to analyze user requirements and translate them into data models and pipelines according to specifications.
  • Exceptional written and verbal communication skills and the ability to explain technology in non-technical terms.
  • Exceptional analytical, conceptual, and problem-solving skills.
  • Able to prioritize and execute tasks in a fluid and highly visible environment.
  • Experience in the Tableau Desktop and Tableau Server BI environments a plus.
  • Experience with Enterprise CRM environments and databases, preferably with Blackbaud CRM, a plus.
  • A bachelor’s degree in computer science, information systems, computer engineering, or a related field or equivalent experience. 

Physical Requirements

  • Able to work at a computer for extended periods of time with repetitive typing, arm and hand motion.
  • Able to occasionally work outside of normal business hours for support and deployment activity.
  • Able to participate in on-call rotation as necessary.
Save this job

About this Employer

Best Friends Roadhouse and Mercantile

30 North 300 West
Kanab, UT 84741

Telephone (435) 644-2001
Reservations (435) 644-3400

40 Room Hotel

About Best Friends Animal Society

The Best Friends Roadhouse and Mercantile is an extension of the longstanding hospitality experienced at Best Friends Animal Sanctuary. Best Friends Animal Society is a leading national animal welfare organization dedicated to ending the killing of dogs and cats in America's shelters. In addition to running lifesaving programs in partnership with thousands of animal welfare groups across the country, Best Friends has operations in New York City, Los Angeles, Atlanta, Houston, Salt Lake City and Northwest Arkansas and runs the nation’s largest no-kill animal sanctuary.

Best Friends Animal Society is a leading animal welfare organization working to end the killing of dogs and cats in America’s shelters by 2025. Founded in 1984, Best Friends is a pioneer in the no-kill movement and has helped reduce the number of animals killed in shelters from an estimated 17 million per year to about 347,000. Best Friends runs lifesaving programs all across the country, as well as the nation’s largest no-kill animal sanctuary. Working collaboratively with a network of more than 3,300 animal welfare and shelter partners, and community members nationwide, Best Friends is working to Save Them All®. 

While you are in Kanab, we welcome you to learn more about our lifesaving work, schedule a tour of the Sanctuary, and consider becoming a member of Best Friends Animal Society

Who We Are 

For over 30 years, Best Friends Animal Society has been running the nation’s largest no-kill sanctuary for companion animals and building effective programs that reduce the number of animals entering shelters.

The Best Friends Roadhouse Story

Your southern Utah vacation experience just got better: Welcome to the Best Friends Roadhouse and Mercantile, the latest (and greatest) lodging option among Kanab’s fast-growing hotel and motel offerings.

Located in the heart of Kanab, Utah, just five miles south of Best Friends Animal Sanctuary, the Best Friends Roadhouse & Mercantile welcomes pets and their people. For visitors to the Sanctuary and nearby national parks, it provides a pet-friendly place to stay.

The Roadhouse features 40 rooms as well as a variety of dog- and cat-friendly amenities and services, such as built-in cubbies for snuggling, dog washing stations, pet walking and a fenced dog park area with a splash zone. It’s an animal lover’s dream come true! We can’t wait to welcome you to the Roadhouse, where you can experience the warmth of Best Friends hospitality.

Just for Pets

At the Best Friends Roadhouse & Mercantile, pets are just as much guests as their people are. For their comfort and happiness, we are pleased to provide:

  • Personal pet welcome
  • Complimentary self-serve pet washing facilities
  • Complimentary cleaning products, located in the service building
  • Pet walking service provided in half-hour increments by Best Friends volunteers and staff (a fee applies)
  • Pet visits by our staff during the day (a fee applies)
  • Fenced pet-park area with splash water feature (for pets of lodging guests)
  • Pet treats, beds and retail items in the mercantile building
  • Built-in cubbies and snuggling areas in select guest rooms

Best Friends Animal Society is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to their race, religion, ancestry, national origin, sex, sexual orientation, age, disability, marital status, domestic partner status, or medical condition.