Data Analyst & Report Developer
aon-cn
Johannesburg, Gauteng, ZA
1d ago

Job Description

Analytics Specialist II

Job Title

Data Analyst & Report Developer

Summary

  • 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.
  • Detailed Responsibilities

  • 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
  • Role Complexity

  • 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.
  • Discretion

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

  • 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.
  • Work Experience

  • 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.
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form