Purpose: The incumbent will determine the needs for reporting, data analysis, and business intelligence. They collaborate closely with the IT team and clients to transform data into vital knowledge and information that can be applied to make wise business decisions. In order to recognize and address important concerns, the incumbent will develop a level of detail in their understanding of the business. Ensure that the information is easily accessible to users for direct consumption or interaction with other systems. Provide data that is accurate, consistent, and dependable.

KPI 

• Review and validate customer data as it is collected
• Oversee the deployment of data to the data warehouse
• Develop policies and procedures for the collection and analysis of data
• Create or discover new data procurement and processing programs
• Cooperate with ICT System Administrator to deploy software and hardware upgrades that make it possible to leverage big data use cases
• Monitor analytics and metrics results
• Communicate with third party support services to initiate and maintain data deployment
• Implement new data analysis methodologies
• Review customer files to ensure integrity of data collection and utilization
• Perform data profiling to identify and understand anomalies
• Creation of Visual Reports using BI and ZAP
• BI Analysts educate and train clients to use data as an analytical tool, displaying the information in new forms and content for the purpose of analysis and option exploration.
• The incumbent will work with clients to determine business requirements, priorities, define key performance indicators (KPI), and develop BI and data warehouse (DW) strategies including working with business and development teams to design, and document dashboards, alerts, and reports.

qualification AND experience

1. Bachelor’s degree in business, Business Intelligence or related field required (master’s degree in business administration preferred)
2. 2+ years’ experience in a Business Intelligence role
3. Ability to understand and find appropriate applications for data and analysis results.
4. 4 years relevant job experience in statistics, database administration, analytics, or a related field
5. Exceptional organizational skills and attention to detail are required.
6. Experience with Microsoft Business Intelligence stack, including SQL Server, SSAS, SSIS, and SSRS
7. Experience with and knowledge of data warehouse
8. Strong knowledge of data structures, analysis, and SQL
9. Experience writing SQL Queries
10. Experience coding and work with Microsoft Analysis Services
11. Excellent working knowledge of Microsoft Windows OS and Microsoft Office Professional application suite (Word, Excel, PowerPoint, Access, Visio)
12. Knowledge of ERP application – SYSPRO – beneficial