Lead Software Engineer, Data

OpenKrill

United States

On-site

USD 140,000 - 200,000

Full time

14 days+

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Benefits offered by this job

Medical, dental, vision insurance

Mental health support

HSA/FSAs

Infertility benefits

401(k) with employer match

Parental leave

Tuition reimbursement

Free parking / commuter support

Job summary

Bold Orange is seeking a Lead Data Engineer focused on Snowflake to own end-to-end data platform solutions for clients. You will design data models, warehouses, and ELT/ETL pipelines while leading architecture decisions and collaborating with architects, engineers, and client teams.

You will implement Snowflake-based ETL pipelines, optimize performance and costs, and build REST APIs in Python/C#.NET to support production data flows. Occasional travel to client sites will be required.

Qualifications

8+ years of professional software engineering experience with data engineering focus.
Proven ownership of technical solutions for accounts or teams.
Deep Snowflake expertise with data models, warehouses, and ELT/ETL pipelines.
Ownership of data model or platform design from requirements through production.
Experience leading discovery and shaping technical solutions with clients.
Ability to estimate work at system and project levels.

Responsibilities

Own the technical solution and provide oversight from discovery through production and support.
Lead discovery and intake requirements directly from clients; present solutions and trade-offs.
Architect data models, warehouses, and pipelines in Snowflake for performance, scalability and cost.
Develop and tune SQL and transformations in Snowflake and relational DBs (SQL Server, PostgreSQL).
Own Snowflake performance, governance, and cost management across accounts.
Build and maintain back-end APIs in Python and C#/.NET to feed Snowflake.

Skills

Snowflake

Data modeling

ELT/ETL pipelines

SQL

Python

REST APIs

DevOps

CI/CD

RBAC / security governance

Windows & Linux

Architecture leadership

Client discovery & engagement

Redshift

Databricks

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

Redshift

Databricks

SQL Server

PostgreSQL

Job description

Location: Minneapolis, MN

Hires local to the Twin Cities Metro-Area can anticipate an in-office component of 1-2 days a week, employed with Bold Orange. If this position lists, "Open to Remote", hires outside of the metro area can anticipate travel to our Minneapolis, MN office on an as-requested basis. We value human connection and some travel is anticipated.

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.

Position Summary:

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.

Duties and 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: