• Manage and maintain the daily delivery and validation of operational reporting for various business units.
  • Design operational report requirements in power bi for the relevant business units.
  • Attend meetings and act as the interface between the data engineer and data analysts, effectively communication changes and issues that need to be addressed.

Key Responsibilities:Database and Report Management

  • Identifies relevant sources of data from which to draw information.
  • Agrees specification format with stakeholders.
  • Gathers and collates information into a report and ensures accuracy.
  • Ensures accuracy of exception capturing and real time reporting.
  • Setup and design reports accordingly to stakeholder requirements.
  • Document MI SOP for all supported Business Units.
  • Ensure MI Administrators are suitably skilled on designed reports, and handover management of MI SOP.
  • Clearly document stakeholder requirements for new/amended report requirements.
  • Extract data into correct format from SQL / Other data sources.
  • Provide recommendations to stakeholders on effective data capturing and storage to ensure timely delivery of reporting.
  • Ongoing monitoring of data sources to ensure efficient delivery of data to stakeholdetrs.

Stakeholder Management

  • Attend stakeholder meetings as required, provide feedback on progress and recording issues that need attention.
  • Provide feedback to BI Team on areas of concern that need focus.
  • Effectively communicate changes/updates to all stakeholders as applicable.
  • Provide direction to stakeholders on required reporting within the context of Enterprise Information Platform.
  • Effectively communicate and work with the Data Analysts and Data Engineers to design new data requirements that fall outside of the currently available dataset.

Analysis

  • Interprets data to identify trends and risks.
  • Explores and identifies reasons for trends.
  • Analyses and documents business processes, including recommendations for improvement against the identified weakness.
  • Provide trend analysis and recommendations to relevant stakeholders as applicable.

Data Security

  • Maintains data standards in accordance with business requirements, the company policies, and the data protection legislation.
  • Works in accordance with the security information requirements and procedures of the company.
  • Controls access to databases environments through permissions and privileges.

Competencies

  • Report design
  • Power BI / Tableau
  • MS Excel Advanced
  • MS Power Query Advanced
  • Oral and Written Communication
  • MS SQL
  • MS SQL Server
  • Database Design
  • Proficiency with Power BI.
  • Proficiency with DAX / Python
  • Understanding of databases and data frameworks
  • Proficiency in excel and power query.
  • Strong organizational skills
  • Proficiency in SQL Scripting and SQL Server
  • Proficiency in SQL Server
  • Proficiency in SSIS/SSMS
  • Independent worker
  • Target driven.
  • Team Player
  • Effective communicator
  • Self-driven to grow and develop.
  • Analytical

Desired Skills:

  • SQL Server
  • Power BI
  • Python
  • SSMS
  • SSIS

Learn more/Apply for this position