Job Description
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.
As Data Engineer, you will be responsible for designing and developing robust and scalable data warehousing solutions. The Data Engineer will be responsible for building data solutions based on the business requirements. Data solutions may involve retrieval, transformation, storage, and delivery of the data. The Data Engineer must follow standards and implement best practices while writing code and provide production support for the enterprise data warehouse. Our ideal candidate is a skillful data wrangler who enjoys building data solutions from the ground up and optimizing their performance.
This full-time position reports to the Manager of Data Engineering and will work remote in Mexico City. To ensure sufficient overlap with functional and cross-functional team members globally, some flexibility with this role's regular work schedule will be required. Most of our teams have overlap with early morning and/or early evening PST. Specific scheduling needs for this role will be discussed in the initial interview.
What you’ll do:
- Be accountable for building and maintaining the data infrastructure for the organization
- Collaborate with systems analysts and cross functional partners to understand data requirements
- Champion data warehouse, create denormalized data foundation layer and normalized data marts
- Define strategies to capture all data sources and impact of business process changes on data coming from those sources
- Work on all aspects of the data warehouse/BI environment including architecture, design, development, automation, caching and performance tuning
- Build required infrastructure for optimal extraction, transformation and loading of data from various data sources on Cloud leveraging SQL, data cloud platforms like Snowflake
- Identifying, designing and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
- Working with stakeholders including the Executive, Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues
- Continually explore new technologies like Big Data, Artificial Intelligence, Generative AI, Machine Learning, and Predictive Data Modeling
What you bring to the table:
- Must be fluent in English, both written and verbal
- 5+ years of professional experience in the data engineering field
- Hands-on polyglot programming expertise
- Proficiency in Multi cloud platform like Azure, AWS and/or GCP
- Experience in Azure Data Factory (ADF) or equivalent ETL tool
- Extensive experience in designing, developing Snowflake Cloud Data Platform
- Proficiency in designing and implementing data pipelines using diverse data sources including databases, APIs, external data providers, and streaming sources
- Demonstrated history of designing efficient data models using Medallion Architecture
- Deep understanding and experience with relational (SQL Server, Oracle, Postgres and MySQL) and NoSQL databases
- Experience building and supporting REST APIs for both inbound and outbound data workflow
- Proficiency and solid grasp of distributed system concepts to design scalable and fault tolerant data architectures
- Excellent critical thinking to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions
- Excellent analytic skills associated with working on structured and unstructured datasets.
- Ability to build processes that support data transformation, workload management, data structures, dependency and metadata
- Ability to build and optimize data sets, ‘big data’ data pipelines and architectures
- Ability to understand and tell the story embedded in the data at the core of our business
- Ability to communicate with non-technical audience from a variety of business functions
- Strong knowledge of coding standards, best practices and data governance
Notes: This is a full-time, permanent position with benefits. Velocity Global is the Employer of Record for Balsam Brands' Mexico City location, and you will be employed and provided benefits under their payroll. Balsam Brands has partnered with Velocity Global to act as your Employer of Record to ensure your employment will comply with all local laws and regulations and you will receive an exceptional employment experience.
Qualifications
See more jobs at Balsam Brands
Apply for this job