Senior Backend Data Integrations Engineer

Build-A-Bear Workshop, Inc.; St. Louis (MO); On-site; USD 90,000 - 130,000; Full time

Job summary

Build-A-Bear Workshop, Inc. seeks a Backend Integrations Engineer to design, build, and maintain data pipelines powering enterprise analytics and AI-ready data. You will work across cloud platforms and analytics tools to ensure reliable, scalable data for reporting and advanced applications.

In this role you’ll help shape data models, ETL/ELT workflows, and integration logic while collaborating with IT Security to enforce access controls and compliance. Strong communication is essential.

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.
• Excellent communication and critical thinking skills, with the ability to translate technical concepts for business partners.

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

Data engineering experience (5+ years)

Python

PySpark

OOP principles

C#/Java or similar language

Azure data ecosystem (Data Factory, Sy

ETL/ELT design patterns

Data modeling and schema optimization

API integrations (REST, SOAP)

Power BI / Tableau / Looker

Effective communication

Critical thinking

Education

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

Tools

T-SQL

PL-SQL

Job description

Build-A-Bear Workshop, Inc. seeks a Backend Integrations Engineer to design, build, and maintain data pipelines powering enterprise analytics and AI-ready data. You will work across cloud platforms and analytics tools to ensure reliable, scalable data for reporting and advanced applications.

In this role you’ll help shape data models, ETL/ELT workflows, and integration logic while collaborating with IT Security to enforce access controls and compliance. Strong communication is essential.