About the roleInn-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-FlowWe 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
