Senior Data Engineer

Job Description

In this hands-on role as a Senior Data Engineer, your primary responsibility will be to partner with key business partners, data analysts and software engineers to design and build a robust, scalable, company-wide data infrastructure to move and translate data that will be used to inform strategic business decisions. You will ensure performance, stability, cost-efficiency, security, and accuracy of the data on the centralized data platform. The ideal candidate will possess advanced knowledge and hands-on experience in data integration, building data pipelines, batch processing frameworks, and data modeling techniques to facilitate seamless data movement. You will collaborate with various technology and business stakeholders to define requirements and design and deliver data products that meet user needs. The candidate should demonstrate intellectual acumen, excel in engineering best practices, and have a strong interest in developing enterprise-scale solutions using industry-recognized cloud platforms, data warehouses, data integration and orchestration tools.

This full-time position reports to the Senior Manager and is expected to work in a hybrid model, which currently includes Tuesday and Wednesday in-office

What you’ll do:

• Data Infrastructure Design: Develop and maintain robust, scalable, and high-performance data infrastructure to meet the company-wide data and analytics needs
• Data Lifecycle Management: Manage the entire data lifecycle, including ingestion, modeling, warehousing, transformation, access control, quality, observability, retention, and deletion
• Strategic Data Movement: Define and implement data integration strategies to collect and ingest various data sources. Design, build and launch efficient and reliable data pipelines to process data of different structures and sizes using Python, APIs, SQL, and platforms like Snowflake
• Collaboration and Consultation: Serve as a trusted partner to collaborate with technical and cross-functional teams to support their data needs, address data-related technical issues, and provide expert consultation
• Process Efficiency and Stability: Apply engineering best practices to streamline manual processes, optimize data pipelines, and establish observability capabilities to monitor and alert data quality and infrastructure health and stability
• Innovative Solutions: Stay updated on the latest technologies and lead the evaluation and deployment of cutting-edge tools to enhance data infrastructure and processes
• Coaching and Mentorship: Foster a culture of knowledge sharing by acting as a subject matter expert, leading by example, and mentoring others

What you bring to the table:

• 8+ years of professional experience in the data engineering
• Extensive hands-on experience with designing and maintaining scalable, efficient, secure and fault tolerant distributed database on Snowflake Cloud Data Platform
• In-depth knowledge on cloud platforms, particularly Azure or AWS. In addition to Python and SQL
• Proficient in designing and implementing data movement pipelines for diverse data sources including databases, external data providers, and streaming sources, for both inbound and outbound data workflows
• Deep understanding of relational database (SQL Server, Oracle, Postgres, and MySQL) with advanced SQL and Python skills for building API integration, ETLs, and data models
• Proven experience in building efficient and reliable data pipelines with comprehensive data quality checks, workflow management, and CI/CD integration
• Excellent analytical thinking skills for performing root cause analysis on external and internal processes and data, resolving data incidents, and identifying opportunities for improvement
• Effective communication skills for articulating complex technical details in simple business terms to non-technical audience from a various business function
• Strong understanding of coding standards, best practices, and data governance

About Us: Balsam Brands is a global, eCommerce retailer with roots in holiday and home décor. We strive for excellence in everything we do and present a unique opportunity for those seeking to have a meaningful impact in a people-first company that values relationship building, authenticity, and doing the right thing. We have steadily growing teams in Boise, the Bay Area, Dublin, and the Philippines.

The company's mission is to create joy together. We empower our team and partners to love what they do, provide products and experiences that inspire meaningful moments with family and friends, and give back to our families and communities in impactful ways. When you join Balsam Brands, you'll find a culture of caring people doing challenging work and building a welcoming workplace.

• Check out our flagship brand, Balsam Hill: www.balsamhill.com
• Balsam Brands in Forbes: https://bit.ly/balsambrandsforbes2023
• Balsam Brands on LinkedIn: http://www.linkedin.com/company/balsam-brands/
• Glassdoor: https://bit.ly/balsambrands-glassdoor

At Balsam Brands, we strive to offer a competitive compensation and benefits package. For permanent, full-time team members, our current package includes:

• Competitive compensation, including a cash-based incentive plan; salary is reviewed yearly and may be adjusted as part of the normal compensation review process
• Comprehensive Medical, Dental, and Vision coverage, with 100% of monthly premiums covered for team members, and 85%+ employer-paid premiums for other coverage tiers that include dependents
• Up to $2,000 annual funding toward HSA accounts
• Medical, transit, dependent care FSA
• Infertility coverage offered on all medical plans
• Generous parental leave program and flexible return options
• Company-paid life and AD&D insurance
• Company-paid short and long-term disability insurance
• 401(k) with dollar-for-dollar company match up to $4,000 per calendar year
• Employee Assistance Program (EAP) and other mental health and wellness perks
• Paid holidays, annual shutdown week, PTO, and volunteer time-off (VTO) packages
• Paid 5-week sabbatical leave after 10 years of employment
• Annual continuous learning benefit up to $1,000 per person, per fiscal year
• Up to $300 flexible reimbursement to support setup of new team member's work-from-home environment
• Generous team member merchandise discount
• Valuable extras: identity theft protection, subsidized parking, monthly wellness, pet insurance, accident & critical illness insurance

The base pay range for this position is: $155,000 to $170,000. Where an individual falls within that range will vary based on several factors including geographic location and may vary depending on candidate qualifications and experience, applicable skills, and other job-related factors. We benchmark our pay ranges against current external data sources and regularly review compensation for our team members. Balsam Brands is committed to providing our team members with an internally fair, externally competitive, and fiscally prudent total compensation package administered in a simple and consistent manner.

At Balsam Brands, we strive to build a diverse, equitable, and inclusive team to fulfill our purpose to create joy together. Balsam Brands is proud to be an equal opportunity employer. We encourage people from all backgrounds, ages, abilities, and experiences to apply. We do not discriminate on the basis of race, ethnicity, religion, national origin, citizenship, marital or family status, disability, sexual orientation, gender identity or expression, pregnancy or caregiver status, veteran status, or any other legally protected status. We will ensure that individuals with disabilities are provided reasonable accommodations to participate in the job application and interview process, to perform essential job functions, and to receive other benefits and privileges of employment.

#LI-Hybrid

Additional Information

All your information will be kept confidential according to EEO guidelines.