1,747 Etl Architect jobs in the United States

Role Overview:

The Solution Architect will be responsible for designing, overseeing, and ensuring the successful implementation of data integration pipelines and executive dashboards.

This role requires close collaboration with business stakeholders, project managers, developers, and QA teams to translate requirements into scalable architecture and actionable technical solutions.

Key Responsibilities:

• Define and own the overall solution architecture for dashboards, ETL pipelines, and integrations across tools such as Jira, Jama, TestRail, GitHub, and Excel.

• Lead requirements workshops with stakeholders to finalize KPIs, data sources, and dashboard layouts.

• Design role-based, secure, and scalable architecture aligned with enterprise standards and compliance needs.

• Guide development teams on building Power BI dashboards, data transformation scripts, and CI/CD pipelines.

• Ensure solution alignment with V&V governance process and compliance models (ISO/ASPICE).

• Oversee deployment strategy, training, and transition to client teams.

• Provide architectural oversight during iterative sprints, ensuring quality, performance, and stakeholder satisfaction.

• Collaborate with DevOps and QA teams to validate solution performance and reliability.

Required Skills & Experience:

• 10+ years in IT with at least 5 years as a Solution Architect in analytics, data integration, or dashboard projects.

• Strong expertise in Power BI, ETL/ELT design, and data modeling.

• Experience with GCP cloud services, IAM/AD integration, and CI/CD pipelines.

• Hands-on knowledge of APIs, data pipelines, and enterprise data platforms.

• Familiarity with V&V, QA, and compliance-focused dashboards in automotive or manufacturing domains.

• Proven ability to run workshops, translate business KPIs into technical designs, and deliver executive-ready solutions.

• Excellent communication and stakeholder management skills.

Nice to Have:

• Experience with Jira, Jama, TestRail, GitHub.

• Knowledge of automotive quality frameworks (ISO, ASPICE).

• Prior work on shift-left quality dashboards or similar initiatives.

• Strong knowledge of MuleSoft Anypoint platform, including Anypoint Studio IDE, Design Center, API Manager, and Runtime.
• Experience with API-led connectivity and microservices architecture.
• Experience with MuleSoft connectors for various data sources and systems.
• Experience with DataWeave scripting and RAML specifications.

• Experience with Kafka brokers, producers, and consumers.
• Knowledge of Kafka concepts such as topics, partitions, and offsets.
• Experience to read/write messages to kafka using any ETL tool like informatica/Hadoop.

• Experience with HDFS, MapReduce, and Hadoop ecosystems.
• Understanding data storage and processing techniques in Hadoop.

• Work with Informatica PowerCenter or other Informatica products for ETL (Extract, Transform, Load) processes and data integration.
• API-Driven Connectivity: Focus on building APIs that enable seamless data flow between systems, following API-led connectivity principles Drive value-delivery and continuously improve the product by effectively utilizing data such as feedback and metrics like quality, delivery rate, etc., to identify opportunities.

Client: Options Clearing Corporation

Location: Hybrid downtown Chicago

Interview Mode: Virtual 2 rounds

• Contingent Worker - RCR-956 TDM-6
• I. WORK TO BE PERFORMED:
  • Responsible for the design, development, implementation, and maintenance of new and existing Data Integration processes within the Strategic Data Platform and other data solutions implementations.
  • Design, develop, maintain, enhance, and monitor Data Integration processes sourcing data from various structured and semi-structured data sources, transforming as per provided business rules or data mappings, and loading into target databases/services including DB2, AWS S3, and Apache Iceberg.
  • Serve as a subject matter expert on multiple data integration projects, ensuring consistent design and efficient data processing.
  • Play a leading role in Build, Test, and Implementation phases of assigned projects, with a diverse development team spread across multiple locations.
  • Provide Level 2 and Level 3 technical support to mission-critical applications.
  • Perform process improvement and re-engineering with an understanding of technical data problems and solutions as they relate to the current and future business environment.
  • Analyze complex distributed production deployments and make recommendations to optimize performance.
  • Design and develop innovative data solutions for demanding business situations.
  • Develop and document Data Integration standards and procedures.
  • Design reusable and portable Data Integration components.
  • Transform flat delimited files into multiple formats, including Parquet, JSON, and Protobuf.
  • Play a supporting role in Build, Test, and Implementation phases of assigned projects, with a diverse development team spread across multiple locations.
  • Investigate production Data Integration issues and work to determine the root cause of problems.
  • Work with the DBA teams to fix performance issues as required.
  • Work with the QA team to address testing issues as they occur.
  • Work with the Data Quality/Data Governance team to ensure required data quality and data integrity standards are met.
  • Design reusable Data Integration components.
  • Participate in daily Scrum standups. Update task status in Jira.
  • Conduct Code reviews and incorporate suggested improvements/fixes.
  • Perform other duties as assigned.
• II. SKILL AND EXPERIENCE REQUIRED:
  • 3+ years in IT application development, with at least 2 years in Data Integration (ETL) Development, using tools such as DataStage, Python, SQL and Unix Shell Scripting.
  • Experienced practitioner with a proven track record of implementing mid-scale to large-scale Data Integration (ETL) solutions, performing data analysis and profiling, interacting with client management, and designing and architecting dynamic ETL solutions.
  • Working knowledge for Data Types and Databases including Relational, Dimensional, Vertical and No SQL databases.
  • Hands-on experience with data cleansing and data visualization and familiarity with Hadoop Ecosystem.
  • Experience with platforms such as Hive and Trino/Starburst.
  • Strong conceptual knowledge of file formats such as JSON, Parquet and Protobuf.
  • Capable of writing and optimizing SQL queries and stored procedures.
  • Exposure to AWS Services including but not limited S3, PostgreSQL, Apache Iceberg and Kafka.
  • Ideal candidate would have worked on a Scrum Team and familiar with using tools such as Jira and Git.
  • Experience developing containerized Data Integration solutions using Kubernetes, Rancher, and CI/CD pipelines using Harness, Jenkins and Artifactory is a plus.
  • Experience working with scheduling tools such as UC4, Control-M, or Autosys is a plus.
  • Experience working with Cloud ecosystems (AWS, Azure, GCP, AWS preferred) in multi-availability zone, multi-region deployments.
  • Experience in database performance optimization techniques, multidimensional database designs, and physical database implementations for databases including DB2 and Apache Iceberg is a plus.
  • Strong verbal/written communication skills.
  • Ability to interact with business users and to develop positive working relationships.
  • AWS Certified Solution Architect Associate Level is a plus.
  • Big data related certification is a plus.

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