City of Johannesburg, Gauteng, South Africa
Technology Exposure - Elasticsearch - RabbitMQ - Kibana - Grafana Responsibilities - Application Performance Management Project (APM) - Engage with business stakeholders to identify suitable data sources, enrichment and metrics. - Contribute to dashboard development and distribution through the technical team including building data pipelines and routing. - Solution enhancements include cloud migration assessment - primarily focused on Amazon Web Services platform (AWS).
Technology Experience - Microsoft Power BI - Microsoft Azure SQL Database Responsibilities - Design and build data models on a MS Azure cloud solution which supports aggregated visual dashboards on MS Power BI to monitor coal division fixed mine asset health and productivity. - Work closely with internal technical stakeholders to design and build a sustainable data collection, analysis, and reporting methodology tailored for the solution. - Incorporate metric calculations into the business rules associated with the measurement of dragline asset type metrics and KPI performance.
Responsibilities - Working closely with senior management to establish and overarching enterprise data framework which aligns to the legislative requirements of the long term insurance act sections which apply specifically to data management. - Part of a small team, we were tasked with reviewing the existing governance and risk management strategies and policies. - Provide input in the form of recommendations and round table discussions. - Develop and present a documented data governance framework which could then be used further to guide policy making decisions.
Senior BI Developer Technology Experience - Oracle SQL - Microsoft SQL / MS SQL - BI Front End Reporting / Visualisation Tools - Qliksense, Power BI - ETL Development - SDLC (Agile, Waterfall, Iterative) Responsibilities - Design and develop automated, visual, analytical, real-time and dynamic dashboards which track key elements (KPI) of the procure to pay process framework. - Provide additional insight through data exploration, data profiling and ad hoc analysis. - Make use of the data warehouse cloud based technology platform which incorporates predominant data sources from SAP ECC, SAP SRM and Syspro 6/7. - Engage with key business stakeholders to develop requirements which serve to improve process through data driven initiatives. - Work with external partners to enhance data availability and completeness. - Work within a project framework facilitated through the National Operations Centre (NOC)
Technology Experience - Teradata SQL - Oracle SQL - Microsoft SQL / MS SQL - BI Front End Reporting / Visualisation Tools - Qliksense, Power BI - ETL Development - SDLC (Agile) Responsibilities - Lead the engagement with assigned business units as a business partner to understand and develop their strategic reporting requirements - Translate high level user stories into reports through prototyping and iterative development - Perform data analysis during data discovery and then extract, transform, load (ETL) tasks towards modelling data for dashboard publication and automation - Understand and work within the constraints of the organisational data challenges from upstream source systems down to the Enterprise Data Warehouse (EDW) - Develop understanding of database structure specifically around mitigating data load times for large datasets - Ensure data accuracy by identification through exception reporting, reconciliation to other data sources and driving single source truth through engagements with business - Create and enhance reports with emphases on 'story telling' elements aggregated views with visualizations