Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as a Data & Planning Analyst, using Excel and SharePoint to analyse and improve data practices.
- Company: TEKsystems is a leading tech services company, dedicated to innovation and excellence in IT solutions.
- Benefits: Enjoy flexible working options, professional development opportunities, and a vibrant team culture.
- Why this job: Be part of a dynamic team, influence data strategies, and make a real impact on projects.
- Qualifications: Advanced Excel skills and experience with data analysis and SharePoint are essential.
- Other info: Ideal for self-starters eager to shape data practices from the ground up.
The predicted salary is between 36000 - 60000 £ per year.
Data Planning Analyst
• Advanced Excel skills (including Power Query and complex formulas)
• Experience in consolidating complex data via collection templates
• Provide assistance to project/programme leads to complete planning templates and business cases
• SharePoint skills (forms/lists) preferred
• Understanding of financial budgeting and planning
• Tech & FI knowledge preferred
The Data Analyst will be responsible for helping to set up the new data practice within ITID. Specifically, they should use their experience to suggest new ideas and improvements for how the department uses and analyzes data related to incoming projects. They will also handle ad-hoc requests from senior stakeholders, requiring quick analysis and turnaround. The ideal candidate is a self-starter with strong MS Excel (including VLOOKUPs, pivot tables) and SharePoint (Lists/Forms) experience.
Ideally, the candidate will have experience setting up data practices from scratch and aligning their work with broader business objectives and strategic direction.
Skills
- Excel pivot tables
- Data analysis
- Schedule planning
- Excel analysis
- Forecasting
- Reporting
- Tableau
#J-18808-Ljbffr
Data & Planning Analyst at TEKsystems – Sheffield, England, United Kingdom employer: Dataleum
Contact Detail:
Dataleum Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data & Planning Analyst at TEKsystems – Sheffield, England, United Kingdom
✨Tip Number 1
Familiarise yourself with advanced Excel functions, especially VLOOKUPs and pivot tables. Practising these skills will not only boost your confidence but also demonstrate your capability to handle complex data analysis tasks during interviews.
✨Tip Number 2
Gain hands-on experience with SharePoint, particularly in creating forms and lists. This will help you stand out as a candidate who can effectively manage and share data within the team.
✨Tip Number 3
Brush up on your understanding of financial budgeting and planning. Being able to discuss how data analysis can impact financial decisions will show that you can align your work with broader business objectives.
✨Tip Number 4
Prepare to discuss any previous experiences where you've set up data practices or improved data analysis processes. Sharing specific examples will illustrate your proactive approach and problem-solving skills to potential employers.
We think you need these skills to ace Data & Planning Analyst at TEKsystems – Sheffield, England, United Kingdom
Some tips for your application 🫡
Highlight Relevant Skills: Make sure to emphasise your advanced Excel skills, particularly with Power Query and complex formulas. Mention any experience you have with pivot tables and VLOOKUPs, as these are crucial for the role.
Showcase Data Experience: Detail your experience in consolidating complex data and using collection templates. Provide examples of how you've assisted project leads in completing planning templates and business cases.
Demonstrate SharePoint Knowledge: If you have experience with SharePoint, be sure to include it in your application. Discuss any work you've done with forms and lists, as this is preferred for the position.
Align with Business Objectives: Illustrate how your previous work aligns with broader business objectives and strategic direction. This will show that you understand the importance of aligning data practices with company goals.
How to prepare for a job interview at Dataleum
✨Showcase Your Excel Expertise
Make sure to highlight your advanced Excel skills during the interview. Be prepared to discuss specific functions you've used, such as VLOOKUPs and pivot tables, and how they have helped you in previous roles.
✨Demonstrate Data Consolidation Experience
Discuss your experience with consolidating complex data using collection templates. Provide examples of how you've successfully managed data projects and the impact of your contributions on the overall planning process.
✨Familiarise Yourself with SharePoint
If you have experience with SharePoint, be ready to talk about it. Mention any specific forms or lists you've created and how they improved data management or collaboration within your team.
✨Understand Financial Planning Basics
Brush up on your knowledge of financial budgeting and planning. Be prepared to explain how your analytical skills can contribute to effective financial decision-making and align with the company's strategic goals.
