Business Intelligence Analyst - City Of Johannesburg Metro Verfied

R 270 per hour City Of Johannesburg Metro, Gauteng City Of Johannesburg Metro, Gauteng more than 14 days ago 18-02-2015 8:40:16 AM
18-03-2015 8:40:16 AM
Job purpose
• Perform detailed analysis and prepare QlikView Applications, dashboards & reports to support the project management community
• Conduct complex modelling, forecasting, trending, variance analysis, and other general project, programme & portfolio, cost, schedule & quality analysis
• Provide broad analytical and MI operational support within the MI team.
Key responsibilities
• Develop QlikView standard or custom applications, dashboards and reports summarising
o project, programme & portfolio data for review by executives, managers, customers and other stakeholders
o for all aspects of time, quality and budget information
• Ensure adherence to MI processes, style guides and standards
• Document all developed/enhanced QlikView Applications/Dashboards/Reports:
o Design
o Rules (MI Database, Rules Engine, Stored Procedures)
o Stored Procedures
o Source to Target Mappings
• Attend to ad hoc data requests from internal and external PMO customers
• Synthesise current business intelligence or trend data to support recommendations for actions
• Maintain or update QlikView Applications/Dashboards/Reports
• Mentor and coach junior, less experienced team members.
• Support maintenance of data contained in MI tools
• Support the QlikView development team with improvement in design, coding stored procedures, and other application elements.
• Assist with testing and support
• Provide customer training on QlikView applications
Qualifications / Knowledge
• Proficiency in any Business Intelligence Reporting Tool(s) (preferably QlikView) to retrieve and analyse data.
• Ability to develop complex queries and reports.
• Proficient knowledge of SQL is preferred.
• Familiar with data warehousing concepts such as star schemas and data marts.
• Ability to review and analyse complex volumes of data to identify trends, and perform root cause analysis, gap analysis, benchmarking and formulation of recommendations and forecasting
• Ability to clearly summarise complex data for presentation to management
• Ability to analyse organisational data and complex problems, interpret and recommend alternative courses of action
• Experience with Microsoft Office Applications (Word, Excel, Access and PowerPoint skills required).
• Knowledge of project management concepts
• Solid analytical and problem-solving skills
• Good oral and written communications skills
• Customer service orientation, serving internal and external clients.
• Excellent attention to detail.
• Strong organisational and time management skills - ability to organise and prioritise a fast-paced, heavy workload.
• 3-5 years MI/BI experience
• Comprehensive understanding of performance metrics for Project, Programme & Portfolio Managers.

Recruiter: O2 Placements