At a Glance
- Tasks: Support migration of Power BI models to improve efficiency and reliability.
- Company: Join ETL Systems, a leader in satellite communications with a thriving culture.
- Benefits: Enjoy 33 days holiday, health cash plan, annual bonuses, and flexible hours.
- Other info: Work on-site in Hereford with excellent career growth opportunities.
- Why this job: Make a global impact while developing your skills in a supportive environment.
- Qualifications: Familiarity with Power BI, data extraction, and strong documentation skills required.
The predicted salary is between 20000 - 30000 £ per year.
Looking for your next career move in a company that’s shaping the future of satellite communications? At ETL Systems, we’ve been leading the way in RF design and manufacturing for over 35 years. Our technology powers critical satellite communications infrastructure used by the top 20 satellite operators and teleports worldwide, and 75% of NATO governments rely on our equipment to help protect their citizens. We’re not just growing, we’re thriving.
With three Queen’s Awards for Enterprise in International Trade, and recent acquisitions of Atlantic Microwave, SpacePath Communications, and IRT Technologies, we’ve expanded our capabilities across the full RF chain. This includes everything from antenna to modem, as well as high-power amplifiers and RF test equipment. What truly sets us apart is our culture. We are proudly recognised as a Great Place to Work (2024, 2025 & 2026) and named Best Workplace in Manufacturing, Production and Transportation (2025). Our success is built on strong values that shape how we work and grow together:
- Collaboration: We work as one team, united in purpose and committed to shared success.
- Innovation: We embrace curiosity and forward-thinking to drive meaningful progress.
- Excellence: We set ambitious standards and consistently deliver high‑quality outcomes.
- Integrity: We act ethically, honestly and with professionalism in everything we do.
If you’re looking to join a company where your ideas are valued, your growth is supported, and your work makes a global impact, ETL Systems is the place for you.
33 days’ holiday per year (including UK bank holidays), rising to 38 days over your first five years’ service. Company‑funded Health Cash Plan (helping with everyday healthcare costs). Annual Bonus & Salary Review. Company Pension. Career development and training for all roles. ETL Employee Wellbeing Support: free eye tests, free Employee Assistance Programme, GP anytime. ETL People Perks: discounts on shopping, holidays, gym membership, days out, cinema and dining. Buy and Sell Holiday Scheme. Free on‑site Employee Gym (Hfd HQ) and subsidised Gym memberships via People Perks. Subsidised on‑site employee Café (Hfd HQ), with free refreshments for all employees. Free onsite parking, car share scheme and EV charging. Casual Business Dress. Flexible Hours available with core hours Monday-Friday 8am-4pm (no weekends/evening). Annual company events.
Role Overview
A fixed‑term intern will support a targeted migration of the organisation’s main Power BI semantic model to a more efficient refresh and preparation pattern by moving existing transformation logic into Dataflows (Gen2 where available) and aligning the approach to Microsoft Fabric ways of working (capacity, OneLake, and governed workspaces). The aim is to achieve a like‑for‑like migration (not a redesign): reduce refresh time and failures, simplify supportability, and produce clear documentation and handover materials. This opportunity is offered as a Fixed‑Term Contract of 3 months.
Objectives
- Migrate existing data preparation steps out of the semantic model and into governed dataflows, maintaining the same business outcomes and KPI results.
- Adopt Fabric‑aligned patterns where available (for example, using Dataflows Gen2 and consistent landing/curation conventions), improving operational support and lineage.
- Improve refresh reliability and performance by standardising refresh configuration, reducing duplicated transformations, and enabling clearer troubleshooting.
- Deliver a cutover‑ready package: documentation, validation evidence, and a rollout plan the core team can execute safely.
Key responsibilities
- Baseline the current semantic model refresh process: sources, transformation steps, refresh duration, failure modes, and dependency mapping.
- Create a migration plan identifying which queries/tables will move to dataflows first (staging then curated), including naming, folders, and ownership.
- Build and validate Dataflows (Gen2 where available), including parameterisation, refresh schedules, and gateway configuration if required; align workspaces to Fabric governance and capacity constraints.
- Update the existing semantic model to consume the dataflow outputs (like‑for‑like), avoiding unnecessary modelling changes; maintain KPI parity.
- Run validation and reconciliation: row counts, key measure spot‑checks, and agreed acceptance tests versus the current production outputs.
- Support a safe cutover: propose release steps, rollback approach, and a communications checklist for affected report owners/users.
- Produce runbooks and handover materials: refresh troubleshooting, lineage notes, and a backlog of further improvements (post‑migration).
A set of governed dataflows (staging + curated) that reproduce the existing transformation logic for the main semantic model, with documented refresh configuration. An updated semantic model connected to the dataflow outputs with like‑for‑like results (validated KPI parity) and improved refresh performance/stability where achievable. A validation pack: reconciliation checks, acceptance test results, and a record of any known differences/limitations. A cutover plan including release steps, rollback approach, and communications checklist for report owners. Runbook and handover pack: dataflow design notes, troubleshooting guide, and a prioritised backlog of post‑migration enhancements.
Working knowledge of Power BI and Power Query (M); understanding of relational modelling and star schema basics.
Previous experience (academic or practical) with data extraction and modelling —for example, pulling data from Dynamics 365/APIs/SQL and shaping it into analytical tables. Curiosity for performance tuning concepts (query folding, reducing transformations in the model, refresh patterns). Strong documentation habits and comfort working to standards and checklists. Bonus: familiarity with Dataflows (including Gen2), SQL basics, or a data engineering course/module.
Location: This role requires you to work on‑site at our modern manufacturing facility in Hereford - Before applying, please make sure you can commute to Coldwell Radio Station, Madley, Herefordshire, HR2 9NE.
Closing date: At ETL, we always prioritise efficiency in everything we do. With this in mind, we are looking to commence our interview process without delay and reserve the right to close the opening early should we receive suitable applications.
BPSS Compliant: Due to the nature of our work, all roles require candidates to be BPSS compliant.
VISA Sponsorship: Unfortunately, we are unable to offer sponsorship for this role.
Hours: 37.5 hours per week.
Data Analyst Internship Hereford, UK Corporate Functions employer: ETL Systems Ltd
ETL Systems is an exceptional employer, recognised as a Great Place to Work and offering a vibrant work culture that fosters collaboration, innovation, and excellence. With generous benefits including 33 days of holiday, a company-funded health cash plan, and extensive career development opportunities, employees are supported in their growth while contributing to impactful satellite communications technology. Located in Hereford, the modern facility provides a supportive environment with flexible hours, on-site amenities, and a commitment to employee wellbeing, making it an ideal place for aspiring data analysts to thrive.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst Internship Hereford, UK Corporate Functions
✨Join Data-Science Meetups
Get yourself along to local data-science meetups or workshops. They're goldmines for networking, and you'll learn from industry pros who might just point you in the direction of internships. Plus, discussing the latest trends with like-minded individuals can really amp up your game.
✨Utilise University Career Services
Check in with your uni's career services since they often have connections with companies looking for interns. They might even organise information sessions with firms, which can be a great chance for you to learn more about potential internships and make some key contacts.
✨Show Off Your Stuff on GitHub
If you're into data science, having a GitHub profile with your projects is essential. Make sure your portfolio is public and showcases your best work! Recruiters love to see your coding skills and problem-solving approach, and it’s a brilliant way to stand out.
✨Apply Directly on Our Website
Don’t forget to check out the internships listed on our site! It's always a good idea to apply directly through our website because it makes your application easier for our team to find, and you might just catch the hiring manager’s eye by showcasing exactly what you're passionate about in data science.
We think you need these skills to ace Data Analyst Internship Hereford, UK Corporate Functions
Some tips for your application 🫡
Show Off Your Technical Skills:For a data science internship, we want to see those analytical skills shine! List your programming languages, like Python or R, and make sure to highlight any relevant projects or courses you've completed. If you've dabbled with tools like Pandas, NumPy, or machine learning algorithms, don’t hold back – include those in your CV!
Share Your Curiosity in Your Cover Letter:As an intern, your motivation and eagerness to learn are key! In your cover letter, talk about specific data science concepts that excite you and how this internship at ETL Systems Ltd will help you grow. Share what you hope to achieve and how you plan to tackle real-world data problems - we love enthusiasm!
Include Any Relevant Certifications:If you've earned any certifications, such as from Coursera or DataCamp, make sure to include these in your application. They show us that you're proactive and committed to expanding your data science skillset. This could make a real difference in how we assess your application!
Keep It Relevant and Concise:Remember, as an intern, you don’t need to have decades of experience. Focus on showcasing relevant coursework, personal projects, or even related volunteer work in data science. Keep your CV and cover letter concise but impactful – we appreciate clear and straightforward communication!
How to prepare for a job interview at ETL Systems Ltd
✨Brush Up on Your Coding Skills
As a data science intern, you might get grilled on your programming skills. Expect to tackle some coding challenges using languages like Python or R. We recommend practising basic algorithms or data manipulation tasks so you can show off your tech skills with confidence.
✨Show Off Your Projects
Prepare to discuss any projects you’ve done, whether in your studies or on your own time. Having a strong portfolio of data analyses or machine learning models will really set you apart. We can use platforms like GitHub to showcase your work to impress ETL Systems Ltd.
✨Know Your Stats and ML Basics
Brush up on your statistics and machine learning concepts because interviewers love to dig into this! Be ready to explain your understanding of algorithms or how you would approach a given data problem. This will highlight your theoretical background alongside your practical skills.
✨Be Eager to Learn and Adapt
Internships are all about potential and growth. Make sure you convey your eagerness to learn and adapt to new tools or methodologies. Show ETL Systems Ltd that you’re not just looking for experience, but that you're keen to contribute and grow within the team.
