Junior Data Analyst
Role details
Job location
Tech stack
Job description
The Junior Data Analyst plays a key role in supporting the delivery of highquality, reliable, and timely insights across Consumer. Working as part of a multidisciplinary data squad, the role focuses on data preparation, dashboard development, data quality checks, and supporting senior analysts with analysis that underpins decisionmaking across Marketing, Sales, Trading, Digital, and Service.
This is an ideal role for someone early in their data career who is eager to learn modern data tooling (GCP, SQL, BigQuery, QlikSense) and wants to contribute to the delivery of automated, scalable, selfserve analytics.
What you'll be doing
Data Preparation & Quality
- Extract, clean, transform, and validate data using SQL and BT's cloud data platforms (GCP / BigQuery).
- Conduct data quality checks, reconcile data sources, and flag anomalies or issues early.
- Maintain documentation and ensure datasets and reports meet governance and accuracy standards.
Analysis & Insight
- Support senior analysts with exploratory analysis and deep dives.
- Produce clear, concise tables, charts, and narrative outputs to answer commercial questions.
- Help quantify performance trends (e.g., sales, churn, digital journeys, campaign effectiveness).
Dashboard & Reporting
- Build and maintain QlikSense dashboards used by operational and commercial teams.
- Refresh recurring reports and troubleshoot data issues in BAU cycles.
- Contribute to the automation of manual Excelbased reporting.
Collaboration & Ways of Working
- Work within an agile, crossfunctional squad alongside product owners, data engineers, and decision scientists.
- Participate in standups, sprint ceremonies, and planning.
- Engage with stakeholders to understand requirements and translate them into analytical tasks.
Continuous Improvement
- Identify opportunities to simplify processes, improve data quality, and automate manual tasks.
- Learn and adopt BT standards for code quality, versioning, tagging, and governance.
- Stay current with industry analytics practices and BT's cloud tooling.
Requirements
Essential
- Basic SQL skills (e.g., SELECT, JOIN, GROUP BY, filtering).
- Understanding of data structures, ETL processes, and analytical concepts.
- Experience using Excel for data manipulation and analysis.
- Curiosity, strong attention to detail, and willingness to learn.
- Ability to explain findings clearly to nontechnical audiences.
- Ability to work collaboratively in a team environment.
Desirable (Training Provided)
- Experience with BigQuery, GCP, or other cloud data platforms.
- QlikSense report building.
- Exposure to Python for data analysis or automation.
- Understanding of data governance, documentation, and version control (e.g., Git).
Our leadership standards
Benefits & conditions
Looking in: Leading inclusively and Safely I inspire and build trust through self-awareness, honesty and integrity. Owning outcomes I take the right decisions that benefit the broader organisation.
Looking out: Delivering for the customer I execute brilliantly on clear priorities that add value to our customers and the wider business. Commercially savvy I demonstrate strong commercial focus, bringing an external perspective to decision-making.
Looking to the future: Growth mindset I experiment and identify opportunities for growth for both myself and the organisation. Building for the future I build diverse future-ready teams where all individuals can be at their best.
We value diversity and celebrate difference. 'We embed diversity and inclusion into everything that we do. It's fundamental to our purpose: we connect for good.'
We all stick to the same values: Personal, Simple, and Brilliant. From day one, you'll get stuck in to tough challenges, pitch in with ideas, make things happen. But you won't be alone: we'll be there with help and support, learning and development.