The Role
Build and optimize Snowflake data models, warehouses, and ELT/ETL pipelines. Develop Python and C#/.NET APIs, manage CI/CD and infrastructure across Windows and Linux, integrate third-party platforms, and support data governance, security, performance, and cost optimization. Troubleshoot production issues across multiple client projects, document architecture, collaborate with stakeholders, participate in code reviews, 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.
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.
Skills Required
- 4+ years of professional software engineering experience, including significant data engineering experience
- Deep production experience designing Snowflake data models and warehouses, building ELT/ETL pipelines, and writing performant SQL
- Working knowledge of Snowflake performance tuning, cost optimization, security, and governance
- Strong proficiency in Python and C# for back-end development
- Hands-on experience with SQL Server, PostgreSQL, and MySQL
- Experience building and consuming REST APIs
- Practical DevOps experience with CI/CD pipelines, deployment automation, and server configuration
- Experience working in Windows Server and Linux environments
- Ability to manage and context-switch across multiple concurrent client projects
- Strong written and verbal communication skills, including communication with non-technical stakeholders
- Active SnowPro certification, preferably SnowPro Core
- SnowPro Advanced certification, such as Data Engineer or Architect
- Experience with Snowflake CoCo, CoWork, Horizon Catalog, or Horizon Context
- Experience with Redshift 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.
