Integration & Data Leader

Attain Partners is an innovative consulting firm dedicated to disrupting the status quo to change the world and improve the lives of those we touch. From strategy to technology and everywhere in between, our experts use their unique skills to advance the important missions of education, nonprofit, healthcare, and state and local government clients.  

People are at the center of all we do, and that’s why we empower career growth, provide industry-leading benefits packages, encourage a flexible work environment, and foster a culture of inclusion to support the needs of our team. We share a collective passion for our mission and our people. Guided by our seven core values, The Attain Way, our vision is the foundation of our culture—to be and attain the best. 

Job Description

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.

Job Responsibilities

• Data Migration & Integration Leadership
  • 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.
• Requirements & Stakeholder Collaboration
  • 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.
• Integration Architecture & Delivery
  • 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.
• Data Quality & Governance Alignment
  • 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.
• Modern Integration Enablement
  • 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.

Required Skills

• 7+ years of experience in data integration, ETL development, or enterprise data migration.
• Strong experience with SQL and SSIS for building and man