JUNIOR PORTFOLIO INSIGHTS ANALYST

EMEA3 Recruitment; Sandton; On-site; ZAR 420,000 - 660,000; Full time

Job summary

EMEA3 Recruitment in Sandton, South Africa, seeks a data analytics professional to transform data into actionable insights for CSG and IDC, identifying trends to support strategic decisions.

You will build dashboards on Power BI, work with SAP and Power Apps, and collaborate with IT to improve data quality while preparing reports for committees.

Qualifications

• Bachelor's Degree or equivalent with statistical and data analysis.
• Portfolio management / accounting / IT & technology development experience.
• 1-5 years relevant experience in data analysis or portfolio management.
• Knowledge of BI reporting, databases and data warehouses.
• Experience with CSG & PICSS internal processes.
• Demonstrated experience with tools, technology and best practices.

Responsibilities

• Identify data sources to perform analyses.
• Compile data models to perform analyses.
• Verifying the integrity of data to ensure completeness and accuracy.
• Non- complex concept design, building and maintain dashboard and provide applicable insights.
• Develop and implement dashboards, analysis (including predictive), standard reports and proactive notifications when set tolerance levels are breached.
• Work with IT teams to understand existing tools and data warehouses and to identify data quality improvements.

Skills

Excel

Power BI

Power Apps

Communication skills

Analytical skills

Education

Bachelor's Degree or Equivalent

Tools

SAP

SharePoint

Azure

Dynamics 365

Job description

Job Description

Proactively and systematically collect and transform data into information, knowledge and insights in professional reports formats (i.e. actionable visual displays, reports, insights & predictions) to assist CSG and IDC in making better fact-based decisions. Identifying relevant trends through analysis, interpreting and converting them into meaningful insights that highlight opportunities and challenges to improve the CSG business model & the Corporation’s strategic plans.

Qualification and Experience

• Bachelor's Degree or Equivalent with Statistical and Data Analysis.
• Portfolio Management and / or Accounting and / or IT & Technology development to drive business applications
• Formal Microsoft and / or similar related certifications will be an added advantage2-5 years relevant experience in data analysis or portfolio management.
• Knowledge of Business Intelligence reporting, working with databases and data warehouse environments, with accurate data and information. Experience will be preferred.
• Knowledge and experience in performing analytical assessments
• Knowledge and experience of CSG & PICSS (or similar) internal processes, systems, and procedures
• Demonstratable experience in working with appropriate tools, technology, methodologies, and best business practices.

Roles and Responsibilities

The main duties of this role will include, but will not be limited to: -

Analysis and Insights Generation

• Identify data sources to perform analyses
• Compile data models to perform analyses
• Verifying the integrity of data to ensure completeness and accuracy

Dashboard Building on Technology Platforms

• Non- complex concept design, building and maintain dashboard and provide applicable insights
• Develop and implement dashboards, analysis [including predictive], standard reports proactive notifications when set tolerance levels are breached
• Work with the IT teams to understand existing internal tools and data warehouses and to identify data quality and reliability improvements and to establish best practices.

CSG Performance Tracking

• Identify challenges in input reports and how to address the issues.
• Update and enhance input report to enable improved reporting

CSG (IDC) Technology Platforms and Automation

• Identify the data requirements from SAP and the transformation of data requirements.
• Limited Power BI, Power Apps & Forms Development
• Understanding of the IDC data environment
• Assist in the development of the automation tools required, provide feedback and make small edits

Collateral Management

• Have/Develop a basic understanding of the collateral process and be able to provide support on all enquiries to internal stakeholders

Prepare draft reports based on analysis performed for various committees

Present non-complex presentation/ reports

CSG and IDC Systems & Procedures and Control Environment

• Identify and propose improvements to the existing S&P

Stakeholders Data, Information Gathering and Reporting (including ad hoc)

• Compile data for shareholder (DTIC) or broader government and other external stakeholders.
• Develop the approach of compiling unstructured data.
• Assist in compiling and review data from surveys and other unstructured data sources
• Draw draft conclusions on datasets

Job Requirements

TECHNICAL COMPETENCIES

• MS Office proficiency (Advanced Excel and MS PowerPoint),
• Working in and developing reports in Microsoft Power BI and use of SAP platforms
• Proficiency in other Microsoft application suites and platforms like Power Apps, Forms, Sharepoint, Azure, Dynamics 365 will be preferred
• Financial and analytical skills
• Report writing and presentation skills
• Verbal and written communication skills

BEHAVIOURAL COMPETENCIES

• Credible by delivering excellent (quality) work.
• Reliability on delivery to timelines
• Service & excellence orientation
• Analytical and Investigative skills
• Interpersonal skills & managing relationships