Data Integration Engineer (Irvine)

DATA INTEGRATION ENGINEER

REPORTS TO : DIRECTOR OF SOFTWARE DEVELOPMENT AND INTEGRATIONS

STATUS : EXEMPT

Summary

Boot Barn is where community comes first. We thrive on togetherness, collaboration, and belonging. We build each other up, listen intently, and implement out-of-the-box ideas. We celebrate new innovations, congratulate one anothers achievements, and most importantly support each other.

At Boot Barn, we work together to make a positive impact on the world around us, and by working collectively with encouragement, we consider ourselves Partners. With the values of the West guiding us, Boot Barn celebrates heritage, welcomes all, and values each unique Partner within our Boot Barn community.

Our vision is to offer everyone a piece of the American spirit one handshake at a time.

The Data Integration Engineer designs, builds, and operates batch and streaming pipelines that move data from MS SQL Server, MongoDB, legacy files, and third-party APIs into our Data Vault warehouse and machine-learning (ML) cluster, ensuring that data is accurate, timely, and analytics-ready. The role blends hands-on ETL / ELT development in SSIS, Spark, Runbooks, and Azure Data Factory with data-modeling expertise (hubs, links, satellites) to support scalable reporting, predictive models, and AI agents. Working closely with development team and cross-functional product teams.

Essential Duties and Responsibilities

• Design, develop, and deploy incremental and full load pipelines using SSIS, Spark, Runbooks and Azure Data Factory to ingest data into landing, raw, and curated layers of the Data Vault.
• Build CDC (change data capture) solutions to minimize latency for downstream reporting and ML features.
• Automate schema evolution and metadata population for hubs, links, and satellites.
• Implement validation rules, unit tests, and data quality frameworks to enforce referential integrity and conformance to business rules.
• Maintain a requirements traceability matrix and publish data lineage documentation Metadata Management / SSAS models.
• Partner with Business Analysts to translate user stories into technical interfaces and mapping specs.
• Provide regular knowledge transfer sessions and production support, serving as Tier 2 escalation for data integration incidents.
• Create CI / CD pipelines (Azure DevOps, Git) to version ETL code, infrastructure as code, and automated tests.
• Develop PowerShell / .NET utilities to orchestrate jobs, manage secrets, and push metrics to Grafana or Azure Monitor.
• Benchmark and tune Spark, SQL, and SSIS performance; recommend index strategies, partitioning, and cluster sizing strategies for cost / performance balance.
• Stay current with emerging integration patterns (e.g., event driven architectures, Delta Lake) and propose pilots for adoption.
• Demonstrates high level of quality work, attendance and appearance.
• Demonstrates high degree of professionalism in communication, attitude and teamwork with customers, peers and management.
• Adhere to all local, federal and state laws in addition to Company policies, procedures, and practices.
• Performs any other duties that may be assigned by management.

Additional Responsibilities

Qualifications

Competencies

Boot Barn Benefits & Additional Compensation Opportunities

PAY RANGE : $100,000.00 - $120,000.00

Physical Demands

In general, the following physical demands are representative of those that must be met by a Partner to successfully perform the essential functions of this job. Reasonable accommodations may be made to allow differently abled individuals to perform the essential functions of the job.

[ ] Sedentary : Limited activity, no lifting, limited walking

[ X ] Light : Office work, some lifting, bending, stooping or kneeling, walking

[ ] Moderate : Mostly standing, walking, bending, frequent lifting

[ ] Arduous : Heavy lifting, bending, crawling, climbing

Work Environment

In general, the following conditions of the work environment are representative of those that a Partner encounters while performing the essential functions of this job. Reasonable accommodations may be made to allow differently abled individuals to perform the essential functions of the job within the environment.

Boot Barn, Inc. reserves the right to make exceptions to modify or eliminate this document or its content. This document supersedes all previous policies, procedures or guidelines pertaining to this subject.

Our core value of community bands us together in supportive and inclusive ways to drive our collective success. Boot Barn provides equal employment opportunity to all applicants and employees without regard to race, color, religion, sex, sexual orientation, age, national or ethnic origin, veteran or military status, disability, as well as any other protected status under the law.

Americans with Disabilities Act (ADA) - Boot Barn will provide reasonable accommodations (such as a qualified sign language interpreter or other personal assistance) with the application process upon your request as required by applicable laws. If you have a disability and require assistance in this application process, please visit your nearest Boot Barn Store or Distribution Center or reach out to Human Resources at 1-949-453-4400, Option 4.

California Privacy Notice