At a Glance
- Tasks: Transform data into insights and create reports using Power BI and SQL.
- Company: Forward-thinking organisation in Newcastle with a supportive culture.
- Benefits: Salary up to £35,000, hybrid working, mentorship, and career progression.
- Other info: Join a collaborative team and develop your skills in a dynamic environment.
- Why this job: Kickstart your analytics career and work on real commercial data projects.
- Qualifications: Degree in relevant field and experience with Power BI and SQL.
The predicted salary is between 31500 - 38500 £ per year.
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.
Junior Data Analyst employer: Jefferson Frank
Join a leading UK manufacturing and supply-chain organisation that is at the forefront of digital transformation. With a strong commitment to employee development, you will have access to competitive salaries and opportunities to enhance your IT and Data management skills in a collaborative and dynamic work environment. Located in Surrey, this hybrid role offers the chance to engage with diverse stakeholders while contributing to innovative solutions that drive business success.
StudySmarter Expert Advice🤫
We think this is how you could land Junior Data Analyst
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Jefferson Frank!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Junior Data Analyst at Jefferson Frank.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Jefferson Frank.
✨Apply Directly through Our Website
When you find a suitable opening like Junior Data Analyst at Jefferson Frank, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Junior Data Analyst
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Jefferson Frank, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Jefferson Frank. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Jefferson Frank
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Jefferson Frank!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
