Snowflake-focused Data Engineering Lead (Hands-On)

Remote; San Francisco (CA); Remote; USD 150,000 - 210,000; Full time

Benefits offered by this job

Medical, dental, vision

401(k) with employer contribution

Job summary

Bold Orange is seeking a Lead Data Engineer focused on Snowflake to own the technical solution end to end for multiple client accounts. You will drive discovery, architecture, ELT/ETL pipelines, and performance tuning across Snowflake, Redshift, and Databricks, collaborating with solution architects, engineers, and client teams.

You will design data models, build back-end APIs in Python and C#/.NET, and own CI/CD deployment paths.

Qualifications

• 8+ years in software engineering with data engineering focus.
• Ownership of technical solutions for accounts or teams.
• Snowflake production experience with data models and ELT/ETL.
• End-to-end data platform design from requirements to production.
• Experience shaping technical solutions with clients.
• Ability to estimate work at system/project level.
• Knowledge of Snowflake performance tuning, security, governance.
• Proficiency in Python and C# for backend.
• Experience with SQL databases (SQL Server, PostgreSQL, MySQL).
• Experience designing REST APIs.
• DevOps experience: CI/CD, deployment automation.
• Windows and Linux environments.
• Establish engineering standards and practices.
• Ability to manage multiple concurrent client projects.
• Strong written and verbal communication.

Responsibilities

• Own the technical solution and provide overall technical oversight for your accounts, from discovery through production and ongoing support.
• Lead discovery, intake requirements directly from clients, and present solutions and trade-offs to client stakeholders yourself.
• Lead the architecture and own the system design for engagements, including data models, warehouses, and ELT/ETL pipelines.
• Evaluate and estimate work confidently at the system and project level.
• Architect, build, and maintain data models, warehouses, and pipelines in Snowflake, optimizing for performance, scalability and cost.
• Develop and tune SQL, stored procedures, and transformations in Snowflake and relational databases.
• Own Snowflake performance, governance, and cost management across accounts (RBAC, clustering).
• Design and maintain back-end APIs and services in Python and C#/.NET.
• Own CI/CD and deployment path across cloud and on-premise environments.
• Lead engineering practices, code/design reviews, and architecture decisions.
• Delegate effectively and grow depth on Snowflake and back-end development.
• Create and lead training for internal and client teams.
• Act as escalation point for production issues and implement fixes.
• Communicate with senior stakeholders and guide teams on technical relationships.
• Contribute to new business scoping and industry knowledge sharing.

Skills

Snowflake expertise

Python

C# / .NET

SQL Server

PostgreSQL

REST APIs

CI/CD

Windows/Linux

Data modeling

Leadership

Tools

Azure DevOps

Azure App Services

Databricks

Redshift

HubSpot APIs

Job description

Bold Orange is seeking a Lead Data Engineer focused on Snowflake to own the technical solution end to end for multiple client accounts. You will drive discovery, architecture, ELT/ETL pipelines, and performance tuning across Snowflake, Redshift, and Databricks, collaborating with solution architects, engineers, and client teams.

You will design data models, build back-end APIs in Python and C#/.NET, and own CI/CD deployment paths.