At a Glance
- Tasks: Join HSBC's Strategy and Planning team as a Data Modeler, creating impactful data models and dashboards.
- Company: HSBC is a leading global bank focused on innovation and data-driven strategies.
- Benefits: Enjoy hybrid work options and the chance to collaborate with senior leadership.
- Why this job: Be part of high-impact initiatives that shape financial forecasting and risk analysis.
- Qualifications: 3-5 years in consulting or banking; strong skills in Excel, Power BI, and SQL required.
- Other info: In-person assessment in Sheffield; open to candidates willing to commute from nearby cities.
The predicted salary is between 36000 - 60000 £ per year.
We are hiring a Data Modeler to join HSBC’s Strategy and Planning team. This is a great opportunity for professionals with 3 to 5 years of experience in consulting, banking, or corporate strategy who want to be part of high-impact, data-driven initiatives and work directly with senior leadership.
Key Responsibilities:
- Develop and maintain data models for financial forecasting, risk analysis, and strategic planning
- Build dashboards and reports using Power BI, Power Query, and Excel VBA
- Collaborate with teams across finance, risk, and technology
- Present data-driven insights and recommendations to senior management
- Perform scenario modeling and ensure data consistency and governance
Candidate Requirements:
- 3 to 5 years of experience in a consulting, banking, or strategy-focused analytical role
- Strong communication and stakeholder management skills
- Technical skills: Advanced Excel (including VBA), Power BI, Power Query, SQL; Python is a plus
- Strategic thinker with strong problem-solving ability
- Willing to attend an in-person assessment in Sheffield on Wednesday
- Open to candidates based in or willing to commute to Sheffield, Manchester, Leeds, or Birmingham
Apply now to be considered for this exciting opportunity.
Data Modeler – Risk & Finance (Power BI, SQL, Excel VBA) employer: GIOS Technology Limited
Contact Detail:
GIOS Technology Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Modeler – Risk & Finance (Power BI, SQL, Excel VBA)
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as Power BI, SQL, and Excel VBA. Consider creating a small project or dashboard that showcases your skills using these tools, as this will give you practical experience to discuss during the assessment.
✨Tip Number 2
Research HSBC’s Strategy and Planning team and understand their recent projects or initiatives. This knowledge will help you tailor your discussions and demonstrate your genuine interest in the role and the company during the in-person assessment.
✨Tip Number 3
Prepare to showcase your communication and stakeholder management skills. Think of examples from your past experiences where you successfully collaborated with different teams or presented data-driven insights to senior management, as these are key aspects of the role.
✨Tip Number 4
Since the assessment is in-person, plan your journey to Sheffield in advance. Arriving early will not only reduce stress but also give you a chance to observe the environment and potentially network with other candidates or recruiters before the assessment begins.
We think you need these skills to ace Data Modeler – Risk & Finance (Power BI, SQL, Excel VBA)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience in data modelling, financial forecasting, and risk analysis. Use specific examples of projects where you've utilised Power BI, SQL, and Excel VBA.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and how your background aligns with HSBC’s Strategy and Planning team. Mention your problem-solving skills and ability to present data-driven insights.
Showcase Technical Skills: Clearly list your technical skills relevant to the job, such as advanced Excel (including VBA), Power BI, Power Query, and SQL. If you have experience with Python, be sure to include that as well.
Prepare for the Assessment Centre: Since the application involves an in-person assessment, prepare by practising your presentation skills. Be ready to discuss your previous work and how it relates to the responsibilities of the Data Modeler role.
How to prepare for a job interview at GIOS Technology Limited
✨Showcase Your Technical Skills
Make sure to highlight your proficiency in Power BI, SQL, and Excel VBA during the interview. Prepare examples of how you've used these tools in previous roles, especially in financial forecasting or risk analysis.
✨Prepare for Scenario Modelling Questions
Given the role's focus on scenario modelling, be ready to discuss your approach to creating data models. Think about specific scenarios you've worked on and how you ensured data consistency and governance.
✨Demonstrate Strong Communication Skills
As you'll be presenting insights to senior management, practice articulating complex data findings in a clear and concise manner. Use examples from your past experiences where you successfully communicated with stakeholders.
✨Research HSBC’s Strategy and Planning Team
Familiarise yourself with HSBC’s current initiatives and challenges in the finance sector. This will help you tailor your responses and show that you're genuinely interested in contributing to their team.