2,678 Data Workflows jobs in the United States

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 , Option 4.

California Privacy Notice

Who You Are

You are detail-oriented, analytical, and thrive on solving problems in real time. With at least 3 years of related IT or data integration experience, you’re comfortable monitoring transactions, troubleshooting issues, and keeping systems running smoothly. You enjoy collaborating across teams and have strong communication skills to explain technical issues in a clear, simple way.

What You Will Be Doing

As our Data Integration Specialist, you’ll ensure the accuracy and reliability of data integrations for purchase orders, sales orders, and other transactional systems. Your day-to-day will include:

• Monitoring inbound and outbound integrations to ensure accuracy and timeliness
• Identifying and resolving discrepancies or integration issues
• Performing initial troubleshooting and escalating when necessary
• Maintaining process documentation and adhering to workflows
• Supporting the business with data integrity across all interfaces
• Being available for off-hours response if urgent issues arise

What You Need

• Bachelor’s degree in IT, computer science, or related field (or equivalent experience)
• 3+ years of related experience in data integration or IT operations
• Strong problem-solving and analytical skills (level 1 troubleshooting)
• Familiarity with integration tools and processes (no coding required)
• Excellent communication and collaboration skills with technical and non-technical teams
• Ability to work onsite full-time in Mansfield, MA
• Flexibility to respond to after-hours emergencies if needed

Additional Information

Our client has over 90 years of experience in the beverage alcohol industry. We’re a family-owned company that values our employees and offers:

• 85k-100k annual salary
• Medical, dental, and 401(k) with profit sharing
• Tuition reimbursement
• A supportive, people-first culture

* Develop detailed technical specifications and designs for waterfall/XP projects / system enhancements.

* Provide application domain knowledge to the ADM team.

* Manage unstable applications / systems by helping to resolve incidents and issues.

* Support infrastructure first build with Solution Architects and Infrastructure Engineers.

* Review, guide, troubleshoot and resolve contentious issues escalated during implementation.

* Evaluate integration of SaaS / COTS packages to current environment.

* Develop operating procedures and user manuals for transition into routine operations.

* Enable building of knowledge databases for technology, solutions and domain areas.

* Work with architecture, application services, infrastructure, release management and other relevant stakeholders to enable a smooth deployment.

* Continuously work on capturing and transferring tacit knowledge to vendors and knowledge management systems.

Required Job Qualifications

*Bachelor Degree and 2 years Information Technology OR Technical Certification and/or College Courses and 4 year Information Technology experience OR 6 years Information Technology experience.

* Knowledge of application configuration

* Knowledge of Big Data Analytics - HAVeN / HADOOP/ Autonomy / Vertica

* Knowledge of Cloud computing / SaaS / IaaS / PaaS technologies

* Knowledge of Integration Technologies - Tibco/Informatica/CAS

* Knowledge of Mobile technologies - Phonegap / iOS / Android / Java / HTML5

* Knowledge of Scripting Languages - BASH / PERL / PYTHON / RUBY

* Service Oriented Architecture - SOAP / REST

* Web Technologies - HTML/CSS/Java/ASP.Net/PHP/Ruby/C#

* Rapid prototyping

* Requirements definition & management

* SDLC Methodology - Agile / Scrum / Iterative Development

* System Performance management

* Conceptual thinking

* Creative thinking

* Problem solving and analytical thinking

* Strong oral/written communication skills

Preferred Job Qualifications:

* Bachelor Degree in Computer Science or Information Technology related

* Ability to execute

Job Description:

• SAP Integration Developer with 10+ years experience
• Integration with SAP PI /PO, Webmethods
• Knowledge of EDI standards and SAP IDocs
• Experience with development and testing for SAP interfaces using WM Integration server, My web Methods Server
• Ability to design end to end solutions for multiple integrations
• Creating flow services, data mapping, Web services integrating
• Trading Partners using Trading Networks

• Design, develop, test, deploy, and maintain data integration processes between disparate systems.
• Understand and translate business needs into data models.
• Collaborate with team members and stakeholders to understand and address data needs.
• Manage and maintain knowledge management systems, ensuring they are up-to-date and accessible to all relevant stakeholders.
• Ensure compliance with data governance, data security, and privacy policies.
• Prepare data for prescriptive and predictive modeling.
• Implement data flow solutions for real-time and batch data processing.
• Create and maintain documentation related to data integration processes and workflows.
• Resolve data-related problems and ensure data quality and integrity.
• Improve and streamline processes regarding data flow and data quality to improve data accuracy, viability, and value.
• Conduct data analysis to identify trends, insights, and areas for improvement in knowledge management practices.

