About Company
First National Bank (FNB), a division of FirstRand Bank Limited, is one of South Africa’s ‘big four’ banks. With a legacy spanning over a century, FNB has grown to become a leading financial services provider, offering a comprehensive range of banking products and services to individuals, businesses, and corporates across Africa. Our commitment extends beyond banking; we are deeply invested in nurturing talent, fostering innovation, and contributing positively to the communities we serve. At FNB Mahikeng, we pride ourselves on being a cornerstone of financial stability and progress, driving economic growth and empowering our customers to achieve their financial aspirations. We believe in creating a dynamic and inclusive work environment where every individual has the opportunity to learn, grow, and make a meaningful impact. Join FNB and be part of a future-forward organization dedicated to excellence and making a real difference.
Advertisement
Job Description
Are you a highly motivated, detail-oriented individual with a passion for data and an exceptional grasp of Microsoft Excel? FNB Mahikeng is excited to offer a unique internship opportunity for a Data Analyst Intern. This role is perfect for a proactive student or recent graduate eager to kickstart their career in data analytics within the fast-paced financial services sector. As our Data Analyst Intern, you will play a crucial role in supporting our team by extracting, cleaning, transforming, and analysing various datasets. Your primary tools will be the advanced features of Microsoft Excel, where your proficiency will be essential in developing insightful reports, dashboards, and presentations that inform strategic decisions.
This internship is designed to provide hands-on experience in a real-world business environment. You will work closely with experienced analysts and business stakeholders, gaining valuable insights into how data drives business outcomes in a leading financial institution. Beyond technical skills, you will develop critical thinking, problem-solving abilities, and professional communication skills. We are looking for someone who is not just proficient in Excel, but who is also naturally curious, meticulous, and eager to learn the intricacies of data analysis in a corporate setting. If you’re ready to apply your analytical prowess and grow your career with a market leader, we encourage you to apply and become an integral part of our Mahikeng team.
Key Responsibilities
- Assist in the collection, cleaning, and validation of data from various sources.
- Perform data analysis using advanced Excel functions (e.g., PivotTables, VLOOKUP, HLOOKUP, Conditional Formatting, Data Validation, Power Query).
- Develop and maintain Excel-based dashboards and reports to visualize key performance indicators (KPIs) and trends.
- Prepare presentations summarizing analytical findings for internal stakeholders.
- Collaborate with team members to understand data requirements and reporting needs.
- Identify and communicate data anomalies or inconsistencies to senior analysts.
- Support ad-hoc data analysis requests and special projects as needed.
- Contribute to the documentation of data processes and reporting methodologies.
- Participate in team meetings and training sessions to enhance analytical skills.
Required Skills
- Advanced proficiency in Microsoft Excel (including PivotTables, VLOOKUP, HLOOKUP, Power Query, Macros/VBA is a plus).
- Strong analytical and problem-solving skills.
- Exceptional attention to detail and accuracy.
- Ability to work independently and as part of a team.
- Excellent verbal and written communication skills.
- Basic understanding of data analysis principles.
- Ability to manage multiple tasks and prioritize effectively.
Preferred Qualifications
- Currently pursuing or recently completed a degree/diploma in Business, Finance, Economics, Statistics, Information Technology, or a related field.
- Familiarity with other data visualization tools (e.g., Tableau, Power BI) is a bonus.
- Basic knowledge of SQL or other programming languages for data manipulation.
- Prior experience with data entry or data management in an academic or professional setting.
Perks & Benefits
- Hands-on experience in a leading financial institution.
- Mentorship from experienced data analysts and business leaders.
- Opportunities for professional development and skill enhancement.
- Exposure to diverse datasets and real-world business challenges.
- Networking opportunities within the FNB and FirstRand group.
- Potential for future career opportunities based on performance.
- A supportive and collaborative work environment.
- Stipend provided.
How to Apply
Interested candidates are encouraged to apply by clicking on the application link below. Please ensure your resume highlights your Excel proficiency and any relevant data analysis experience or academic projects. We look forward to reviewing your application!
Advertisement
