To provide industry standard business insight (BI) capabilities in relation to Truphone’s Wholesale Global Partner Costs, supporting real time management information fully reconciled to key financial and operational KPIs.
Key insight for Wholesale Global Partner Costs including use / spend analysis for all of Truphone’s airtime partners including MVNO, bilateral agreements and roaming arrangements.
Development of analysis tools enabling allocation of airtime use to customer cohorts including impact of customer ‘adds’ (new business), ‘deletes’ (churn), ‘changes’ (renewal) supporting margin analysis.
The post holder will be expected to develop a strong understanding of Wholesale Global Partner costs base hydraulics (financial and operational) supporting the business in understanding how evolving usage impacts business outcomes.
You will work as part of the BI team expected to deliver right first time analytical insight across specific areas of responsibility and be able to boil-down complex data scenarios and analytical findings into actionable information packs for Exec and Management consumption.
You will also support cultural transformation across the business in terms of improved data governance, accuracy and management whilst enriching business insight and providing focused actionable information.
Responsible for providing Truphone Wholesale Global Partner Costs analysis insight.
Define and agree with stakeholders analysis and scope for Wholesale Global Partner Costs including;
Truphone’s MVNO, bilateral agreements and roaming arrangements;
country use profiles reconciled to customers;
impact of customer related ‘adds’ (new business), ‘deletes’ (churn), ‘changes’ (renewal);
customer cohort analysis including eg vintage, country etc; and
Key KPIs including ACPU.
Agree with stakeholders the form and structure of periodic Wholesale Global Partner Costs business insight reports. Deliver periodic (weekly, monthly etc) insight reports in line with agreed stakeholder SLAs.
Develop effective Wholesale Global Partner Costs exception reporting providing minimum fraud assurance.
Work with internal customers to ensure results are communicated and used effectively.
Apply BI best practice in your specific business area.
Support investigations and other ad-hoc work as required.
Assure data quality and promote effective business rules to preserve and protect data
Create tools supporting enhanced BI self-service.
Establish work habits to support the function's evolving process and execution needs...
Skills and Experience Required:
3-5 years’ experience in Business Intelligence and Analytics in a corporate environment
Experience in the area of customer revenue and assurance
Mobile Telecoms experience with emphasis on financial data, processes and reporting.
Able to work in a mix of Agile BI and Waterfall BI approaches.
Good experience of Microsoft SSIS, SSAS and SSRS BI stack toolset.
Kimball technology experience and understanding - ideally
Strong numeracy and analytical skills, proficient in data analysis from a commercial and strategic delivery perspective.
Able to transform data into information into insight into action.
Business facing ability to adopt both technical and non-technical language where necessary.
Ability to work flexibly within a team fulfilling an end-to-end range of BI delivery tasks.
Excellent communication and interpersonal skills