Junior Data Analyst

We're 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 like 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

1. 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).
2. 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.
3. 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.
   • 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.
4. 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

1. Education
   • Bachelor's degree in Data Analytics, Statistics, Mathematics, Computer Science, Telecommunications, or a related field (or equivalent experience).
2. 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.
3. Certifications (Optional but Advantageous)
   • Microsoft Office Specialist (MOS): Excel.
   • Basic certification in data analysis (e.g., Google Data Analytics, Coursera Data Analyst).

Technical Skills

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

Analytical Skills

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

Soft Skills

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

Tools & Technologies

Required: Microsoft Excel (intermediate-advanced).