Lead Software Engineer, Data

Remote

San Francisco (CA)

Remote

USD 150,000 - 210,000

Full time

11 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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

About Bold Orange:

Bold Orange (BOCO) is a customer experience company. We believe authentic human connections are the single most important driver of business and societal progress. We exist to create these connections across the customer lifecycle, from acquisition to engagement to retention. Our culture is one of curiosity, collaboration, proactivity and always bringing the outside, future focused perspective to our clients.

Lead-level, hands-on data engineering role centered on Snowflake. You will own the technical solution for your accounts end to end, from discovery and requirements through architecture, build, and production, and you will be the person clients and internal teams look to for the answer on how the data platform should work.

Leads at Bold Orange take on the most critical and complex engineering work and are expected to be prolific contributors to the team's code, while also setting technical direction, establishing engineering practices, and multiplying the effectiveness of the engineers around them.

Snowflake powers a SaaS platform we operate and a growing share of our client data work, and it is where we are investing to get stronger, so deep and demonstrable Snowflake expertise is central to this role. We also work with Redshift and Databricks, both internally and on behalf of clients.

You will work alongside solution architects, other data engineers, project managers, and client teams across multiple concurrent engagements.

Position Duties & 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 your engagements, including the data models, warehouses, and ELT/ETL pipelines that result

  • Evaluate and estimate work confidently and accurately at the system and project level, not only at the component level

  • Architect, build, and maintain data models, warehouses, and pipelines in Snowflake, optimizing for performance, scalability, and cost

  • Take on the most critical, complex, and time-sensitive engineering work, and remain a prolific contributor to the team's code

  • Develop and tune complex SQL, stored procedures, and transformations in Snowflake and supporting relational databases such as SQL Server and PostgreSQL

  • Apply native Snowflake capabilities where they earn their place, including Snowpipe, Streams and Tasks, dynamic tables, and external and stage integrations for near-real-time data flows

  • Own Snowflake performance, governance, and cost management across accounts, including warehouse sizing, clustering, role-based access control, and data security

  • Design, build, and maintain back-end APIs and services in Python and C#/.NET that feed and consume the Snowflake platform

  • Design and own integrations with client and internal marketing, CRM, and analytics platforms, including the authentication, error handling, and monitoring that keep an integration reliable once it is in production

  • Own the CI/CD and deployment path for the systems you build, across cloud and on-premise environments

  • Establish, socialize, implement, measure, and iterate on engineering practices for the data practice, and raise the bar through code review, design review, and written architecture decisions

  • Delegate effectively and multiply the team: set technical direction, review designs before code is written, pair on hard problems, and grow depth on Snowflake and back-end development

  • Create and lead training for both internal teams and client teams on the solutions you build

  • Act as the technical escalation point for production issues in a multi-client environment, and own the fix and the follow-up so the same failure does not recur

  • Own the majority of project-level technical communication with senior internal stakeholders and with clients, and guide the team on how to communicate well

  • Participate in new business scoping and pursuits in your area of expertise

  • Contribute to the agency's technical reputation through internal knowledge sharing and external representation such as writing, industry events, and panels

  • Evaluate new platform capabilities and AI-assisted development tooling, and bring the ones that hold up into how the team works

Required Qualifications:
  • 8+ years of professional software engineering experience, with the majority of it in data engineering

  • Demonstrated technical leadership: owning the technical solution for an account, engagement, or team, and being accountable for work beyond your own

  • Deep hands-on Snowflake expertise: production experience designing data models and warehouses, building ELT/ETL pipelines, and writing performant SQL on the platform

  • Demonstrated ownership of a data model or data platform design from requirements through production, not just implementation of someone else's design

  • Experience leading discovery and shaping a technical solution directly with clients or business stakeholders, not only delivering against a specification handed to you

  • Ability to estimate and plan work accurately at the system and project level

  • Working knowledge of Snowflake performance tuning, cost optimization, and security and governance, including warehouse sizing, clustering, and RBAC

  • Strong proficiency in Python and C# for back-end development, with recent hands-on work in both

  • Hands-on experience with relational SQL databases such as SQL Server, PostgreSQL, or MySQL

  • Proven experience designing, building, and consuming REST APIs

  • Practical DevOps experience: CI/CD pipelines, deployment automation, and server configuration

  • Comfort in both Windows Server and Linux environments

  • A track record of establishing engineering standards or practices that other engineers followed

  • Ability to manage and context-switch across multiple concurrent client projects

  • Strong written and verbal communication, including technical communication with non-technical stakeholders and the confidence to lead a design conversation with a client

