Junior Data Analyst

Jefferson Frank; Newcastle upon Tyne; Hybrid; GBP 21,000 - 35,000; Full time

Benefits offered by this job

Hybrid working model

Benefits

Job summary

Jefferson Frank in Newcastle upon Tyne is seeking a Junior Data Analyst to kickstart a career in data analytics. You will develop Power BI reports, write SQL queries, and collaborate with stakeholders to turn data into insights.

Ideal candidates are recent graduates or early professionals with a degree in a data-related field, strong problem-solving skills, and a genuine interest in BI. Hybrid working and clear progression are offered.

Qualifications

• Bachelor’s degree or equivalent in a data-related field.
• Experience using Power BI to create dashboards and reports.
• Strong SQL querying ability.
• Strong analytical and problem-solving skills.
• Excellent attention to detail and Excel proficiency.
• Good communication and stakeholder engagement.
• Genuine interest in data analytics and business intelligence.

Responsibilities

• Developing and maintaining Power BI reports and dashboards.
• Writing and optimizing SQL queries to extract, manipulate and validate data.
• Analyzing datasets to identify trends, patterns and opportunities.
• Producing regular and ad-hoc management reports.
• Supporting data quality, cleansing and validation activities.
• Assisting with reporting automation and process improvements.
• Translating business requirements into actionable reporting solutions.
• Presenting findings to technical and non-technical stakeholders.
• Documenting reporting processes and maintaining data definitions.

Education

Data Science / Mathematics / Statistics / Computer Science / Economics / Business Analytics degree

Job description

Junior Data Analyst

Location: Newcastle upon Tyne (Hybrid Working) | Salary: Up to £35,000 + Benefits

Are you a recent graduate looking to launch your career in data analytics?

We're working with a growing and forward‑thinking organisation based in Newcastle that is looking to add a Junior Data Analyst to its expanding team. This is an outstanding opportunity for someone at the start of their analytics journey who wants to develop their technical skills, work with modern BI tools and gain exposure to real commercial data projects.

Whether you've gained experience through your degree, an internship, placement year, bootcamp or personal projects, this role offers the chance to build a long‑term career within a supportive environment that values learning and development.

The Role

As a Junior Data Analyst, you'll work closely with experienced analysts and business stakeholders to transform data into meaningful insights that support decision‑making across the organisation.

Key responsibilities include:

• Developing and maintaining reports and dashboards using Power BI
• Writing and optimising SQL queries to extract, manipulate and validate data
• Analysing datasets to identify trends, patterns and business opportunities
• Producing regular and ad‑hoc management reports
• Supporting data quality, cleansing and validation activities
• Assisting with reporting automation and process improvements
• Translating business requirements into actionable reporting solutions
• Presenting findings and recommendations to both technical and non‑technical stakeholders
• Documenting reporting processes and maintaining data definitions

What We're Looking For

This position is ideally suited to a graduate or junior professional seeking their first dedicated analytics role.

Essential Skills & Experience

• Degree in Data Science, Mathematics, Statistics, Computer Science, Economics, Business Analytics or a related discipline
• Experience using Power BI to create dashboards and reports
• Knowledge of SQL and the ability to write queries confidently
• Strong analytical and problem‑solving skills
• Excellent attention to detail
• Good Excel skills
• Strong communication and stakeholder engagement abilities
• A genuine interest in data, analytics and business intelligence

Desirable Skills

• Knowledge of DAX and Power Query
• Exposure to Python or other analytical tools
• Understanding of relational databases and data modelling concepts
• Awareness of ETL processes or data warehousing principles
• Experience gained through internships, placements or personal analytics projects

What's On Offer

• Salary up to £35,000
• Hybrid working model
• Structured onboarding and ongoing training
• Mentorship from experienced analytics professionals
• Clear progression opportunities within data and business intelligence
• Exposure to modern reporting and analytics technologies
• Supportive and collaborative team culture
• Excellent opportunity to build a long‑term career in data

This is a fantastic opportunity for an ambitious graduate or junior analyst who wants to develop their Power BI and SQL skills within a business that actively invests in its people and provides genuine career progression.