SQL Implementation Associate

<h2>About the role</h2> <span style="font-family:Verdana, Geneva, sans-serif;font-size:14px;font-style:normal;font-weight:400;text-transform:none;background-color:rgb(255,255,255);display:inline;">At TRI, our mission is to make Risk-Based Quality Management (RBQM) simple; making it accessible, understandable, and actionable for clinical trials of any scale and complexity. We develop innovative technologies and simplified solutions to empower research organizations and sponsors, ensuring the highest standards of trial integrity and participant safety.</span><span style="font-family:Verdana, Geneva, sans-serif;font-size:14px;"><br><br></span><div style="font-family:'Segoe UI';font-size:14px;font-style:normal;font-weight:400;line-height:20px;"><span style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Are you excited by the idea of improving how clinical trials are designed, built, and validated? Do you thrive in a fast-paced environment where precision, problem‑solving, and collaboration come together?<br><br>We’re looking for a <strong>RBQM Implementation Associate</strong> to play a key role in supporting the <span>RBQM Implementation Consultants during OPRA implementation including design, build, test and configuration setup </span>and helping us deliver high‑quality, data‑driven solutions that advance clinical research</span></div><span style="font-family:Verdana, Geneva, sans-serif;font-size:14px;"><br></span><div style="font-family:'Segoe UI';font-size:14px;font-style:normal;font-weight:400;line-height:20px;"><span style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">As a key member of our RBQM Implementation team, you'll support our Implementation Consultants across core study build and quality activities, including:<br></span><h3><span style="font-family:Verdana, Geneva, sans-serif;font-size:14px;"><strong>OPRA Study Implementation</strong></span></h3><ul><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Assist with setup and review of OPRA studies across multiple OPRA environments.</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Review study specifications to ensure accuracy and completeness.</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Support the setup and/or review of study build sprints using <strong>Microsoft Azure DevOps</strong>.</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Create test data to support both <strong>unit testing</strong> and <strong>functional testing</strong>.</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Validate data mapping, custom calculated fields, row data lists and transformation rules during design & build — including running and interpreting <strong>SQL queries</strong>.</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Participate in functional test evidence reviews to ensure deliverables meet the required standards.</li></ul></div><br> <h2>Your skills & qualifications</h2> <div style="font-family:'Segoe UI';font-size:14px;font-style:normal;font-weight:400;line-height:20px;"><ul><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Hands‑on experience with relational databases, ideally <strong>SQL</strong>, including writing multi‑table queries.</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Strong proficiency with <strong>advanced Excel functions</strong>.</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Understanding of <strong>clinical trial data structures</strong>, especially from EDC systems.</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Familiarity with <strong>Agile methodology</strong> and experience using collaborative tools (e.g., <strong>Azure DevOps</strong>).</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Strong communication skills and the ability to build positive relationships with internal and external stakeholders.</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">A self‑starter mindset with a high level of ownership and accountability.</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">Ability to thrive in a <strong>fast‑paced, results‑driven team</strong> environment.</li><li style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">A commitment to delivering work that is accurate, consistent, and of high quality.</li></ul></div> <h2>Our company culture</h2> <h2>Benefits & compensation</h2> <div style="border:0px solid;margin:0px;font-style:normal;font-weight:400;text-transform:none;text-align:left;background-color:rgb(255,255,255);padding:0px;color:rgb(0,0,0);font-family:Arial, 'Arial_MSFontService', sans-serif;font-size:14.6667px;"><ul style="border:0px solid;margin-left:0px;"><li style="border:0px solid;margin:0px 0px 0px 24px;font-family:Verdana, Geneva, sans-serif;font-size:14px;"><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;font-weight:bold;"><span style="border:0px solid;margin:0px;padding:0px;">Salary - £38,000 - £42,000</span></span></li><li style="border:0px solid;margin:0px 0px 0px 24px;font-family:Verdana, Geneva, sans-serif;font-size:14px;"><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;font-weight:bold;"><span style="border:0px solid;margin:0px;padding:0px;">Flexible, remote-first working.</span></span><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;"><span style="border:0px solid;margin:0px;padding:0px;"> You will be able to enjoy all the benefits of working from home, with access to coworking spaces close to you if required (via Hubble membership).</span></span></li><li style="border:0px solid;margin:0px 0px 0px 24px;font-family:Verdana, Geneva, sans-serif;font-size:14px;"><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;font-weight:bold;"><span style="border:0px solid;margin:0px;padding:0px;">Generous holiday as standard.</span></span><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;"><span style="border:0px solid;margin:0px;padding:0px;"> We offer 27 days holiday, with a company shutdown between Christmas and New Year. Sometimes we also offer an extra, discretionary, paid day off to celebrate a specific company success.</span></span></li><li style="border:0px solid;margin:0px 0px 0px 24px;font-family:Verdana, Geneva, sans-serif;font-size:14px;"><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;font-weight:bold;"><span style="border:0px solid;margin:0px;padding:0px;">Extra holiday on top.</span></span><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;"><span style="border:0px solid;margin:0px;padding:0px;"> For every full year you are with TRI, you will earn an extra day of holiday, up to a maximum of 30 days.</span></span></li></ul></div><div style="border:0px solid;margin:0px;font-style:normal;font-weight:400;text-transform:none;text-align:left;background-color:rgb(255,255,255);padding:0px;color:rgb(0,0,0);font-family:Arial, 'Arial_MSFontService', sans-serif;font-size:14.6667px;"><ul style="border:0px solid;margin-left:0px;"><li style="border:0px solid;margin:0px 0px 0px 24px;font-family:Verdana, Geneva, sans-serif;font-size:14px;"><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;font-weight:bold;"><span style="border:0px solid;margin:0px;padding:0px;">Carefully considered, market-leading salaries.</span></span><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;"><span style="border:0px solid;margin:0px;padding:0px;"> We regularly benchmark our salaries to make sure we are offering at the top end of the scale. You will have your salary reviewed annually.</span></span></li><li style="border:0px solid;margin:0px 0px 0px 24px;font-family:Verdana, Geneva, sans-serif;font-size:14px;"><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;font-weight:bold;"><span style="border:0px solid;margin:0px;padding:0px;">Enhanced pension offer.</span></span><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;"><span style="border:0px solid;margin:0px;padding:0px;"> Following your probation period, you can opt in to our enhanced pension contributions arrangement. It’s a salary sacrifice scheme, paid on your full salary (not just the ‘qualifying amount’), which means you get better pension contributions alongside valuable tax and National Insurance savings.</span></span></li><li style="border:0px solid;margin:0px 0px 0px 24px;font-family:Verdana, Geneva, sans-serif;font-size:14px;"><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;font-weight:bold;"><span style="border:0px solid;margin:0px;padding:0px;">Health and wellbeing support</span></span><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;"><span style="border:0px solid;margin:0px;padding:0px;">. We offer all employees a health cash plan with Simply Health, allowing you to look after your health and wellbeing every day. Our Optimise Level 5 plan includes cash back for a huge range of health services including dental and optical, Virtual GP, face to face counselling and more.</span></span></li><li style="border:0px solid;margin:0px 0px 0px 24px;font-family:Verdana, Geneva, sans-serif;font-size:14px;"><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;font-weight:bold;"><span style="border:0px solid;margin:0px;padding:0px;">Life cover</span></span><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;"><span style="border:0px solid;margin:0px;padding:0px;">. You will be covered at four times your salary from day one, paid as a tax-free lump sum to your named beneficiary.</span></span></li><li style="border:0px solid;margin:0px 0px 0px 24px;font-family:Verdana, Geneva, sans-serif;font-size:14px;"><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;font-weight:bold;"><span style="border:0px solid;margin:0px;padding:0px;">In-person meetings and socials.</span></span><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;"><span style="border:0px solid;margin:0px;padding:0px;"> We have regular team meet-ups throughout the year.</span></span></li><li style="border:0px solid;margin:0px 0px 0px 24px;font-family:Verdana, Geneva, sans-serif;font-size:14px;"><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;font-weight:bold;"><span style="border:0px solid;margin:0px;padding:0px;">Training and development.</span></span><span style="border:0px solid;margin:0px;padding:0px;line-height:17.2667px;"><span style="border:0px solid;margin:0px;padding:0px;"> We make sure that you </span><span style="border:0px solid;margin:0px;padding:0px;">are able to</span><span style="border:0px solid;margin:0px;padding:0px;"> reach your full potential with TRI by offering you access to training and development, plus regular reviews and </span><span style="border:0px solid;margin:0px;padding:0px;">goal-setting</span><span style="border:0px solid;margin:0px;padding:0px;"> with your line manager.</span></span></li></ul></div> <h2>About Triumph Research Intelligence</h2> <h2>About OPRA (Operational Platform for Review and Analytics)</h2> <h2>Contact details</h2> <h2>About us</h2> <span style="font-family:Verdana, Geneva, sans-serif;font-size:11px;"><br></span><span style="font-family:Verdana, Geneva, sans-serif;font-size:14px;">At TRI, our mission is to make Risk-Based Quality Management simple; making it accessible, understandable, and actionable for clinical trials of any scale and complexity. We develop innovative technologies and simplified solutions to empower research organizations and sponsors, ensuring the highest standards of trial integrity and participant safety.<br><br>Our History!<br><strong>2013<br>Establishing our foundation in Cambridge, UK</strong><br>TRI marked its entry into the world of clinical trial quality management by opening our first office in the historic and intellectually vibrant city of Cambridge. This milestone symbolized our commitment to innovation and excellence, setting the stage for a future where research and technology converge to redefine industry standards.<br><br><strong>2016<br>Introducing OPRA, a new era of monitoring</strong><br>Our journey took a significant leap forward in 2016 with the launch of OPRA-CM, our centralized monitoring platform. Designed with precision and user experience in mind, OPRA-CM revolutionized how research data is monitored, ensuring higher quality, efficiency, and compliance in clinical trials. This innovation underscored our dedication to transforming research methodologies through smart technology.<br><strong><br>2020<br>Further advancing risk management</strong><br>In 2020, TRI once again pushed the boundaries of quality management by unveiling our advanced risk assessment and management tool, OPRA-RAM. This tool was developed to empower researchers to proactively identify, evaluate, and mitigate risks in their studies, ensuring the utmost integrity and reliability of research outcomes. This launch not only highlighted our ongoing commitment to safety and excellence but also set new benchmarks in research risk management.<br></span><span style="font-family:Verdana, Geneva, sans-serif;font-size:11px;"><br><br><br></span>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...