At a Glance
- Tasks: Join us as a Reporting Analyst to create impactful data solutions and support our transition to Power BI.
- Company: TVS SCS is a dynamic supply chain solutions provider focused on innovation and employee growth.
- Benefits: Enjoy competitive salary, 25 days holiday, wellness programs, and professional development opportunities.
- Why this job: Be part of a supportive culture where your skills can shine and make a real difference.
- Qualifications: Proficiency in Power BI, Excel, and basic coding; experience in report production is a plus.
- Other info: Candidates must have resided in the UK for 3 years for security clearance eligibility.
The predicted salary is between 28800 - 43200 £ per year.
Reporting Analyst
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:
- GP consultation and second opinions
- Mental health support
- Financial and Legal support
- 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.
Reporting Analyst employer: TVS Supply Chain Solutions UK & Europe
Contact Detail:
TVS Supply Chain Solutions UK & Europe Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Reporting Analyst
✨Tip Number 1
Familiarize yourself with Microsoft Power BI and its features, as this is a key requirement for the Reporting Analyst role. Consider taking online courses or tutorials to enhance your skills and demonstrate your commitment to mastering this tool.
✨Tip Number 2
Gain a solid understanding of ETL processes, especially in relation to reporting software and Excel. Being able to showcase your ability to extract, transform, and load data will set you apart from other candidates.
✨Tip Number 3
Highlight any experience you have in a Supply Chain environment, as this is advantageous for the role. If you don't have direct experience, consider how your previous roles may have involved similar processes or skills.
✨Tip Number 4
Prepare to discuss your experience with data cleansing and manipulation techniques during the interview. Be ready to provide examples of how you've used these skills in past projects to improve data quality and reporting outcomes.
We think you need these skills to ace Reporting Analyst
Some tips for your application 🫡
Understand the Role: Make sure to thoroughly read the job description for the Reporting Analyst position. Understand the key responsibilities and required skills, especially around Power BI, ETL processes, and data analysis.
Tailor Your CV: Customize your CV to highlight relevant experience in reporting, data analysis, and any familiarity with Microsoft Power BI or similar BI systems. Include specific examples of past projects that demonstrate your skills.
Craft a Strong Cover Letter: Write a cover letter that connects your background to the job requirements. Emphasize your proficiency in data modeling, cleansing, and transformation, and express your enthusiasm for contributing to the team at TVS SCS.
Highlight Relevant Experience: In your application, make sure to mention any experience you have in a supply chain environment, as well as your ability to work with VBA Macros and Excel. This will show that you meet the preferred qualifications.
How to prepare for a job interview at TVS Supply Chain Solutions UK & Europe
✨Showcase Your Power BI Skills
Since the role emphasizes proficiency in Microsoft Power BI, be prepared to discuss your experience with it. Bring examples of reports you've created and be ready to explain your thought process behind the design and data modeling.
✨Understand ETL Processes
The job requires conducting ETL processes. Brush up on your knowledge of ETL techniques and be ready to discuss how you've implemented them in past projects, especially in relation to reporting software and Excel.
✨Demonstrate Data Cleansing Techniques
Data cleansing is a key responsibility. Be prepared to talk about specific methods you've used for data rectification, outlier removal, and deduplication. Providing concrete examples will help illustrate your expertise.
✨Engage with Emerging Technologies
The company values innovation, so express your interest in emerging technologies related to BI. Share any experiences you have with new tools or methodologies that could enhance reporting solutions.