Job Overview

Were seeking a motivated Junior Data Analyst to join our dynamic telecommunications team, where data drives innovation and customer satisfaction. In this role, you'll harness your Excel expertise to analyze telecom-specific datasets think call records, network performance, customer usage patterns, and churn metrics to uncover insights that fuel strategic decisions. You'll work in a fast-paced environment, supporting cross-functional teams to optimize network operations, enhance customer experiences, and boost revenue streams. If you're detail-oriented, curious, and ready to dive into the world of telecom data with a spreadsheet in hand, this is your chance to shine!

Key Responsibilities

Data Collection & Preparation

• Gather and clean telecom datasets (e.g., call detail records, billing data, network uptime stats) from internal systems and databases.
• Use Excel to organize raw data, remove duplicates, and handle missing values for accurate analysis.
• Maintain data integrity by standardizing formats and validating inputs (e.g., customer IDs, timestamps).

Data Analysis & Reporting

• Perform exploratory analysis in Excel to identify trends, anomalies, and patterns in telecom metrics like call drop rates, data usage spikes, or customer retention rates.
• Create pivot tables, charts, and dashboards in Excel to visualize key performance indicators (KPIs) such as network coverage, subscriber growth, or average revenue per user (ARPU).
• Calculate basic statistical measures (e.g., averages, medians, variances) to support operational insights.
• Prepare weekly and monthly reports for stakeholders, summarizing findings in clear, actionable formats.

Support Telecom Operations

• Assist in monitoring network performance metrics (e.g., signal strength, latency) using Excel-based tools and templates.
• Analyze customer churn data to pinpoint reasons for attrition and suggest retention strategies.
• Support pricing and tariff analysis by modeling usage trends and revenue impacts in Excel.

Collaboration & Communication

• Work with network engineers, marketing teams, and customer service reps to understand data needs and deliver tailored insights.
• Present findings in team meetings, using Excel visuals to explain trends (e.g., peak call times, regional data usage).
• Respond to ad-hoc data requests from managers, providing quick-turnaround Excel solutions.

Process Improvement

• Identify opportunities to streamline data processes using Excel macros or advanced functions (e.g., VLOOKUP, INDEX-MATCH).
• Maintain documentation of analysis methods and Excel workflows for team reference.

Qualifications & Experience

Education

• Bachelors degree in Data Analytics, Statistics, Mathematics, Computer Science, Telecommunications, or a related field (or equivalent experience).

Experience

• 0-2 years of experience in data analysis, preferably in telecommunications, IT, or a data-heavy industry.
• Proven proficiency in Microsoft Excel (intermediate to advanced level required).
• Exposure to telecom datasets (e.g., call logs, billing records) or customer analytics is a plus but not mandatory.

Certifications (Optional but Advantageous)

• Microsoft Office Specialist (MOS): Excel.
• Basic certification in data analysis (e.g., Google Data Analytics, Coursera Data Analyst).

Skills & Competencies

Technical Skills

• Excel Proficiency: Mastery of pivot tables, charts, VLOOKUP, HLOOKUP, INDEX-MATCH, conditional formatting, and basic formulas (e.g., SUMIFS, COUNTIFS).
• Data Cleaning: Ability to handle large datasets in Excel, including filtering, sorting, and text-to-columns.
• Visualization: Skill in creating clear, impactful visuals (e.g., line graphs, bar charts) for telecom KPIs.
• Familiarity with SQL, Python, or Power BI is a bonus but not required.
• Basic understanding of telecom concepts (e.g., network metrics, subscriber data) is desirable.

Analytical Skills

• Strong problem-solving ability to break down telecom business questions into data-driven answers.
• Keen attention to detail for spotting errors or trends in call records or usage stats.
• Comfort with numbers and statistical basics to interpret averages, percentages, and outliers.

Soft Skills

• Communication: Ability to explain technical insights to non-technical telecom teams (e.g., sales, operations).
• Time Management: Capacity to juggle multiple analysis tasks and meet deadlines in a fast-moving industry.
• Teamwork: Collaborative spirit to support cross-functional telecom projects.
• Curiosity and eagerness to learn about telecom operations and data applications.

Tools & Technologies

• Required: Microsoft Excel (intermediate-advanced).