Lead Data Engineer - Snowflake Platform Architect

Jobtailor; Minneapolis (MN); On-site; USD 140,000 - 190,000; Full time

Job summary

Jobtailor is seeking a senior software engineer specializing in data engineering to own the Snowflake data platform, oversee architecture, and lead end-to-end delivery from discovery to production. The role requires hands-on Snowflake, Python, and C#/.NET expertise, with a strong focus on data models, ETL/ELT pipelines, and REST API design.

You will engage with clients, drive technical decisions, and mentor teams while maintaining governance, cost controls, and security across cloud and on-prem

Qualifications

• 8+ years of professional software engineering experience, focused on data engineering.
• Demonstrated technical leadership beyond individual work.
• Hands-on Snowflake expertise, including data models and ELT/ETL pipelines.
• Experience owning data model or data platform design from requirements through production.
• Experience leading client or stakeholder discovery and shaping technical solutions.
• Ability to estimate and plan work at system and project level.
• Strong proficiency in Python and C# with recent hands-on experience.
• Experience with SQL Server, PostgreSQL, or MySQL.
• Proven experience designing, building, and consuming REST APIs.
• DevOps experience with CI/CD, deployment automation, and server configuration.
• Comfort with Windows Server and Linux environments.
• Track record of establishing engineering standards or practices.
• Ability to manage multiple concurrent client projects.
• Strong written and verbal communication, including technical communication with non-technical stakeholders.
• Preferred: agency or consultancy experience.
• Preferred: SnowPro certification; Core strongly preferred and Advanced a significant plus.
• Preferred: AI-assisted development tools and related Snowflake capabilities.

Responsibilities

• Own the technical solution and overall technical oversight for accounts from discovery through production and ongoing support.
• Lead discovery, gather client requirements, and present solutions and trade-offs.
• Lead architecture and own system design, including data models, warehouses, and ELT/ETL pipelines.
• Evaluate and estimate work at system and project level.
• Architect, build, maintain, and optimize Snowflake data models, warehouses, and pipelines.
• Develop complex SQL, stored procedures, and transformations.
• Apply Snowflake capabilities including Snowpipe, Streams and Tasks, dynamic tables, and external and stage integrations.
• Own Snowflake performance, governance, cost management, warehouse sizing, clustering, RBAC, and data security.
• Design and maintain back-end APIs and services in Python and C#/.NET.
• Design and own integrations with marketing, CRM, and analytics platforms.
• Own CI/CD and deployment paths across cloud and on-premise environments.
• Establish and improve engineering practices through code reviews, design reviews, and architecture decisions.
• Set technical direction, review designs, pair on difficult problems, and develop team expertise.
• Create and lead internal and client training.
• Act as technical escalation point for production issues and own corrective actions.
• Lead project-level technical communication with stakeholders and clients.
• Participate in new business scoping and pursuits.
• Contribute to technical reputation through knowledge sharing, writing, industry events, and panels.
• Evaluate new platform capabilities and AI-assisted development tooling.

Skills

Technical leadership

Estimating & planning

Communication

Multi-project management

Engineering standards

Tools

Snowflake

Python

C#

SQL

REST APIs

CI/CD

Windows Server

Linux

SQL Server

PostgreSQL

MySQL

Job description

Jobtailor is seeking a senior software engineer specializing in data engineering to own the Snowflake data platform, oversee architecture, and lead end-to-end delivery from discovery to production. The role requires hands-on Snowflake, Python, and C#/.NET expertise, with a strong focus on data models, ETL/ELT pipelines, and REST API design.

You will engage with clients, drive technical decisions, and mentor teams while maintaining governance, cost controls, and security across cloud and on-prem