JUNIOR PORTFOLIO INSIGHTS ANALYST

SUMMARY:

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 meani...

POSITION INFO:

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