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, global exposure, and opportunities for professional growth.
- Other info: Dynamic work environment with a focus on innovation and collaboration.
- 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 in City of London employer: HCLTech
Contact Detail:
HCLTech Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Lead Business Analyst in City of London
✨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 seen by the right people. Plus, we love seeing candidates who take that extra step!
We think you need these skills to ace Lead Business Analyst in City of London
Some tips for your application 🫡
Show Off Your Excel Skills: Make sure to highlight your deep Excel expertise in your application. We want to see your proficiency in writing VBA code and using the latest Excel 365 functions, so don’t hold back on showcasing your skills!
Tailor Your Application: When applying, tailor your CV and cover letter to reflect the specific requirements of the Lead Business Analyst role. We love seeing how your experience aligns with our needs, especially in pricing analysis and complex Excel formulas.
Be Clear and Concise: Keep your application clear and to the point. We appreciate well-structured documents that make it easy for us to see your qualifications and experience without wading through unnecessary fluff.
Apply Through Our Website: Don’t forget to apply 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're up to speed with the latest Excel functions like LAMBDA and LET. Brush up on your VBA coding skills, as you'll likely be asked to demonstrate your ability to write code from scratch during the interview.
✨Know Your Pricing Analysis
Familiarise yourself with key concepts in pricing analysis. Be prepared to discuss how you've applied these concepts in previous roles, and think of examples where your analysis led to significant business decisions.
✨Showcase Your Problem-Solving Abilities
Prepare to tackle case studies or hypothetical scenarios that test your analytical thinking. Practice articulating your thought process clearly, as this will show your potential employer how you approach complex problems.
✨Research HCLTech
Understand HCLTech's core services and industries they operate in. Tailor your responses to reflect how your skills can contribute to their goals, especially in areas like digital transformation and AI.