Application Technical Analyst – Integration
Cumbernauld (Hybrid)
Join the WG&S Technical Applications & Integration team!
This is a great opportunity to join a dynamic team responsible for the company’s applications and integrations, working in an agile way across all areas of a fast-paced organisation.
These roles are in relation to the company’s global ERP system (IFS) and utilizing the latest Oracle technology as well as Microsoft SSIS for ETL purposes to support our ERP integrations.
The team have recently successfully completed a long-term project to implement IFS 10 and are currently transitioning to the company’s new Digital Acceleration Team.
This role is to strengthen the team in preparation for the next wave of work to come out of the Digital Acceleration program.
The Role
Develop and support WG&S ETL applications in line with business requirements to provide the company with the delivery of accurate and timely business information.
Responsibilities
- Deliver technical solutions to meet existing integration requirements with consideration towards future growth and consolidation of global information
- Adhere to industry best practice and development principles to deliver efficient integration of data
- Create and maintain technical documentation to reflect coding standards and business logic applied to ETL routines and batch schedules
- Assist business in testing with scenarios, test data and potential cross impacts and awareness of global data sets
- Deliver and support batch processes to extract, transform, and load required business data from multiple sources, ensuring compliance to overall design whilst meeting business requirements for data accuracy
- Work with and support application developers in design of data requirements with consideration towards existing data models and transfer routines
- Contribute towards overall integration strategy, evaluating and driving potentially new integration tools, working with vendors to assess their recommendations and offerings
Requirements
- Proven technical experience of ETL development in a varied data source environment
- Comprehensive hands-on experience of ERP integration in a global organisation
- Advanced skills in technologies such as MS SQL Server and MS SSIS
- Awareness of other integration platform tools such as Boomi
- Strong attention to detail, delivering documented designs and scheduling of data transfer routines
- Track record of delivering business benefit from ETL solutions
- Desirable:
- Microsoft MCSA/MSCE certified
- Specialised experience of delivering and transforming business data in a manufacturing or international business
- Experience in the concept and build of ETL to provide aligned and consolidated information to a global user base
What we can offer?
- We offer a competitive salary and benefits which are designed to promote our employees financial wellbeing. Employees are also eligible to participate in a bonus plan.
- Our employees enjoy a generous holiday entitlement and an opportunity to ‘buy’ or ‘sell’ some holiday entitlement.
- Private Healthcare and Doctor@Hand (remote GP service).
- Our employees can join a defined contribution pension plan. Employees contribute either 4% or 5% of salary, the company contributes 8% or 10% depending on the employee contribution. Employee contributions can be made through salary sacrifice.
- Our Employee Assistance Programme offers practical, impartial support on everyday matters ranging from medical, financial and legal to home and family issues.
- Our Life Assurance cover is a multiple of eight times your annual basic salary.
- Product allocation so that you can enjoy our fantastic portfolio of brands.
- Our Cycle to Work scheme allows you to hire a bike for an agreed length of time, and then snap it up for a fraction of its original value. All while making savings (at least 25%) and spreading the cost.
- Every employee has the opportunity to claim up to £1,000 per year for a charity or charities for which they have raised money, volunteered their time or personally donated.
- Learning resources to help you be your best self.