1. Advanced Excel skills (Pivot tables, advanced formulas, charts)
2. Fully proficient SQL (Macro programming)
3.Business analytics / data analytics / financial modeling / business casing / performance reporting
4. Solid knowledge in data structure; strong data reconciliation skills; strong data QA skills
5. Strong Powerpoint skills
- Telecom experience, will be a bonus if also experienced in other industries
- Salesforce knowledge
- Customer analytics experience
- Strong Communication skills
Data Extraction, Preparation and Transformation:
- Writing SQL queries to extract data from various sources
- Cleaning, transforming, and validating raw data to ensure accuracy, completeness, and consistency for analysis; creating report and driving resolutions for data quality issues
- Performing data wrangling to structure datasets for specific analytical tasks.
- Developing data transformation process based on business rules
Data Analytics and Business Analytics
- Analyzing customer profile data, researching business processes and identifying how process and segmentation rules drive customer classifications
- Identifying anomalies in customer classifications, inconsistencies in business processes and data; performing deepdives to uncover the root causes
- Creating recommendations to address customer profile anomalies and process / data inconsistencies
Reporting and Visualization:
- Communicating findings, trends, and recommendations to stakeholders through clear presentations and written reports.
- Ad-hoc analysis to answer specific business questions from various stake holders
Collaboration and Stakeholder Management:
- Working closely with business teams to understand their data needs and translate them into analytical requirements.
- Presenting findings and insights to management and cross-functional teams to support data-driven decision-making.
