About UsIn the ever-evolving landscape of healthcare, mediSIGHT stands at the forefront, redefining the standard for Electronic Medical Records (EMR) for ophthalmology. Our advanced platform is meticulously designed to empower ophthalmic professionals with cutting-edge tools, ensuring precision, efficiency, and unparalleled patient care.Building on more than 25 years’ experience and feedback from ophthalmologists and their teams, mediSIGHT is the latest generation of our industry-leading Electronic Medical Records (EMR) platform.We provide clinicians with all the patient information they need to make fast, confident decisions at the touch of a button. Ophthalmic clinical research is our passion – we have helped our customers deliver some of the world’s largest observational studies and will continue to support research that improves patient care.About YouWe are looking for a talented Business Intelligence Developer to lead on the development of innovative and high-quality BI solutions in support of the mediSIGHT product roadmap and other key business initiatives. Additionally you will be responsible for providing ongoing support for existing data warehouses and reporting.Our EMR data sources are designed specifically to capture most data items in a structured and consistent manner, and it is crucial that our integrated BI solutions can provide access to accurate and reliable reporting, empowering users to extract maximum value and key insights from the data.You will lead on the development of new Business Intelligence solutions across a range of key projects, taking ownership of data warehouse developments and improvements and the creation of high-quality data visualisations and reports. This will also include the delivery of accurate data extracts and the development of robust data transformations.The successful candidate will be an experienced MS SQL and MS BI stack developer, with a proven ability to play a lead role in large and complex projects. They will be proactive in their approach and confident dealing with a range of stakeholders, both internal and external alike.The successful candidate will:Lead on the development of data warehouses (SQL Server), data visualisations and reports (SSRS and Power BI), and data transformations (SQL, SSIS)Provide ongoing support for on-premise and Azure production data warehouses and reporting, including remote installs and upgrades on live customer sitesTake on the responsibility of a lead BI developer role in multiple projects and workstreams, defining the scope of projects and contributing to the BI delivery roadmapWork in a fast-paced development team alongside Clinical Analysts, Developers, Engineers and Testers, to deliver high quality developments against detailed specificationsEngage with relevant departments and stakeholders across the business, to ensure that solutions are developed and implemented to a high standard with all required functionalityReport on progress and demonstrate new developments to key stakeholders and customers, delivering training sessions when requiredEnsure that confidentiality and information governance policies are strictly adhered to when working with sensitive dataDevelop and maintain appropriate documentation e.G., solution designs and process documentation, ensuring that such documentation is kept up to dateProactively maintain collaborative and supportive working relationships with colleagues and external stakeholdersAssist the wider Data Services team with data extracts, data analysis and data validation as requiredThe role requires:In-depth working knowledge and experience working with relational databasesBackground in data warehouse design (e.G. dimensional modelling) and data analysisAdvanced MS SQL Server skillset (T-SQL, stored procedures, functions, dynamic SQL)Proven experience of developing complex reports using SSRS or closely equivalent toolsExperience of working with large or complex datasets and manipulating and transforming dataNumerical literacyMeticulous attention to detail with a focus on qualityAnalytical mind with a problem-solving aptitudeExcellent communication and organisational skillsStrong work ethic and a commitment to acting with transparency and integrityExperience or knowledge of the following would be an advantage:Software support and investigating / troubleshooting technical issues.Software development methodologies and using supporting tools such as Azure DevOps.Working with health data / clinical dataCode management and version control systems e.G. GITDashboard development using modern BI tools e.G. Power BIAzure SQL and SQL Server database administrationProgramming languages such as Python and PowershellThe types of technologies and tools you will be using are:Microsoft SQL ServerSQL Server Reporting Services (SSRS)Azure SQLPower BIAzure DevOpsVisual StudioPowershellWe don’t expect specific knowledge of ophthalmology, but we’re looking for a quick learner who is genuinely excited about our product, our market, and how we can improve the practice of specialist eye care. Personal development is a priority for Medisoft, and we encourage our team to develop their skills.The role is based at our offices in Leeds, but occasional travel may be required.PackageTo attract and retain the very best talent we offer a generous package, which includes:Salary up to £55,000 per annumPermanent RoleFlexible working; core hours 10:00 – 3:00Hybrid working model (one day in five office based)Modern air-conditioned office a short walk from Leeds Train StationFree on-site gymCasual dressGenerous referral bonus of £2,000Enhanced Family Leave packageTeam Social EventsLearning & Development programmes and opportunitiesSupport to gain Microsoft qualificationsEmployer matched 5% Pension contributionsCompany Sick PayIncremental annual leave entitlementBuy & Sell Annual Leave scheme up to 5 daysEye care and contribution towards qualifying eye wearPaid for DBS checksCycle & Travel to work schemesPart of global Group company with opportunities for personal growth across multiple business areas and regionsWe make a differenceAt Medisoft we believe that we are transforming the practice of ophthalmology through class-leading medical record technology. This isn’t hyperbole, we work with many customers across the world who have shared their successes built on use of our software: improving patient care, reducing process inefficiencies and supporting real world research studies into new treatments and procedures. To work at Medisoft is to play a key part in this ongoing drive for ophthalmic improvement.Medisoft is also dedicated to being a great place to work. We are passionate about being an inclusive and diverse organisation, where everyone is respected, supported and valued no matter who they are. We work constantly to maximise the skills within our team as we recognise that you’re more than a CV, and everyone is capable of making a difference to our business.We welcome applications from all suitably qualified candidates, regardless of their race, gender, disability, religion/belief, sexual orientation or age. All our employment is based on qualification, excellence, and business need.If you are interested in applying for the position, please submit your CV together with a cover letter, explaining your motivations for applying for the role and any relevant information supporting your application.We reserve the right to close the job advert if we find the ideal candidate for the position.Our Mission To drive optimised patient care and advancements in ophthalmology via our seamlessly integrated software, data solutions and research.Our VisionTo become the most trusted supplier of ophthalmic clinical research and electronic medical records.ValuesOur Values underpin everything that we do at Medisoft.Transparency, collaboration, innovation and commitmentWe always act with transparency and integrity.We proactively work together and support each other.We strive to offer innovative products and services.We take individual and collective responsibility to do our best for customers and patients.Medisoft people are passionate about these qualities, and we are proud that they are reflected through our work and professional relationships.