Software Engineer, Data

Bold Orange Company•Minneapolis, MN

About The Position

Bold Orange (BOCO) is seeking a Software Engineer, Data to join their technology team. This is a hands-on, data-focused engineering role primarily centered on Snowflake. The engineer will be responsible for designing data models, building and optimizing pipelines, and transforming raw client data into reliable analytics and activation platforms. This role also involves back-end and DevOps engineering across multiple client engagements, collaborating with project managers, developers, and client stakeholders to deliver scalable solutions. Deep expertise in Snowflake is the primary focus, with potential work in Redshift and Databricks.

Requirements

4+ years of professional software engineering experience, with significant time spent in data engineering
Deep, hands-on Snowflake expertise: production experience designing data models and warehouses, building ELT/ETL pipelines, and writing performant SQL on the platform
Working knowledge of Snowflake performance tuning, cost optimization, and security/governance (warehouse sizing, clustering, RBAC)
Strong proficiency in Python and C# for back-end development
Hands-on experience with relational SQL databases (SQL Server, PostgreSQL, MySQL)
Proven experience building and consuming REST APIs
Practical DevOps experience: CI/CD pipelines, deployment automation, server configuration
Comfort working in both Windows Server and Linux environments
Ability to manage and context-switch across multiple concurrent client projects
Strong written and verbal communication skills, including technical communication with non-technical stakeholders

Nice To Haves

Active SnowPro certification(s) : SnowPro Core is strongly preferred, and one or more SnowPro Advanced certifications (e.g., Data Engineer, Architect) is a significant plus
Snowflake features of CoCo, CoWork, Horizon Catalog, and Horizon Context (Semantic Views).
Redshift and/or Databricks: experience with additional data warehouse or lakehouse platforms (both used at Bold Orange)
Experience with Azure DevOps, Azure App Services, or other Azure services
Exposure to HubSpot CMS, APIs, or marketing automation platforms
Familiarity with IIS, .NET deployment, or Windows service management

Responsibilities

Architect, build, and maintain data models, warehouses, and ELT/ETL pipelines in Snowflake, optimizing for performance, scalability, and cost
Develop and tune complex SQL, stored procedures, and transformations in Snowflake and supporting relational databases (SQL Server, PostgreSQL)
Leverage native Snowflake capabilities such as Snowpipe, Streams & Tasks, dynamic tables, and external/stage integrations to deliver reliable, near-real-time data flows
Own Snowflake performance, governance, and cost management, including warehouse sizing, clustering, role-based access controls, and data security
Design, build, and maintain back-end APIs and services in Python and C#/.NET that feed and consume the Snowflake platform
Manage CI/CD pipelines and support deployment automation across cloud and on-premise environments
Configure and maintain infrastructure on Windows Server and Linux environments
Integrate third-party platforms and APIs (HubSpot, Azure DevOps, and others)
Troubleshoot production issues across a multi-client environment with professionalism and urgency
Contribute to technical documentation, architecture decisions, and code reviews
Collaborate with account managers and clients to scope, estimate, and deliver technical work
Mentor junior engineers and contribute to team best practices