The Role
Design, build, and maintain Snowflake data models, warehouses, and ELT/ETL pipelines; develop backend services in Python and C#; manage CI/CD and deployments; troubleshoot production issues; collaborate with clients and mentor junior engineers.
Summary Generated by Built In
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:
We are looking for a Software Engineer, Data to join our growing technology team. This is a hands-on, data-focused engineering role centered on Snowflake. You’ll design data models, build and optimize pipelines, and turn raw client data into reliable, well-governed analytics and activation platforms. You’ll pair that data work with back-end and DevOps engineering across multiple client engagements, collaborating closely with project managers, developers, and client stakeholders to deliver scalable, performant solutions. Snowflake powers a SaaS platform we operate and a growing share of our data work, and it’s where we’re investing to get stronger, so deep, demonstrable Snowflake expertise is the primary focus of this role. You may also work with Redshift and Databricks, which we use internally and on behalf of clients, but Snowflake is where we want this person to be strongest.
Duties and Responsibilites:
- 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
Required Qualifications:
- 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
Preferred Qualifications:
- 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
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.
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.
Skills Required
- 4+ years professional software engineering experience, with significant data engineering experience
- Deep hands-on Snowflake expertise: designing data models, warehouses, ELT/ETL pipelines, and writing performant SQL
- Knowledge of Snowflake performance tuning, cost optimization, and governance (warehouse sizing, clustering, RBAC)
- Strong proficiency in Python for back-end development
- Strong proficiency in C#/.NET for back-end development
- Hands-on experience with relational 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
- Active SnowPro certification(s) (SnowPro Core preferred, SnowPro Advanced a plus)
- Familiarity with Snowflake features: CoCo, CoWork, Horizon Catalog, Horizon Context (Semantic Views)
- Experience with Redshift and/or Databricks
- 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
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Bold Orange is a customer experience agency helping brands with end-to-end CX needs inclusive of go-to-market experiences, content, UX/UI, loyalty and CRM, performance marketing, digital media and Salesforce Marketing Cloud implementation.
