Integration & Data Leader

Attain Partners

18h

About The Position

Attain Partners is seeking an Integration & Data Leader responsible for designing, leading, and executing enterprise data integration and migration initiatives across client environments. This role focuses on SQL and SSIS based data movement, enterprise system integrations, and ensuring data accuracy, completeness, and alignment with business requirements during complex system transformations. The Integration & Data Leader partners closely with business stakeholders, architects, and technical teams to define integration requirements, map data across systems, and ensure high-quality data movement between platforms. This role also plays a critical part in helping organizations modernize their integration capabilities by evolving from traditional ETL-based architectures toward modern iPaaS platforms such as the Boomi Platform and other cloud integration tools.

Requirements

• 7+ years of experience in data integration, ETL development, or enterprise data migration.
• Strong experience with SQL and SSIS for building and managing data pipelines.
• Proven ability to lead complex data migration initiatives across enterprise systems.
• Experience defining source-to-target mappings and data transformation rules.
• Strong understanding of data quality practices, validation, and reconciliation techniques.
• Ability to collaborate effectively with both business and technical stakeholders.
• Strong documentation and communication skills for technical and functional audiences.

Nice To Haves

• Experience with modern integration platforms (iPaaS) such as the Boomi Platform, MuleSoft, or similar tools.
• Experience integrating with enterprise systems such as ERP, CRM, HRIS, and data warehouse platforms.
• Consulting or professional services experience leading data integration workstreams.
• Exposure to cloud data platforms, APIs, and modern integration architectures.
• Experience in Higher Education Software

Responsibilities

• Lead the migration and integration of enterprise data across systems using SQL, SSIS, and related data movement technologies.
• Design and oversee data integration processes that support enterprise system interoperability.
• Ensure data migrations are delivered with high levels of accuracy, completeness, and validation controls.
• Coordinate the end-to-end lifecycle of data integrations including discovery, source-to-target mapping, build, testing, and deployment.
• Partner with business and technical stakeholders to gather integration requirements and understand system dependencies.
• Define data attributes, transformation rules, and mapping logic necessary for successful integration.
• Identify data quality risks and remediation strategies prior to integration or migration activities.
• Facilitate integration discovery workshops and architecture discussions with client teams.
• Design scalable integration solutions leveraging SQL, SSIS, and enterprise integration patterns.
• Oversee the development and execution of data pipelines, transformation logic, and integration workflows.
• Ensure integrations align with enterprise architecture standards and system interoperability requirements.
• Establish and maintain documentation including source-to-target mappings, integration specifications, and technical runbooks.
• Identify and address data quality considerations during migration and integration processes.
• Work with data governance teams to ensure integrations follow data standards and stewardship practices.
• Implement validation and reconciliation processes to ensure data integrity across systems.
• Continuously expand technical capabilities by learning and adopting modern integration technologies and iPaaS platforms.
• Support the organization’s transition from traditional ETL approaches toward cloud-based integration architectures.
• Contribute to the development of modern integration frameworks and reusable patterns.

Benefits

• Competitive health, dental, and vision coverage, HSA and FSA accounts, life and disability insurance, fertility and family planning benefits, and employee assistance and discount programs
• 11 paid federal holidays and flexible unlimited time off (UTO)
• Generous 401(k) matching with immediate vesting
• Flexible career paths – our career tracks provide advancement, mobility, and flexibility as you continue to grow with us
• A healthy environment where we value unique experiences, and care about everything that makes you, you.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed