Snowflake Data Engineer

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 HotelTechAwards 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.

About the Role

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.

What You'll Do

• 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 GitHub Actions, and contribute to platform documentation (ADRs, runbooks, onboarding material).

Qualifications

• 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 Gen2.
• 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 (GitHub 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, GitHub Copilot, and similar) as part of your day-to-day workflow to produce higher-quality outputs faster, for code, SQL, documentation, and analysis.

What Makes You a Standout

• Experience building or operating multi-tenant SaaS analytics platforms.
• Hands-on experience with Apache Iceberg, open table formats, or external catalogs.
• Experience designing row-access or column-level security policies in Snowflake at scale.
• Experience with Snowflake Data Shares (inbound or outbound).
• Experience with BI tools, especially Sigma (Power BI or Looker as an adjacent experience).
• Experience in the hospitality industry.
• Experience with B2B ERP solutions.

Why You'll Love Working at Inn-Flow

We believe great work starts with taking great care of our people.

At Inn-Flow, you'll enjoy: Benefits • Health, dental, and vision insurance • Short-Term Disability & Life Insurance • 401(k) with a generous employer match Time Off & Flexibility • Flexible vacation and PTO • Paid holidays plus a floating holiday • Paid volunteer time • Hybrid work schedule with in-office collaboration on Tuesdays and Thursdays in our Raleigh office (remote Mondays, Wednesdays, and Fridays) Work Environment & Culture • A beautiful, modern office in downtown Raleigh • Employer-paid monthly parking • Monthly team socials and regular celebrations • Quarterly all-hands meetings • A culture rooted in recognition, collaboration, and growth • Smart, kind, and genuinely fun people who care about their work - and each other

Equal Opportunity Employer Inn-Flow is proud to be an Equal Opportunity Employer, upholding a work environment free from discrimination and harassment. We make our hiring decisions based on business needs, job requirements, and individual qualifications, without regard to race, color, religion, family status, or any other non-business consideration. We stand firmly against discrimination and harassment in any form.