Posted 1d ago

Application Integration Specialist

@ Arthur J. Gallagher & Co.
Rolling Meadows, Illinois, United States
$88k-$171k/yrHybridFull Time
Responsibilities:Design integrations, Develop integrations, Coordinate with teams
Requirements Summary:5+ years ETL/integration tools (Adeptia, Axway, SSIS) and 3+ years data modeling; financial acumen; SDLC experience; Bachelor's degree; scripting (PowerShell, Java, XML); encryption; API design/consumption (REST/SOAP).
Technical Tools Mentioned:Adeptia, Axway, SSIS, ETL, RDBMS, Programming, PowerShell, Java, XML, REST, SOAP, PGP
Save
Mark Applied
Hide Job
Report & Hide
Job Description
Introduction Welcome to Gallagher - a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing what’s right. We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive. At Gallagher, you’ll find more than a job; you’ll find a culture built on trust, driven by collaboration, and sustained by the belief that we’re better together. Whether you join us in a client-facing role or as part of our brokerage division, our benefits and HR consulting division, or our corporate team, you’ll have the opportunity to grow your career, make an impact, and be part of something bigger. Experience a workplace where you’re encouraged to be yourself, supported to succeed, and inspired to keep learning. That’s what it means to live The Gallagher Way. Overview The Senior Application Integration Specialist is responsible for the design, development, implementation and support of integrations. The role is equal parts of technical analysis as well as Project Management. The Senior Application Integration Specialist is responsible for ensuring the accurate documentation of requirements, design, QA and maintenance processes. This role will liaise with Corporate HRIS, GTS Business Intelligence and downstream stakeholders. How you'll make an impact Drive requirements and build complete and accurate requirements/design documents that capture complete scope and details of every integration being built. Design and develop integrations on the Adeptia platform. Coordinate with GTS BI, Financial Applications and Oracle HR teams around data management including schemas, failure conditions, reconciliation, test data set up, etc. Troubleshoot issues helping to drive root-cause analysis and permanent resolution. Provide direction and coordination for development, and support teams, including globally located resources. Understand the layout and working of existing integrations that send and receive data between Oracle, Concur, JDE and other systems. Monitor integrations and work with infrastructure teams to resolve issues as needed Develop and maintain application documentation. Review and co-develop appropriate test plans to support release of new integrations About You Required: Minimum of 5 years of technical experience with building integrations on Adeptia, Axway, SSIS or similar ETL tool and interest in being able to transfer those skills into the Adeptia platform to build integrations. Minimum of 3 years of hands-on relational, dimensional, and/or analytic modeling experience (using RDBMS, dimensional, and ETL and data ingestion protocols). Financial acumen (working knowledge) and awareness of key accounting, financial management and analysis processes. Working "hands-on" knowledge of Software Development Life Cycle and project management methodologies. Bachelor's Degree in Business, Information Technology, Engineering, related field or equivalent experience. Experience with scripting tools such as Power Shell and language elements for scripting such as Java and XML. Experience with file and transfer protocol encryption (PGP, Cryptography, sign, armoring) Desired: Experience designing and consuming API’s (REST, SOAP) with knowledge of various authentication schemes Experience with Large Enterprise Systems such as J.D.Edwards Work Traits Ability to collaborate effectively with business and technology personnel at many levels Excellent communication skills Excellent organization skills Strong attention to detail Demonstrated ability to prioritize and manage multiple tasks simultaneously Ability to work at a fast pace and cope with conflicting deadlines Proven ability to deliver excellent customer service Good analytical and problem solving skills Dependable, hardworking, professional, self-starter, able to work well with cross functional teams #LI-NP1 Compensation and benefits We offer a competitive and comprehensive compensation package. The base salary range represents the anticipated low end and high end of the range for this position. The actual compensation will be influenced by a wide range of factors including, but not limited to previous experience, education, pay market/geography, complexity or scope, specialized skill set, lines of business/practice area, supply/demand, and scheduled hours. On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits. Below are the minimum core benefits you’ll get, depending on your job level these benefits may improve: Medical/dental/vision plans, which start from day one! Life and accident insurance 401(K) and Roth options Tax-advantaged accounts (HSA, FSA) Educational expense reimbursement Paid parental leave Other benefits include: Digital mental health services (Talkspace) Flexible work hours (availability varies by office and job function) Training programs Gallagher Thrive program – elevating your health through challenges, workshops and digital fitness programs for your overall wellbeing Charitable matching gift program And more... **The benefits summary above applies to fulltime positions. If you are not applying for a fulltime position, details about benefits will be provided during the selection process. We value inclusion and diversity Click Here to review our U.S. Eligibility Requirements Inclusion and diversity (I&D) is a core part of our business, and it’s embedded into the fabric of our organization. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work. Gallagher embraces our employees’ diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest. Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers based on race, color, religion, creed, gender (including pregnancy status), sexual orientation, gender identity (which includes transgender and other gender non-conforming individuals), gender expression, hair expression, marital status, parental status, age, national origin, ancestry, disability, medical condition, genetic information, veteran or military status, citizenship status, or any other characteristic protected (herein referred to as “protected characteristics”) by applicable federal, state, or local laws. Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified person with a disability, unless the accommodation would impose an undue hardship on the operation of our business.