EXCITING CAREER OPPORTUNITY

. Position: Data Analytics Intern

. Department: Information Services and Operations

. Reports to: Data Analytics Specialist

SUMMARY

The primary duties of the data analytics Intern will be to work closely with Data Analytics Unit responsible for data analytics and preparation of reports. Partner with stakeholders across multiple departments to help us understand and accelerate our business reporting needs.

ESSENTIAL DUTIES

• Utilize strong oracle, SQL and MS Excel skills to provide high quality data analysis, report and support to stakeholders
• Prepare SQL scripts to directly query and analyze internal and external data
• Support preparation of analytic dashboards and KPI reports in BI tools.
• Maintain the strict confidentiality of all records and documents stored in the assigned systems and infrastructure.
• Provide technical advice and support in problem solving related to systems and applications.
• Be able to ensure data availability 24 x7 using non-disruptive administration tactics.
• Management of security aspects to the assigned systems and data integrity controls, related records and recovery control (ensuring all data is retrievable in an emergency)
• Execute other assignments as may be assigned from time to time by superiors.

Preparation of reports

• Analyze user data needs and determine needs resolved through automated repeatable process.
• Prepare transparent standard reports and analyze to support business needs
• Creating crystal reports and upload to front end solution for end users
• Editing current report based on product and user requirements
• Document business requirements to depict user needs with complimentary technical requirements
• Ensure high data quality through regular quality checks
• Decompose high-level business needs into functional needs by understanding problem and determining data needs.
• Extract, filter and aggregate data through logical queries and basic programming.
• Develop and create data layout like tables, charts, graphs, heat maps and process flow diagrams.
• Monthly data upload to BOT For Credit Reference
• Data upload to BOT for RTSIS
• Managing CRB client report disputes
• Digital data and reports
• Other report preparation as assigned by supervisors
• IFRS and FSDR extractions and reporting

Education and experience

• Degree in computer science, Information technology or a related field.
• Experience working with databases management such as PostgreSQL or SQL Server OR Oracle
• A comfortable hand on WPS or Python or R or Alterexy or any other programming language, this is just an additional skill
• Excellent Communication, Analytical and Presentation Skills
• Passionate about data and analyzing business needs

• Utilize strong oracle, SQL and MS Excel skills to provide high quality data analysis, report and support to stakeholders
• Prepare SQL scripts to directly query and analyze internal and external data
• Support preparation of analytic dashboards and KPI reports in BI tools.
• Maintain the strict confidentiality of all records and documents stored in the assigned systems and infrastructure.
• Provide technical advice and support in problem solving related to systems and applications.
• Be able to ensure data availability 24 x7 using non-disruptive administration tactics.
• Management of security aspects to the assigned systems and data integrity controls, related records and recovery control (ensuring all data is retrievable in an emergency)
• Execute other assignments as may be assigned from time to time by superiors.
• Analyze user data needs and determine needs resolved through automated repeatable process.
• Prepare transparent standard reports and analyze to support business needs
• Creating crystal reports and upload to front end solution for end users
• Editing current report based on product and user requirements
• Document business requirements to depict user needs with complimentary technical requirements
• Ensure high data quality through regular quality checks
• Decompose high-level business needs into functional needs by understanding problem and determining data needs.
• Extract, filter and aggregate data through logical queries and basic programming.
• Develop and create data layout like tables, charts, graphs, heat maps and process flow diagrams.
• Monthly data upload to BOT For Credit Reference
• Data upload to BOT for RTSIS
• Managing CRB client report disputes
• Digital data and reports
• Other report preparation as assigned by supervisors
• IFRS and FSDR extractions and reporting

• Oracle
• SQL
• MS Excel
• BI tools
• WPS
• Python
• R
• Alteryx
• Communication
• Analytical Skills
• Presentation Skills

• Degree in computer science, Information technology or a related field.
• Experience working with databases management such as PostgreSQL or SQL Server OR Oracle
• A comfortable hand on WPS or Python or R or Alterexy or any other programming language, this is just an additional skill
• Excellent Communication, Analytical and Presentation Skills
• Passionate about data and analyzing business needs