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 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.
Desired Skills
- 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
Additional Information
Attain Partners values your mental, emotional, and physical health and wellbeing. Our comprehensive benefits package starts on your first day of employment and includes benefits such as:
- 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.
Attain Partners is committed to fair and equitable compensation practices. The individual base salary for this position is unique to each candidate and will be commensurate with experience, education, and skills. In addition to base salary, this role is eligible for an annual discretionary bonus.
Interested in this position but the compensation isn’t quite right? Let us know your expectations, and we’ll see if we can make it happen based on your qualifications.
Attain Partners is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.
Applicants have rights under Federal Employment Laws. For more Information visit EEO, EEO Poster Supplement, Family and Medical Leave Act (FMLA), and Employee Polygraph Protection Act (EPPA).
If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.
Top Skills
Similar Jobs
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
