Data Integration Engineer

Data Integration Engineer

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 another's 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:

• Provide functional support for critical business applications and integrations, escalating technical issues to development teams as needed.
• Contribute to data-catalog enrichment, data-dictionary curation, and SLA reporting.
• Mentor developers on ETL best practices and Data Vault modeling.
• Demonstrates high level of quality work, attendance and appearance
• Adheres to all Company Policies & Procedures and Safety Regulations
• Adheres to local, state and federal laws
• Perform other duties as assigned in alignment with evolving business priorities.
• Understands and complies with all company rules and regulations
• No direct reports; may lead ad-hoc project teams or vendor resources during integration projects.