Career change Advice

I graduated with a BSc in Biomedical Sciences and have been working in data management for the past 10+ years, I have come to regret this career choice but at the time it was the only role I could get.
I really miss science and would like to transition into a role that is more focused on knowledge of the drugs/disease involved in the clinical trials and being able to utilise that information. I would like something that is not solely office based as I enjoyed visiting the different clinical sites during my last employment. I've worked on various oncology/immunology studies through the years so that is my main areas of interest. I have been researching and looking at different job roles but struggling on where to start.
There are a few roles that sound quite interesting to me like a Scientific Adviser, some roles require PhDs and I was never cut out for that. I don't expect to go straight into the position I want and know I will need to take on entry level positions and work my way up.
I'm considering going back to do a Masters in Drug Development or something to do with oncology/immunology. I'm excited about possibly doing a science masters not only in the hope it will help me career wise but the fact I will be learning again. I realise masters are pretty expensive and don't always help get you the job, I do have the funds to pay for one if I sacrifice my savings.
Is there anyone who previously worked in DM and transitioned to a more scientific/medical role or anyone else with general thoughts?
I really miss science and would like to transition into a role that is more focused on knowledge of the drugs/disease involved in the clinical trials and being able to utilise that information. I would like something that is not solely office based as I enjoyed visiting the different clinical sites during my last employment. I've worked on various oncology/immunology studies through the years so that is my main areas of interest. I have been researching and looking at different job roles but struggling on where to start.
There are a few roles that sound quite interesting to me like a Scientific Adviser, some roles require PhDs and I was never cut out for that. I don't expect to go straight into the position I want and know I will need to take on entry level positions and work my way up.
I'm considering going back to do a Masters in Drug Development or something to do with oncology/immunology. I'm excited about possibly doing a science masters not only in the hope it will help me career wise but the fact I will be learning again. I realise masters are pretty expensive and don't always help get you the job, I do have the funds to pay for one if I sacrifice my savings.
Is there anyone who previously worked in DM and transitioned to a more scientific/medical role or anyone else with general thoughts?