Company Description
Balsam Brands is a global, eCommerce retailer with roots in seasonal, Christmas, and home décor. We are thrilled to extend our reach into Mexico City, bringing the magic of the holidays to a vibrant new location. Your role will be pivotal in shaping the future and trajectory of our company right here in Mexico City!
Why Balsam Brands? At Balsam Brands, we're not just a company. Our people-first approach means that you're not just an employee; you're a valued member of a community that values relationship building, authenticity, and doing the right thing. We've been sharing joy across the globe, with growing teams in Boise, ID, Redwood City, CA, Dublin, IE, and Manila, PH. Now, we're excited to welcome talent from the heart of Mexico City, MX!
Our Mission: Create Joy Together. Join us in empowering our team and partners to love what they do. At Balsam Brands, we're about more than just the products we sell; we're about creating experiences that inspire meaningful moments with family and friends. Your work will contribute to our larger mission of giving back to our families and communities in impactful ways.
When you join Balsam Brands in Mexico City, you're not just joining a company; you're joining a culture of caring and interesting people doing challenging work to grow together to delight our customers. Together, we're building a workplace where everyone feels welcome, supported, and encouraged to bring their best selves to work every day.
Ready to be a part of the joy? Explore more about the Data Architect role below and apply today!
Job Description
As Data Architect, you will be responsible for designing and developing robust and scalable data warehousing solutions. The Data Architect 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 Architect must follow standards and implement best practices while writing code and providing 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 Senior Manager, Data Engineering and has been categorized as a teleworker position. Teleworkers do not have a permanent corporate office workplace and, instead, work from home. It is required for teleworkers to reside in the metropolitan Mexico City area, as we will require attendance for occasional in-person events. 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:
Design and implement robust, scalable, and high-performance data solutions using Snowflake
Lead the migration of existing data platforms to Snowflake, ensuring minimal disruption to business operations
Manage the full lifecycle of data within Snowflake, from ingestion and storage to analytics and reporting
Conduct performance tuning and troubleshooting of the Snowflake environment to ensure optimal efficiency
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:
8+ years of professional experience in the data engineering field
Hands-on polyglot programming expertise
Extensive experience in designing, developing Snowflake Cloud Data Platform
Proficiency in Multi cloud platform like Azure, AWS and/or GCP
Experience in Azure Data Factory (ADF) or equivalent ETL tool
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 workflows
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
Location and Travel: At Balsam Brands, we believe that time spent together, in-person, collaborating and building relationships is important. To be considered for this role, candidates must live within the metropolitan Mexico City area in order to attend team meetings, offsites, or learning and development opportunities. Please only apply if you are able to live and work full-time within the metropolitan Mexico City area.
Notes: This is a full-time (40 hours/week), indefinite position with benefits. Candidates must be Mexican nationals to be eligible for this position; this screening question will be asked during the application process. 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.
Benefits Offered:
Competitive compensation; salary is reviewed yearly and may be adjusted as part of the normal compensation review process
Career development and growth opportunities; access to online learning solutions and annual stipend for continuous learning
Fully remote work and flexible schedule
Collaborate in a multicultural environment; learn and share best practices around the globe
Government mandated benefits (IMSS, INFONAVIT, SAR, 50% vacation premium)
Healthcare coverage provided for the employee and dependents
Life insurance provided for the employee
Monthly grocery coupons
Monthly non-taxable amount for the electricity and internet services
20 days Christmas bonus
Paid Time Off: Official Mexican holidays and 12 vacation days (increases with years of service), plus additional wellness days available at start of employment
Additional Information
All your information will be kept confidential according to EEO guidelines.