Job Description:
Provide end-to-end reporting-solutions across every area of TVSSCS. Support business move from IBM Cognos to Power BI reporting.
Main Duties & Responsibilities:
- Interpret business-processes and requirements in liaison with internal / external customers.
- Plan and design accurate data-output to fulfil /exceed the customer’s need.
- Extract and model data, acquired from a variety of tables and/or sources.
- Cleanse data via use of rectification formulae, outlier removal, deduplication, format adjustment and data-type conversion etc. (occasionally manually).
- Transform data through use of derivation, splitting, joining and summarization etc. (occasionally manually)
- Test, debug and refine data produced, in conjunction with customer.
- Author and present data in an efficient, flexible and “future-proofed” format.
- Document all steps of report production from inception to after-care.
- Synergise with the IT department to maintain & develop an ever-increasingly efficient, robust and effective BI infrastructure.
- Maintain /trouble-shoot existing business Reports and Dashboards.
- Produce Excel-based data analysis / manipulation / summarization where required.
- Provide one to one / group-training to others around the business, should speciality training be required.
- Monitor and maintain the output schedules for automatically distributed reports.
- Author and update VBA Macros.
- Own and take ‘point’ for the reporting element of potential projects or initiatives.
- Engage with “emerging technologies” and feed them back, to further develop / enable the immediate team.
Knowledge, Skills, Qualifications and Experience:
- Proficient with Microsoft Power BI
- Experience with alternative BI systems (advantageous)
- Able to conduct ETL process in both reporting-software and Excel
- Read, if not write coding syntax (e.g. Excel formulae, VBA, SQL)
- Familiar with data warehousing and data modelling
- Advanced Excel
- Minimum one year in report production / analysis
- Background in a Supply-Chain environment (advantageous)
In return for your hard work, we offer excellent career progression opportunities and a professional environment where you can acquire, use, and continue developing your skills.
Your package will include:
* Competitive Salary and pension scheme with life assurance
* 25 Days Holiday (plus 8 statutory Bank Holidays)
* Holiday buy-back scheme (5 additional days available)
* Employee Assistance Programme supporting wellness with immediate access to:
1. GP consultation and second opinions
2. Mental health support
3. Financial and Legal support
4. Wellbeing and healthy living support
* Employee referral scheme with financial reward
* Cycle to work scheme
* Professional Membership and Study Sponsorship
* Pass scheme (£100 to undertake training of your choice)
At TVS SCS we encourage and support our employees to realise their potential. They are empowered to take initiative and achieve high impact results that really make a difference to our business and our customers.
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.
If you require any adjustments to allow you take a full and active part in the selection process, please notify us as part of your application. Please note TVS Supply Chain Solutions is an Equal Opportunities Employer.
TVS have signed the Armed Forces covenant and are a forces friendly employer