• 5-8 years of experience in data integration, data development, or similar experience.
• BS in Computer Science, Engineering, or relevant field
• Strong background in data analysis, with the ability to interpret and present data effectively.
• Proven experience in developing and implementing knowledge management strategies and systems.
• Proficiency in knowledge management tools and software.
• Strong understanding of data governance and security best practices.
• Proven work experience as a Data Integration Developer, Data Analysis, or similar role.
• Proficiency in SharePoint and Power BI.
• Knowledge of data warehousing, data modeling and data architecture.
• Proven track record of enhancing knowledge sharing, improving data accessibility, and fostering a culture of continuous learning.
• Excellent communication skills.
• Ability to translate complex concepts into clear, user-friendly content.
• Excellent interpersonal skills.
• Strong organizational and project management skills.
• Ability to work collaboratively with cross-functional teams.

• Masters (or higher) in Computer Science, Engineering, or relevant field
• Experience in a government agency/organization.
• Experience with change management and/or organizational development.
• Experience in the implementation and use of analytic tools to measure knowledge management system effectiveness.

• MUST have an active Secret Security Clearance or higher

• Experience working with large-scale data pipelines and cloud infrastructure ( cloud ETL tools like Glue etc., and Data Warehousing solutions like Redshift etc., )
• Knowledge of Deploying and maintaining cloud-based infrastructure for data workflows (e.g., AWS, GCP, Azure, RedShift)
• Strong technical expertise in Cloud applications, Data ingestion, and Data Lake architecture.
• 5 years of extensive hands-on experience in building ETL interfaces using DataStage version 11.3 and higher version to aggregate, cleanse and migrate data across enterprise-wide Big Data, and Data Warehousing systems using staged data processing techniques, patterns, and best practices.
• Combined 4 years of experience of advanced SQL and stored procedures (in DB2, SQL Server, and Oracle Database Platforms) with hands-on experience of designing solutions for optimal performance and handling other non-functional aspects of availability, reliability, and security of DATASTAGE ETL Platform

• Extensive hands-on experience in building ETL interfaces using DataStage version 11.7 to aggregate, cleanse and migrate data across enterprise-wide Big Data, and Data Warehousing systems using staged data processing techniques, patterns and best practices.
• Setting up interfaces from DataStage server to different platforms/tools like Hadoop Data Lake, SAS executions, MicroStrategy Command Manager etc.
• Experience working with large-scale data pipelines and cloud infrastructure ( cloud ETL tools like Glue etc., and Data Warehousing solutions like Redshift etc.)
• Strong technical expertise in Cloud applications, Data ingestion, and Data Lake architecture.
• Strong experience in full life cycle management of capturing, versioning and migrating various DataStage ETL metadata including data mapping and other data integration artifacts (such as schedulers, scripts, etc.) across environments using vendor platforms such as Data Stage, or other equivalent tools (including open source) by establishing standards, guidelines and best practices.
• Combined experience of advanced SQL and stored procedures (in DB2, SQL Server, and Oracle Database Platforms) with hands-on experience of designing solutions for optimal performance and handling other non-functional aspects of availability, reliability and security of DataStage ETL Platform.
• Proficiency on working with Unix and Linux servers, jobs scheduling, as well as script languages such as C, shell script (sh), AWK, and sed.
• Experience with both normalized and dimensional data models, hands-on knowledge of other data integration techniques such as database replication, change data capture (CDC) etc. and familiarity of SOA and ESB technologies and patterns.
• Working knowledge of DataStage Administration and best practices is highly recommended.
• Technical knowledge in predictive analytics architecture and in development and deployment of predictive models is a plus.

• Strong analytical skills with the ability to analyze information identify and formulate solutions to problems. Provides more in-depth analysis with a high-level view of goals and end deliverables.
• Over 5 years of proven work experience in DataStage, with version 11.0 or above, including over two years of DataStage version 11.7 is a must.
• Over 3 years of proven work experience on scripting languages such as Perl, Shell, and Linux/Unix servers, files structure, and scheduling.
• Complete work within a reasonable time frame under the supervision of a manager or team lead.
• Plan and manage all aspects of the support function.
• Extensive knowledge of and proven experience with data processing systems, and methods of developing, testing and moving solutions to implementation.
• Strong knowledge in project management practices and ability to document processes and procedures as needed.
• Work collaboratively with other support team members and independently on assigned tasks and deliverables with minimum supervision
• Communicate effectively with users at all levels, from data entry technicians up to senior management, verbally and in writing.
• Self-motivated, working closely and actively communicating with person to accomplish time critical tasks and deliverables
• Ask questions and share information gained with other support team members, recording and documenting this knowledge
• Elicit and gather user requirements and/or problem description information, and record this information accurately
• Listen carefully and act upon user requirements
• Convey and explain complex problems and solutions in an understandable language to both technical and non-technical persons
• Present technical solutions to management and decision makers
• Follow the lead of others on assigned projects as well as take the lead when deemed appropriate
• Think creatively and critically, analyzing complex problems, weighing multiple solutions, and carefully selecting solutions appropriate to the business needs, project scope, and available resources
• Take responsibility for the integrity of the solution

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• The workspace is clean, orderly, properly lighted and ventilated with the proper safety compliance.
• Noise levels are considered moderate.