Analytics Specialist II
Data Analyst & Report Developer
Responsible for designing, developing and maintaining Cognos TM1 application and dynamic dependant workbooks and excel based dashboards.
Responsible for Data Analysis in SQL and for designing and maintaining reports in Excel.
Analysing new requirements for MIS projects and designing the solution.
Maintain and improve on existing Cognos TM1 Models.
Maintain and automate TM1 Web and Excel Based Cognos TM1 reports.
Maintain and automate existing Excel models.
Develop SQL queries for general Data Analytics purposes or to be used as source data for applications (Like SSRS and TM1).
Develop, Design and Enhance TM1 applications to facilitate new reporting requirements.
Assist with reporting outputs as necessary.
Perform business analyst functions as and when required.
Creating data load templates in Excel for sending to clients
Creating Excel Allocation models
Work with stakeholders to understand reporting requirements, create prototypes and deliver a finalised product using SSRS, Excel or Tm1 depending on the requirements
Update operational reports on a re-occurring basis.
Perform data validation, error checking, and troubleshooting.
Performs other duties appropriate to the assignment
Works on issues of diverse scope where analysis of situations or data requires evaluation of a variety of factors.
Able to develop conclusions from analyses and apply results to the organization’s business operations.
Demonstrates good judgment in selecting methods and techniques for obtaining solutions.
Decisions normally have impact on the functional area and on clients and / or other parts of the company.
Decisions are typically guided by functional practices, management precedents and professional
Networks with senior internal and external personnel in own area of expertise.
Uses knowledge to provide consultative advice and recommendations within specific functional areas.
Supervision / Leadership
Operates independently and with initiative according to established standards and principles.
May manage, supervise or provide support, guidance and training to others.
Competencies, Knowledge & Experience
Typically possess demonstrable business experience (or equivalent), as well as in-depth knowledge of
a functional area.
Role-specific Technical Skills and Knowledge
Very advanced Excel
Structure Query Language (SQL) based data analysis and Query design.
Knowledge of Tm1 IBM Cognos TM1 Design and Development
Data analysis and validation
Researching data issues and / or problems
Verbal and written communication
Establishing and maintaining interpersonal relationships
Education & Certification
Be in possession of Grade 12 (Matric).
Be in possession of a Bachelor’s degree in an analytical related field, such as Information Technology.
Have a minimum of 1 year experience in a Tm1 development role.
Have strong analytical, consultative and communication skills.
Be able to make good judgment and work with both technical and business colleagues.
Be a self-starter and work with minimal supervision.