Specialist, Marketing Analytics & Reporting
Vacancy Number:KVID20170226-35616
Title: Specialist, Marketing Analytics & Reporting
Exp.:2017-02-26-(8 Months Ago)
Jobs no:7
Organization:Roshan Telecom |About Roshan Telecom
Education: Bachelor in Finance / Marketing / Business / IT / Management Information Systems (MIS) (with good
Work Experience: Min. 3 - 5 ’ experiences in Marketing. Years

~~2.1 Provides Accurate Commercial Business and Financial Planning Input:
 Collect, coordinate, and drive the annual financial  business planning  and budget input process across the consumer marketing sectional product functions.
 Regular (weekly, monthly, quarterly, and annual) and accurate revenue forecasting based on actuals factoring in: seasonality, changing market dynamics, competitor activities, and insights
 Initiate, coordinate and drive  performance tracking of budgets and forecast vs actuals for overall consumer market commercial business KPIs and products.
 Accurate projection of subscriber, revenue et al KPIs, and revenue projections based on existing trends, factoring in: seasonality, changing market dynamics, competitor activities, and insights.
 Financial and profitability business analysis and planning of the consumer marketing product and service activities.
 Providing inputs to finance/internal consumer marketing team in regard of variance against of actuals verses budgets and forecast submissions

2.2 Pricing Strategy Development and Management:
 Recognize and anticipate missing data from pricing business models, request and obtain required information to assure proper review of relevant facts pertaining to the proposed opportunity.
 Design and implement pricing activity reports, and perform routine maintenance of pricing activity reports to assure on going management visibility of pricing activities and the ability to evaluate integrity of the pricing and discounting processes.
 Build price optimization models based on an analysis of variables including value to the customer, market research data, country and/or region specific pricing conditions, and competitor price.
 Key point of contact for analysis of current and future pricing strategic initiatives and non-standard deals, advising other marketing arms on pricing, product configuration, and business terms to support the sales effort.
 Track and analyze market/customer trends and competitive pricing moves, and recommend appropriate course of actions.
 Conduct frequent competitor pricing analysis and make recommendations for tactical interventions
 Ensure pricing is done within pricing guidelines while keeping in view the overall business strategy and requirements as well as competition
 Source and share best practices on the telecoms industry pricing methodologies and practices with other marketing sections.
 Validate all marketing price propositions, which are planned to be launched, as a neutral vertical, to ensure that the proposition meets the overall business objectives.
 Analyze customer & business impact of all new propositions launched, so that a corrective action / learning can be taken.
 Review and monitor the effect of pricing of a certain product/service on the others.
 Lead segmented ER correction on a continuous basis integrating marketing verticals through various marketing and revenue analysis and pricing decisions to help achieving the business goals
 Build models to assess the financial impact of various products
 Investigate and recommend enhancements to existing pricing programs
 Oversee and review the developed business cases for new products/projects or price impacted business cases to ensure the inclusion of:
o Costs (interconnect, taxes, commissions,
o ER calculation is correct
o Sensitivity analysis
o Existing trends and assumptions
o Roshan pricing guidelines

 Develop/review polices, procedure, and processes for the Pricing section.
 Determine the feasibility of new products and determine optimal pricing for the new products.
 Review and enhance the defined prices for new products/ interconnect settlement for national & international agreements/ Value Added Services/Bundling Products taking into account internal costs, competition, regulation, and market constraints.
 Review the sensitivity report about the reaction of the direct competitors, providing a decion tree.
 Monitor the forecasted report about the volume of sales upon the pricing strategy.
 Monitor the development and analysis of the forecasted profitability report for every pricing strategy using the total costs.
 Identify Highest ROI and redress ROI depreciating pricing constructs

2.3 Provides Market and Revenue  Analysis and Insight Generation:
 Monitor pricing to ensure that the objectives are achieved (acquisitions/usage/revenue).
 Monitor the product and service profitabilitya amidst the ongoing competitive landscape, assessing the competitors pricing of similar products/services and recommend corrective actions.
 Gather information about competitors in order to analyze their competitive positioning.
 Analyzing key performance indicators at operational  level, benchmarking the performance, provide insights to top management.
 Analyze customer, revenue, and traffic KPIs across products and services and consistently communicate key findings (activity/campaign analysis, cluster detection, inactivity/churn, promotion uptake and effectiveness).
 Reporting of campaigns and customer understanding generated and coordinated assessment of regional marketing activities.

2.4 Timelines
 Timely delivery of analytics/ reports
 Adhoc requirements from time to time pertaining to scope of work.

2.5 Quantification,  Reporting, and Performance Tracking:
 Work closely with user departments to understand their requirements (new/ adhoc) reporting requirements.
 Supporting business intelligence responsibility and supporting all marketing verticals for reporting, performance tracking and data mining.
 Busines Reporting across all Commercial KPIs (Revenues, Traffic, Count, Customers, PPM, PPMB, ER, ARPU, UUs, et al)
 Daily , Weekly, and Monthly market analysis/reporting that highlights customer behavior and changing salient trends
 Work in close coordination with data warehousing team to maintain databases/datamarts.
 Conduct pre and post financial profitability evaluations of all commercially driven activities – marketing campaigns, product promotions, tariff changes, site rollout, new product development projects, et al.
 Initiate, coordinate and complete  performance tracking of budgets and forecast vs actuals for overall commercial business KPIs and products.
 Accurately calculate and manage overall Market Share KPIs; Customer, Revenue, Traffic, Profitability, Competitive, and Global.
 Conduct pre and post financial profitability evaluations of all commercially driven activities – marketing campaigns, product promotions, tariff changes, site rollout, new product development projects, et al.
 Analyzing KPIs (revenues, traffic, counts, customers) across;
o Sites
o Geographic designation s (Cities, Districs, Provinces, and countrywide)
o Products
o Segments
o Service profile
o Products
o Legs of usage
 Construction, Management and Updating of the respective Datamart:
o Provide Commercial specifications for designers/developers in order to ensure relevant and updated reporting on KPIs for functional/operational team members.
o Ensuring all reporting data marts are updated and accurate with all respective internal KPIs and external data (i.e. costing, subsidies, etc.)

2.6 Build cross functional relations to ensure motivated and high performance across the team:
 Manage & interact with external departments to ensure operational and functional up to date data and applications are available for analysis
 Engage with and utilize the internal stakeholder sources to update all marketing, data Warehouse information, Sales channel POS and KPIs, etc. to continuously provide direction and analysis.

 Data Mining and Reporting skills
 Problem solving methodologies and clear understanding of escalation paths
 Strong analytical, quantitative and financial problem solving skills
 Excellent and effective communications skills, both orally and in writing
 Proficient in spreadsheet and presentation tools and skills
 Ability to learn and use tools to access and analyze data
 Proficient with spreadsheets and presentation across Microsoft Office and other business applications to consolidate the marketing reporting dashboard, business cases, and generate insights from numeric and competitor trends.
 Excellent communication - oral and writing skills and a  strong numeric ability
 Project planning, organization & time management skills
 Service and goal-oriented style with a customer centric approach
 Strong; Creative Judgment, Critical and Analytical Thinking Skills able to draw conclusions from data, management information and trends.
 Self-starter - demonstrable ability to drive forward work on own initiatives aligned to achieving targets with little explicit direction.
 Strong teamwork & collaboration stakeholder management skills

 Sound understanding of generic Telco customer facing applications
 Understanding and experience in systems integration

Duties & Responsibilities

~~The basic purpose of this candidate is to work with the consumer market team members and provide insights about different consumer products, promotions & overall KPIs to ensure products profitability, thus driving revenues in line with the business strategy by analyzing, evaluating, and providing sugestions regarding products & pricing strategies and models (based on; price volumes competitive market dynamics, company policies, government regulations, and business objectives).

The marketing and Reporting Specialist will work closely with members of the Sales, Product Management, Product Engineering and Finance departments to provide insight and analysis on the products profitibilty, performance and pricing. He/She is the focal point for competitive pricing intelligence within the consumer market team, providing key input and recommendations for developing new products & promotins, sugest corrective actions for lifecycle of the existing products & promos, and plays a critical role in contributing to the company’s performance by developing and reviewing consumer segment product management’s recommendations (new and existing products) to maximize the upfront revenue opportunity. Second focus is to ensure quality revenue reporting providing accurate input for business planning and performance tracking.

Works under general supervision. Follows established procedures; work is reviewed for soundness of technical judgment, overall adequacy and accuracy. Some latitude for independent judgment.

Submission Guideline

[email protected]