Data / Business Analyst at Pivotage Consulting

Ref No: DA/1002/GPSK
Location: Ikeja, Lagos, Nigeria.
Type: Full Time.
Job Category: Mid-Level / Expert.

Summary / Objective

• The Data / Business Analyst works out of the Lagos Office as part of the Analytics team to help firm’s business unit make data driven decisions.
• The Business / Data Analyst has experience in data cleaning, data transformation and metrics optimization.

Key Accountabilities

• Business Analysis: Understand business questions and hypotheses, determine output metrics to answer them, transform raw data to final output metrics and present the findings to business stakeholders through the company's business intelligence platform.
• Reporting: Assist in identifying and delivering on new reporting capabilities. Take reporting asks from idea to implementation. Communicate complex metrics in a visually intuitive manner to business users.
• Data management: Oversee deployment of data to Data Warehouse (Amazon Redshift) and building efficient data pipelines to serve company wide reporting.
• Experience in conducting most of the following types of analysis will be a plus: Sales trend analysis (analyzing trends across channel, product mix, geography, sales rep, customer segments), sales effectiveness, churn analysis, incentive compensation reporting, customer segmentation.

Note: This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Job Requirements

• Analytics experience: Minimum 3 years.
• Proficient use of SQL for extraction and manipulation of data.
• Advanced excel skills for answering business questions quickly.
• Experience of Mode/Looker/Qlikview/Tableau will be a plus.