Data Analyst / MI Analyst
Datonomy Solutions
Johannesburg, South Africa
1d ago
source : Executive Placements

Key Accountabilities :

Accountability : Management Information Production

  • Source information from different data warehouses, data marts, manual systems and on-line systems based on knowledge of appropriate data sources given the business requirement
  • Collect and package data into usable and user-friendly management information for the relevant teams and stakeholders in the business
  • Develop new reports, report formats and standards based on identified user requirements for the business
  • Analyse derived information to create value add understanding of insights and opportunities presented by the data set
  • Prepare customised reports based on identified requirements from the business at large
  • Develop regular performance reports particularly related to needs of the business sales force to aid performance measurement and management
  • Continuously identify opportunities to automate reports and to eliminate duplicate and manual report production
  • Develop procedures and scripts for data migration
  • Provide timely scheduled management reporting
  • Investigate exceptions regarding asset movements
  • Accountability : Developer Duties

  • Development of high-quality database solutions
  • Develop, implement, and optimize stored procedures and functions using T-SQL and SAS
  • Review and interpret ongoing business report requirements
  • Research required data
  • Build appropriate and useful reporting deliverables
  • Analyze existing SQL and SAS queries for performance improvements
  • Suggest new queries
  • Develop procedures and scripts for data migration
  • Provide timely scheduled management reporting
  • Investigate exceptions about asset movements
  • Accountability : Provide value-add insight

    Accountability : Business partnering

  • Check all existing and new reports for accuracy and data integrity
  • Manage the management information service offering within the business through communicating clearly on this role
  • Engage with the business teams on an ongoing basis to understand management information needs and sensitise them to any relevant existing reports or management information outputs that will result in value-add opportunities in their respective area
  • Conduct impact analysis of any proposed changes that will impact on management information reporting
  • Actively engage and participate in new initiatives within the business to ensure that the management information component is addressed
  • Engage with internal customers to manage their expectations and deliverables
  • Engage with other management information key stakeholders within the Group to ensure that the business leverages off what is available and are aware of initiatives in the group that may impact on the business
  • Accountability : Continuous self-development and growth

  • Stay abreast of knowledge and skills relevant to the level and area of work, as well as actively seeking to attain those required for the next level of work with focus on best practices
  • Continuously enhance the business expertise by analysing its drivers, key indicators, relationships, and trends.
  • Consider all influencing events, quantify the impact on the business and pro-actively find solutions
  • Develop a thorough knowledge of various systems and related reporting.
  • Education Required

  • NQF Level 6 : B Degree
  • Experience Required :

  • Three (3) years working within banking
  • Three (3) years experience in the use of data base reporting tools and techniques
  • Two (2) years experience in experience as a SQL and / SAS Developer or similar role
  • Excellent understanding of T-SQL and SAS programming
  • Excellent understanding of Microsoft SQL Server including all packages SSIS, SSAS, SSRS and PBRS
  • Two (2) years of experience with SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services and Power BI including PB Report Server
  • Knowledge & Skills :

  • Interpersonal Skills.
  • Critical thinker and problem-solving skills
  • Thinking and problem-solving skills
  • Modelling skills : data

  • Extensive business knowledge
  • Consulting skills
  • Project Management skills
  • Information Technology literacy
  • Innovative problem-solving skills
  • Risk Management
  • Exceptional writing skills
  • Understanding of operations, process, and IT
  • Facilitation skills
  • 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