JUNIOR PORTFOLIO INSIGHTS ANALYST

TalentCru; Sandton; On-site; ZAR 420,000 - 600,000; Full time

Job summary

TalentCru is seeking a data analyst to collect, transform and report data into actionable insights for the CSG and IDC units. You will identify data sources and build dashboards to support fact-based decisions.

Responsibilities include developing analytics, producing predictive insights, maintaining Power BI reports, and collaborating with IT to improve data quality and automation. Proficiency in Excel, Power BI and SAP is preferred.

Qualifications

• Bachelor's Degree or Equivalent with Statistical and Data Analysis.
• 2-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 with SAP and Power BI (preferred).

Responsibilities

• 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: Develop and implement dashboards, analysis (including predictive), standard reports and proactive notifications when set tolerance levels are breached.
• 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.
• 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 for various committees; Present non-complex presentation/ reports.

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.

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.

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 SP
• 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

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