BI Developer

BI Developer

Full-Time 60750 - 74250 £ / year (est.) On-site
Sepura

At a Glance

  • Tasks: Develop and support BI solutions using Microsoft technologies, including SQL and Power BI.
  • Company: Join Sepura Ltd, an innovative tech company in Waterbeach, Cambridge.
  • Benefits: Competitive salary, career growth, and a collaborative work environment.
  • Other info: Dynamic role with opportunities to collaborate across departments and enhance your skills.
  • Why this job: Make a real impact by modernising BI solutions and working with cutting-edge technology.
  • Qualifications: Experience in BI development, SQL, and Power BI required.

The predicted salary is between 60750 - 74250 £ per year.

It’s an exciting time to come and join the Sepura team. We are on the lookout for a BI Developer to play a key role within the IT Department. This BI/Data Developer role is responsible for developing, maintaining, and supporting the organisation’s end-to-end Microsoft BI and data platform, covering SQL databases, data warehousing, ETL/ELT, semantic models, and Power BI reporting. The role combines day-to-day operational support and performance optimisation with ongoing modernisation of the BI estate, working with business stakeholders to deliver reliable, secure, and scalable reporting solutions while reducing legacy complexity and technical debt.

Role:

  • Develop, maintain, and support BI databases, data warehouses, data marts, and associated data structures.
  • Perform day-to-day database management, including performance monitoring, query optimisation, indexing, data quality, troubleshooting, server maintenance including backup scheduling, and capacity considerations.
  • Design, develop, and maintain ETL/ELT processes to extract, transform, validate, and load data from business systems into the BI platform.
  • Write and optimise SQL, including complex queries, views, stored procedures, and transformations used by reporting and analytical solutions.
  • Design and develop SSAS Tabular and/or Power BI semantic models, applying appropriate star-schema and dimensional-modelling principles.
  • Develop and optimise DAX measures, calculation groups, relationships, hierarchies, and model security.
  • Develop, maintain, and enhance Power BI reports and dashboards, ensuring that reporting remains performant, reliable, and easy for the business to consume.
  • Understanding of Row-Level Security (RLS) and appropriate access controls across databases, semantic models, and reporting solutions.
  • Monitor BI solutions for data-refresh failures, performance issues, data-quality problems, and reporting errors, investigating and resolving issues as required.
  • Work with business stakeholders to translate reporting and analytical requirements into appropriate data models and BI solutions.
  • Maintain technical documentation covering data sources, transformations, data models, measures, dependencies, and BI architecture.
  • Apply development standards, source control, testing, deployment, and change-control practices to BI solutions.
  • Support the ongoing modernisation of the BI estate, identifying opportunities to simplify legacy solutions, consolidate datasets, improve performance, and reduce technical debt.

Day to Day: Our customer base includes many different industries and markets around the world. Our complete TETRA and LTE solutions have been developed specifically for users in multiple sectors to face their critical communications challenges. There is no such thing as a typical day here at Sepura. You will be supported by your manager and team, as well as collaborating with other departments across the business. IT activities you will be responsible for include:

  • Working with internal stakeholders to develop BI dashboards.
  • Perform database management, updates, and upgrades.
  • Working with business systems to load data into BI platforms.
  • Creating and optimising SQL queries and scripts.
  • Working with common BI tools to enhance our data and reporting.
  • Working with IT Cyber Security to maintain a secure environment.
  • Maintaining and creating technical documentation to avoid single points of failure.

What you need to succeed:

  • Strong commercial experience as a BI Developer, Data Developer, or similar technical BI role.
  • Strong knowledge of Microsoft SQL Server, T-SQL, database development, administration, performance tuning, and optimisation.
  • Good understanding of data warehousing, dimensional modelling, star schemas, and ETL/ELT principles.
  • Strong experience with SSAS Tabular and/or Power BI semantic models, including DAX.
  • Strong Power BI development skills, including data modelling, Power Query, DAX, report development, and performance optimisation.
  • Experience supporting business-critical BI solutions, including data quality, refresh failures, performance issues, and troubleshooting.
  • Good understanding of security and access controls, including Row-Level Security (RLS).
  • Able to work directly with business stakeholders to understand requirements and translate them into effective technical solutions.
  • Strong analytical and problem-solving skills, with the ability to work independently and take ownership of technical issues.
  • Good documentation and communication skills, with a structured approach to development, testing, deployment, and change control.

Desirable:

  • Experience of modernising a legacy Microsoft BI estate towards Power BI/Fabric, Tabular semantic models, and cloud-based data platforms.
  • Experience working in Dataverse, including Power Platform.

BI Developer employer: Sepura

At Sepura Ltd., we pride ourselves on being an exceptional employer, offering a dynamic work culture that fosters innovation and collaboration. Located in the vibrant area of Waterbeach, Cambridge, our team enjoys access to cutting-edge technology and opportunities for professional growth, all while contributing to mission-critical communications that make a real difference globally. Join us to be part of a supportive environment where your expertise in hardware engineering will be valued and your career can thrive.

Sepura

Contact Details:

Sepura Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land BI Developer

✨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 Sepura!

✨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 BI Developer at Sepura.

✨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 Sepura.

✨Apply Directly through Our Website

When you find a suitable opening like BI Developer at Sepura, 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 BI Developer

Microsoft SQL Server
T-SQL
Database Development
Performance Tuning
Data Warehousing
Dimensional Modelling
ETL/ELT Principles

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 Sepura, 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 Sepura. 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 Sepura

✨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 Sepura!

✨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.