JUNIOR PORTFOLIO INSIGHTS ANALYST

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

Job Reference: IDC00814