Senior Data Integration Consultant

We're seeking a Senior Data Integration Consultant to lead one of the most strategic workstreams within a large-scale enterprise transformation.

You'll play a critical role in bringing together two complex enterprise data environments into a single, scalable future-state solution. Working closely with Data & Analytics leadership, you'll analyze existing data structures, define integration and migration strategies, identify risks, and drive technical decisions that shape the success of the overall program.

This role is ideal for someone who enjoys solving complex data challenges and can seamlessly move between hands-on analysis and high-level strategy.

What You'll Do

• Analyze, compare, and reconcile complex enterprise data models, data structures, and data mappings across multiple source systems.
• Design and define data integration, data migration, and system integration strategies that support future-state business objectives.
• Develop and validate data mapping, data transformation, and data reconciliation approaches to ensure accurate and reliable data movement.
• Partner with Data & Analytics leadership to prioritize work, sequence implementation activities, and establish an enterprise integration roadmap.
• Collaborate with business leaders, solution architects, developers, and engineering teams to translate business requirements into scalable technical solutions.
• Identify data quality, data governance, and integration risks early while recommending mitigation strategies.
• Support Master Data Management (MDM) principles, enterprise data standards, and data validation efforts throughout the integration lifecycle.
• Provide technical leadership on enterprise data architecture, ensuring solutions balance business needs, scalability, and long-term maintainability.

• 8+ years of experience in data integration, data migration, enterprise data architecture, data engineering, or related disciplines.
• Proven experience leading large-scale system integration, data consolidation, or enterprise transformation initiatives.
• Strong background in data modeling, data mapping, data transformation, data quality, and data governance.
• Experience designing integration solutions across multiple enterprise applications and platforms.
• Strong SQL skills with the ability to analyze and validate complex datasets.
• Experience working with enterprise integration and ETL technologies such as Azure Data Factory, Informatica, Talend, SSIS, Databricks, Snowflake, or similar platforms.
• Experience supporting Master Data Management (MDM) or enterprise data governance initiatives is highly desirable.
• Excellent communication skills with the ability to explain complex technical concepts to both technical and business stakeholders.
• Comfortable operating independently in fast-paced, highly visible enterprise programs.

Preferred Experience

• Large-scale enterprise transformation or digital transformation initiatives.
• Merger & acquisition (M&A) integrations or enterprise data migrations.
• Passenger Service Systems (PSS), Navitaire, or other reservation or transportation platforms are a plus, but not required.
• Consulting experience leading enterprise data strategy and integration efforts.

What Will Make You Successful

We're looking for someone who can confidently move between strategy and execution. Someone who enjoys digging into complex data relationships while also stepping back to design the broader integration approach.

The ideal candidate is naturally curious, highly analytical, and comfortable making recommendations in ambiguous situations. You'll be expected to influence technical teams, collaborate with executive leadership, simplify complex problems, and own critical integration decisions from start to finish.

Pulled from the full job description

• Continuing education credits
• Health insurance
• 401(k) matching
• Vision insurance
• Dental insurance
• Paid sick time
• Life insurance, Why You'll Want This Opportunity
• Lead one of the most critical workstreams within a major enterprise transformation.
• Partner directly with senior Data & Analytics leadership.
• Solve complex enterprise data integration challenges with lasting business impact.
• High visibility role with significant ownership and influence.
• Strong potential for contract extension.

Benefits + Perks

Comprehensive Benefit Plan

Hollstadt offers medical, dental, vision, life insurance, short-term disability, long-term disability, paid sick leave, and retirement benefits to eligible employees. With three different medical plans to choose from, you can enroll in the coverage you need from individual to family, or anywhere in between!

Remarketing Process

Hollstadt is based on retention and relationships. We get to know your strengths and career wishes throughout your assignment and then start remarket discussions 6-8 weeks prior to your end date. By being proactive, we are able to keep your down time between assignments as short as possible, unless you choose otherwise.

Professional Development

Hollstadt offers on-demand training through our consultant portal. Trainings give our consultants the continuing education they need to excel on their projects. Many of our courses apply towards continuing education credits and we have an entire training hub dedicated to upskilling in Artificial Intelligence (AI).

401k + Matching

One popular benefit is our 401(k) match on the first 4% of your contributions. Hollstadt wants to help you reach your long-term financial goals and understands that planning for your future is critical. Consultants also have access to support from a Financial Advisor.

Bonus Opportunities

We appreciate and reward loyalty. Join Hollstadt, stay for 5 years, and we'll give you a $5,000 Longevity Award bonus! Additionally, we know great talent knows other great talent. If you are on contract with Hollstadt and refer one of your connections who gets placed, we'll pay you $1,000!

Ongoing Support & Networking

We have made a significant investment in building a support program for our consultant team - so you never have to feel like you are going it alone. We also have a Consultant Coach program which acts like a 'work buddy' to provide a safe ear for questions or concerns at your client site.

Hollstadt Consulting is a management and technology consulting firm dedicated to placing professionals at engagements where they will excel. When you work with us, you'll work with a refreshingly real company led and staffed by seasoned experts who are also down-to-earth, good people. We're committed to treating you with respect and helping you achieve your career aspirations. Since 1990, Hollstadt has been a trusted partner to more than 150 domestic and global companies and has successfully completed over 3,000 projects. Our continued growth has created challenging and rewarding opportunities for accomplished IT and Business Consultants. Hollstadt Consulting is an equal opportunity employer including disability/veteran. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Hollstadt Consulting and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel at any time.