Senior Data Integration Engineer - Hybrid & Cloud

Build-A-Bear Workshop; St. Louis (MO); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Hybrid work schedule

Ergonomic office environment

Job summary

Build-A-Bear Workshop seeks a Backend Integrations Engineer to design, build, and maintain data pipelines powering enterprise decisions. This role spans cloud platforms, digital systems, and analytics tools to ensure reliable, scalable data for reporting and AI initiatives.

You will help build the foundation that powers guest experiences and data-driven decisions across the organization, collaborating to define data requirements and governance while staying current on analytics, AI, and

Qualifications

• 5+ years of experience in data engineering, data warehousing, or analytics platform development.
• Bachelor’s degree in computer science, information systems, data engineering, or related field.
• Expert knowledge of T-SQL and PLSQL.
• Intermediate knowledge of Python and PySpark.
• Intermediate knowledge of OOP principles and proficiency with one or more languages (such as C#, Java).
• Expert with cloud-based data ecosystems, ideally Microsoft Azure (Data Factory, Synapse, Databricks, or Data Lake).
• Skilled understanding of ETL/ELT design patterns, data modeling, and schema optimization.
• Proficient knowledge of API integrations, such as REST, SOAP.
• Basic knowledge of BI tools such as Power BI, Tableau, or Looker.

Responsibilities

• Design, build, and maintain scalable data pipelines and integrations across multiple enterprise systems.
• Develop and maintain data models, ETL/ELT workflows, integrations, and orchestration logic within cloud data environments and vendors.
• Collaborate to define data requirements and ensure alignment between business needs and technical solutions.
• Implement data quality validation, monitoring, and governance processes.
• Partner with IT Security and Privacy teams to enforce data access controls and compliance standards.
• Support development of reusable frameworks for data ingestion, transformation, and storage.
• Document technical designs, data dictionaries, and workflows for transparency and maintainability.
• Stay current on development best practices, tools, and emerging trends in analytics, AI, and automation.

Skills

T-SQL

PL/SQL

Python

PySpark

OOP (C#, Java)

Azure (Data Factory, Synapse, Databr

ETL/ELT design

Data modeling

REST API integrations

BI tools

Education

Bachelor’s degree in computer science, information systems, data engineering, or related field

Tools

Azure Data Factory

Azure Synapse

Azure Databricks

Data Lake

Job description

Build-A-Bear Workshop seeks a Backend Integrations Engineer to design, build, and maintain data pipelines powering enterprise decisions. This role spans cloud platforms, digital systems, and analytics tools to ensure reliable, scalable data for reporting and AI initiatives.

You will help build the foundation that powers guest experiences and data-driven decisions across the organization, collaborating to define data requirements and governance while staying current on analytics, AI, and