Business Analyst

Enhance your Career with TVS Supply Chain Solutions TVS operate as part of Team LEIDOS in the delivery of the LCST contract – a team of defence and logistics specialists, supporting a major transformation contract providing an end-to-end supply chain service delivering commodity and inventory improvements to the UK Ministry of Defence. We are recruiting a Business Analyst to assist the Business Intelligence team with running contractual reports, running ad‑hoc reports for the wider CSS pillars and administering the Data Warehouse server. This role will be the SME in data sources and platforms for the team. We work on a hybrid model, and this role will be required to work in the Bristol office 1 day per week. It is therefore essential that you can commute to Bristol on this basis. Job Responsibilities Provide technical support to the Business Intelligence team. Maintain and develop the data warehouse and associated scripts, queries and packages. Manage users and associated licences on Business Intelligence platforms and the cloud. Document processes owned by Business Intelligence Team. Maintain and develop AWS instances and ad hoc SSMS Reports. Maintain monthly PPIM report, weekly Aged Picks report, weekly Referrals report, extract Cognos reports and maintain and develop reports SSRS. Deputise for BI Team Lead during periods of leave and essential meetings concerning the Data Warehouse and MI cloud data platforms. Develop strategies for improving business efficiencies in Data Integrity, Testing and Reporting as part of our Continuous Improvement ethos. Contribute to continuous improvement by identifying root cause of issues and maintaining records of resolutions undertaken/recommendations to inform future work/best practice. Maintain, develop, document and improve reporting tools. Scheduled and ad hoc report writing for the Business Intelligence Team, CSS, and other stakeholders. Ensure contractual MI reporting obligations are met and supported. Work in a collaborative manner with the Customer, CSS, Leidos and other stakeholders. Maintain and develop reports in DB2 along with DB2 Workbench data maintenance. Manage DB2 export to SSIS and legacy system ingests. Import External Sources for SSIS. Train users on Business Intelligence platforms and reports. Assist with TL MI activities to drive customer satisfaction. Qualifications and Skills Advanced Excel skills AWS or other cloud experience Understanding of MOD systems and data Knowledge of cloud-based systems SQL script writing skills Analytical and problem-solving skills Good communicator with stakeholders and customers A degree in relevant technology field or computing is desirable but not essential. Benefits Pension scheme with up to 6% employer matched contributions Life assurance 25 days holiday + 8 statutory bank holidays (of which 5 can be taken flexibly throughout the year) Holiday buy-back scheme (5 additional days available) Established hybrid working structure Enhanced maternity and paternity leave Employee Assistance Programme providing: Virtual GP consultations and second opinions Mental health support and counselling Online physiotherapy Access to CONNECTPlus long-term health condition support Wellbeing and healthy living support Cycle to work scheme Professional Membership and Study Sponsorship Pass scheme (£100 per year to undertake training of your choice) Quarterly employee recognition awards Employee referral scheme with financial reward Benefits hub with employee retail discounts Discounted eye test vouchers Early finish Fridays Security Clearance Requirement Candidates must be eligible to undergo Baseline Personnel Security Standard (BPSS) clearance. This process includes verification of identity, right to work in the UK, employment history, and a basic criminal records check for unspent convictions. Please note that candidates must have resided in the UK for 3 years to meet BPSS eligibility requirements. Job Location Emersons Green TVS Supply Chain Solutions is an Equal Opportunities Employer. TVS have signed the Armed Forces covenant and are a forces friendly employer. #J-18808-Ljbffr