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 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.
Qualifications
- Strong communication, customer service, time management and organizational skills.
- Bachelor's in Computer Science, Information Systems, or related field.
- 4+ years building data integration with MS SQL, SSIS, or Spark; 2+ years with cloud based ETL platforms.
- Strong T SQL, Python/Scala for Spark, PowerShell/.NET scripting; working knowledge of MongoDB aggregation, SSAS tabular models, and Git CI/CD.
- Data Vault 2.0 certification a plus.
- Excellent problem solving, communication, and stakeholder management abilities.
Competencies
- Ensure Effective Communication - Listens carefully and attentively to others' opinions and ideas. Communicates information clearly, concisely, and professionally.
- Establish Trust - Follows through on commitments. Is honest and direct with others. Promotes a culture of respect for, commitment to, and compliance with Company values, beliefs, and standards. Ensures the protection of confidential information.
Boot Barn Benefits & Additional Compensation Opportunities
- Competitive hourly salary.
- Merchandise discount: 50% off of Exclusive Brands and 40% off of third-party brands.
- Paid Time Off plan for year-round Boot Barn Partners.**
- Medical, Dental, Vision and Life Insurance.**
- 401(k) plan with generous company matching.
- Flexible schedules and work/life balance.
- Opportunities for growth at every level - we are opening 50+ new stores each year.
**For eligible Boot Barn Partners PAY RANGE: $100,000.00 - $120,000.00* *compensation varies based on geography, skills, experience, and tenure 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.
- Standing, walking and squatting less than fifty percent of the work shift.
- Required to lift, move and carry up to 40 pounds.
- Ability to read, count and write to accurately complete all documentation and reports.
- Must be able to see, hear and speak in order to communicate with partners and customers.
- Specific vision abilities include close vision, distance vision, peripheral vision, depth perception and ability to adjust focus.
- Manual dexterity required using hands to finger; handle, feel and type; reach with hands and arms.
[ ] 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.
- The workspace is clean, orderly, properly lighted and ventilated with the proper safety compliance.
- Noise levels are considered moderate.
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-###-####, Option 4. California Privacy Notice