Preferred Qualifications:
  • Agency, consultancy, or client-services experience, with multiple concurrent clients and client-facing scoping and delivery

  • Active SnowPro certification, Core strongly preferred, Advanced (Data Engineer or Architect) a significant plus. We support and pay for certification, so a strong engineer without it is not ruled out

  • Working fluency with AI-assisted development tools, applied with engineering judgment about where they help and where they do not

  • Experience with recent Snowflake platform capabilities, including CoCo, CoWork, Horizon Catalog, and Horizon Context (Semantic Views)

  • Redshift and/or Databricks experience, both of which are in use at Bold Orange

  • Azure DevOps, Azure App Services, or other Azure services

  • HubSpot CMS, HubSpot APIs, or marketing automation platforms

  • IIS, .NET deployment, or Windows service management

Benefits That Matter:

Our benefits are designed to support life’s many stages—expected and unexpected. Eligible employees can access:

  • Medical, dental, and vision insurance

  • Virtual mental health support

  • Health Savings and Flexible Spending Accounts (including dependent care)

  • Infertility and critical illness benefits

  • 401(k) with generous 6–10% employer contribution

  • Paid parental leave

  • Tuition reimbursement

  • Free parking and commuter support

Note: Some benefits apply only to full-time employees.

Who We Are:

Our tone is professionally sassy. We embrace meat raffles, hot seats, and the occasional Jell-O shot. We like staff meetings that are informative, educational, and at times, damn funny. We believe in no hierarchy, no bullshit, no politics. Just honest, hard work and great fun.

Important to note: While we value AI as a tool, AI is not invited to Bold Orange interviews. We want to meet the wonderfully talented human you! Any suspected use of AI to inform or assist, while actively in an interview with Bold Orange, will result in exclusion from consideration for the role to which you applied or were referred.

Equal Opportunity Employer:

We are an equal opportunity employer, dedicated to a policy of nondiscrimination in employment on any basis including race, color, creed, gender, sexual orientation, age, disability, religion, national origin, marital status, familial status, ancestry, status as a veteran, status with regard to public assistance and any other characteristic protected by law. Bold Orange does not and will not discriminate against employees, prospective employees, clients, or vendors.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Software Engineer, Data
Lead Software Engineer, Data

Bold Orange Company, LLC • Minneapolis (MN)

Hybrid
USD 115,000 - 150,000
Medical, dental, and vision insurance
Virtual mental health support
Health Savings Account (HSA)
+4
Lead Software Engineer, Data
Lead Software Engineer, Data

Bold Orange • Minneapolis (MN), Saint Paul (MN)

Hybrid
USD 115,000 - 150,000
Medical, dental, and vision insurance
401(k) with employer contribution
Paid parental leave
+2
Senior Analyst
Senior Analyst

Remote Jobs • Minneapolis (MN)

On-site
USD 85,000 - 125,000
Medical, dental, and vision insurance
Mental health support
Health Savings Account
+4
Technical Product Owner
Technical Product Owner

Bold Orange • Fort Snelling Unorganized Territory (MN)

On-site
USD 85,000 - 125,000
Medical, dental, and vision insurance
Health Savings and Flexible Spending
401(k) with 6-10% employer contribute
+3
Senior Payroll & Benefits Administrator
Senior Payroll & Benefits Administrator

Remote • San Francisco (CA)

On-site
USD 110,000 - 160,000
Senior Pre-Sales Solution Architect
Senior Pre-Sales Solution Architect

Blue Orange Digital • United States

Remote
USD 150,000 - 180,000
Health insurance
401(k) with company matching
Fully remote in the United States
+1
Supervisor, Client Strategy & Services (Account Supervisor)
Supervisor, Client Strategy & Services (Account Supervisor)

Bold Orange • Fort Snelling Unorganized Territory (MN)

On-site
USD 80,000 - 115,000
Medical, dental, and vision insurance
401(k) with employer contribution
Paid parental leave
+4
Solutions Engineer
Solutions Engineer

Blue Orange Digital • New York (NY)

Remote
USD 150,000 - 230,000
Certification support across Snowflake
Remote-first with travel
Senior Payroll & Benefits Administrator
Senior Payroll & Benefits Administrator

Bold Orange Company, LLC • Minneapolis (MN), Saint Paul (MN)

On-site
USD 75,000 - 95,000
Medical insurance
Dental insurance
Vision insurance
+7
Digital Project Manager
Digital Project Manager

Bold Orange • Fort Snelling Unorganized Territory (MN)

Hybrid
USD 65,000 - 90,000
Medical, dental, and vision insurance
Mental health support
Health Savings and Flexible Spending
+5