Junior Integration Analyst
Role details
Job location
Tech stack
Job description
In this exciting newly created role, you'll be supported by senior team members while gradually taking on more responsibility. Your work will include:
- Building strong working relationships with stakeholders who rely on integration solutions.
- Supporting the development and maintenance of integrations using SSIS, SQL, and ZappySys, working with flat files, APIs, and database connections.
- Helping develop integrations using technologies like Java, JavaScript, XML, XSLT, REST, SOAP, and JSON (with training and guidance).
- Assisting with EDI connections for suppliers and customers, and learning common EDI standards along the way.
- Using SQL to query and manipulate data for integration development and troubleshooting.
- Learning how to review database objects (tables, views, triggers, stored procedures) and spotting potential improvements.
- Supporting scheduled jobs, data integrity checks, and alerting through SQL Management Studio.
- Helping design data flows between systems, ensuring reliability, quality, and good error handling.
- Participating in end-to-end testing of integrations and the business processes they support.
- Working with the wider IT team to resolve integration issues and maintain operational stability.
- Helping hand over new interfaces to business teams, including documentation and knowledge sharing.
You'll gain exposure to real, meaningful work from the start, including projects such as:
- Supporting EDI implementations for customer transactions like orders, invoices, and advance shipping notices.
- Assisting in integrations between internal systems and third-party logistics providers.
- Enhancing and supporting integrations with Amazon APIs and related interfaces.
- Contributing to data flows between ERP, eCommerce, and customer-facing platforms.
Requirements
Do you have experience in XSLT?, Are you curious about how systems talk to each other? Do you enjoy solving problems, working with data, and learning new technical skills? If so, this could be the perfect next step in your IT career.
We're looking for a Junior Integration Specialist to join our IT Department and support the delivery of our Global Integration Roadmap. You'll work alongside experienced Integration Specialists and Analysts, helping to build, test, and maintain the connections that keep our systems running smoothly, both internally and with our external partners.
This is a fantastic opportunity to develop hands-on experience in integrations, data flows, APIs, and EDI, while working with tools such as SSIS, SQL, and ZappySys., You don't need to be an expert, enthusiasm and a genuine interest in integration work are what truly matter. But experience or awareness of any of the following is a plus:
- SQL (writing simple queries or pulling data for investigation)
- SSIS or other data integration tools
- APIs or data formats like JSON/XML
- A logical approach to problem-solving
- Good communication skills and a willingness to learn
Benefits & conditions
Pulled from the full job description
- Sick pay
- Free parking
- Company pension
- Paid volunteer time, This permanent, full time, hybrid working ( 3 days a week in the office) is based at our Letchworth Garden City Head office.
As well as an exciting opportunity and a competitive salary, what do we have offer?
- Hybrid working (minimum of 3 days a week on site)
- Starting holiday entitlement of 25 days, with the option to buy more
- Defined contribution pension scheme
- Life assurance from day one
- Occupational Sick Pay and onsite Occupational Health Service
- Confidential 24-hour life management and personal support service for you and your family
- Enhanced family-friendly benefits, including Maternity, Paternity, and Shared Parental Leave
- Free eye tests for all employees
- A paid day off each year for volunteering
- Free car parking at all our sites
- Long service awards
- Learning and Development support, regardless of your career stage
- Various social events, including the company Christmas party
- Retirement advice and support
