Snowflake Data Engineer

At Inn-Flow, we’re more than a hotel software company - we’re a team on a mission to transform how the hospitality industry operates. Built by hoteliers, for hoteliers, our all-in-one back‑office platform brings together accounting, labor management, payroll, business intelligence, and more into one seamless experience. Our technology empowers hotel operators to work smarter, make better decisions, and focus on what matters most: delivering exceptional guest experiences.

Inn-Flow is experiencing strong growth and momentum, backed by the strategic investment from Mainsail Partners. As we scale, we’re expanding the leadership team, accelerating innovation, and deepening our impact across the hospitality industry, all while staying grounded in the real needs of operators.

Our commitment to both customers outcomes and employee experience has earned industry recognition, including multiple top honors from the 2026 Hotel Tech Awards  and recognition as a Top 10 Best Places to Work in Hotel Tech and Triangle Business Journal’s #2 Best Place to Work.

At Inn-Flow, you’ll have the opportunity to do meaningful work, grow your career, and be part of a company that’s shaping the future of hospitality technology.

Inn-Flow is hiring a Snowflake Data Engineer with 3+ years of hands‑on experience designing, building, and operating data platforms on Snowflake. The ideal candidate brings strong SQL expertise, deep knowledge of data warehousing and dimensional modeling, and hands‑on experience with dbt and a managed ELT tool like Fivetran to deliver scalable, secure analytics for our hospitality customers.

• Design, develop, and maintain dbt models across medallion architecture, including the macros, tests, and patterns that keep our multi‑tenant model tree clean and consistent.
• Build and operate ingestion pipelines, onboard new sources, handling schema evolution, and monitoring freshness.
• Write efficient SQL for transformations, exploratory analysis, and performance tuning across SQL Server source data and Snowflake target models.
• Implement data governance and security controls within Snowflake including role‑based access, row‑access policies, dynamic data masking, and audit logging and testing.
• Tune Snowflake for performance and cost efficiency with warehouse sizing, query optimization, dynamic table refresh strategies, and per‑tenant cost attribution.
• Collaborate with product, customer‑facing, and engineering teams to translate business questions into reliable data models and Sigma dashboards.
• Monitor and troubleshoot the platform for data quality, freshness, and pipeline reliability.
• Automate repetitive work using Python, dbt macros, and Git Hub Actions, and contribute to platform documentation (ADRs, runbooks, onboarding material).

• 3+ years of experience as a Data Engineer, including hands‑on time with Snowflake.
• Proficiency in SQL for querying, data transformation, and optimization.
• Hands‑on experience with core Snowflake features: dynamic tables, secure views, RBAC, row access policies, masking, warehouses, and external tables / Iceberg.
• Working experience with dbt (Core or Cloud): model authoring, macros, tests, and project organization.
• Experience with a managed ELT tool (Fivetran, Stitch, Airbyte, or similar) for source onboarding and pipeline management.
• Experience with SQL Server for querying and integration.
• Strong understanding of data warehousing concepts and dimensional modeling (medallion or Kimball).
• Familiarity with Azure cloud services: particularly Azure Data Lake Storage Gen
  2.
• Proficiency in at least one scripting language (e.g. Python) for automation.
• Familiarity with version control systems (e.g., Git) and CI/CD pipelines for data engineering workflows (Git Hub Actions a plus).
• Strong problem‑solving and analytical skills.
• Excellent communication and collaboration abilities to work with cross‑functional teams.
• Ability to manage multiple priorities in a fast‑paced environment.
• Comfortable using AI tools (Claude, ChatGPT, Cursor, Git Hub Copilot, and similar) as part of your day‑to‑day workflow to produce higher‑quality outputs faster, for code, SQL, documentation, and…