Snowflake Data Engineer
Inn-Flow•Raleigh, NC
•Hybrid
About The Position
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.
Requirements
- 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.
Nice To Haves
- 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.
Responsibilities
- 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).
Benefits
- Health, dental, and vision insurance
- Short-Term Disability & Life Insurance
- 401(k) with a generous employer match
- Flexible vacation and PTO
- Paid holidays plus a floating holiday
- Paid volunteer time
- Employer-paid monthly parking
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
