Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead analysis projects and develop innovative solutions using advanced Excel skills.
- Company: Join HCLTech, a global leader in technology with a diverse workforce.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Other info: Be part of a dynamic team driving digital transformation across the globe.
- Why this job: Make an impact in various industries while honing your analytical skills.
- Qualifications: Deep Excel expertise, VBA coding skills, and experience with complex formulas.
The predicted salary is between 60000 - 80000 £ per year.
HCLTech is a global technology company, home to more than 220,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services.
Deep Excel expertise:
- VBA/Java Script
- Pricing Analysis domain – Very Important
- Proficient in writing VBA code from scratch
- Knowledge of the latest functions that have been added to Excel 365 (e.g. LAMBDA, LET, XMATCH)
- Experience writing and editing complicated Excel formulas (including Dynamic Array Formulas)
- Comfortable using Excel add-ins and integrating their functionality into workbooks
Lead Business Analyst employer: HCLTech
Contact Detail:
HCLTech Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Lead Business Analyst
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work at HCLTech or similar companies. A friendly chat can sometimes lead to insider info about job openings or even a referral.
✨Tip Number 2
Prepare for the interview by brushing up on your Excel skills. Make sure you can confidently demonstrate your VBA coding abilities and your knowledge of the latest Excel functions. Practice makes perfect!
✨Tip Number 3
Showcase your analytical skills during interviews. Be ready to discuss past projects where you used pricing analysis or complicated Excel formulas. Real-life examples will make you stand out!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Lead Business Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Lead Business Analyst role. Highlight your deep Excel expertise and any experience with VBA or Java Script. We want to see how your skills match what we're looking for!
Showcase Your Skills: When writing your application, don’t just list your skills—show us how you've used them in real-world scenarios. If you've tackled pricing analysis or complex Excel formulas, share those experiences with us!
Be Clear and Concise: Keep your application clear and to the point. Use bullet points where possible to make it easy for us to read through your qualifications. We appreciate a well-structured application that gets straight to the good stuff!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at HCLTech
✨Master Your Excel Skills
Make sure you brush up on your Excel expertise, especially with the latest functions in Excel 365 like LAMBDA and LET. Be prepared to demonstrate your ability to write VBA code from scratch and tackle complex formulas during the interview.
✨Know Your Pricing Analysis
Since pricing analysis is crucial for this role, take some time to review key concepts and methodologies. Be ready to discuss how you've applied these in past projects and how they can benefit HCLTech's clients.
✨Showcase Your Problem-Solving Skills
Prepare to share specific examples of how you've solved complex business problems using data analysis. Use the STAR method (Situation, Task, Action, Result) to structure your responses and highlight your analytical thinking.
✨Research HCLTech and Its Verticals
Familiarise yourself with HCLTech's services and the industries they serve. Understanding their client base will help you tailor your answers and show that you're genuinely interested in contributing to their success.