Backend 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

The Backend Integrations Engineer helps design, build, and maintain pipelines and platforms that power our data-driven decisions across the enterprise. This role will work across cloud platforms, digital systems, and analytics tools to ensure our data is reliable, scalable, and ready for everything from business reporting to advanced AI applications.

At Build-A-Bear, our data fuels creativity, efficiency, and innovation, connecting millions of guests to memorable experiences. The Backend Integrations Engineer will help build the foundation that powers these experiences.

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.

REQUIRED 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, etc.)
• 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 PI, Tableau, or Looker
• Excellent communication and critical thinking skills, with the ability to translate technical concepts for business partners

PREFERRED QUALIFICATIONS:

• Experience with Microsoft Dynamics 365, Salesforce, or similar enterprise data sources
• Understanding of data governance, lineage, and master data management frameworks
• Exposure to DevOps principles, CI/CD pipelines, and version control
• Familiarity with Agile or Scrum methodologies
• Microsoft Certified: Azure Data Engineer Associate or similar certification

BEHAVIORAL TRAITS FOR SUCCESS:

• Enjoys being recognized for the quality of their work
• Willingness to work within established standards, guidelines, and procedures
• Develops strong job knowledge and competency
• Strong commitment to tasks being completed correctly and on time
• Thrives in a structured environment
• Happy accomplishing work as an individual
• Can work harmoniously with others
• Communication is factual, polite, and professional

WORKING ENVIRONMENT:

• Typical office environment with climate control and sufficient lighting, ergonomic desk/chairs

YOUR PERFORMANCE WILL BE MEASURED ON:

Your performance will be measured by your ability to achieve annual department objectives and corporate goals which include but are not limited to the following.

• Decision-making, judgment, and execution
• System reliability
• Data throughput and performance metrics
• Reduction of data defects
• Accuracy and efficiency
• Compliance adherence
• Data integrity
• Audit readiness
• Stakeholder Feedback

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.