Data Engineer

We are looking for a Data Engineer who can:

• Design, build, and maintain ETL pipelines that extract, transform, and load data from diverse sources into warehouses, lakes, and lakehouses.
• Build scalable, performant data infrastructure using tools such as Databricks, Snowflake, and Azure Data Factory.
• Architect data warehouses and data lakehouses that serve structured and unstructured data needs for analytics, reporting, and modelling.
• Partner with the Development and Operations teams to design model views that power complex Power BI reports.
• Collaborate closely with Data Scientists to understand their requirements and deliver data pipelines, aggregations, and datasets ready for analysis and modelling.
• Optimise storage performance, manage data quality, and ensure integrity across all data environments.
• Translate data requirements into practical engineering solutions that enable data-driven decision-making across the business.

Your skill set will consist of the following:

• Hands-on experience with Azure Data Engineering services, including Azure Data Factory, Databricks, and Snowflake.
• Strong programming ability in T-SQL, Python, or R
• Deep knowledge of relational databases, particularly Azure PostgreSQL and MS SQL Server, including design, query optimisation, and performance tuning
• Familiarity with enterprise architecture frameworks such as TOGAF and Zachman, and how they inform data architecture decisions.
• Understanding of data governance principles as outlined in DAMA DMBOK, including data quality, data lineage, and compliance

At TRI, we take pride in our open and collaborative company culture – it’s at the heart of everything we do. Our aim is to support each other and set each other up for success. 
  
 As a TRI team member, you can expect to be offered the right environment, compensation, and development opportunities to allow you to focus on being successful, and to support your colleagues to do the same. 
  
 In return, TRI expects our team members to work hard, focusing on what really matters. We ask for honesty, thoughtful communication, and cross-functional support. It really is that simple.

• Salary:  £60,000 - £65,000 Depending on Experience
• Flexible, remote-first working. 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).
• Generous holiday as standard. 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.
• Extra holiday on top. For every full year you are with TRI, you will earn an extra day of holiday, up to a maximum of 30 days.
• Carefully considered, market-leading salaries. 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.
• Enhanced pension offer. 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.
• Health and wellbeing support. 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.
• Life cover. You will be covered at four times your salary from day one, paid as a tax-free lump sum to your named beneficiary.
• In-person meetings and socials. We have company conferences each year, plus regular team meet-ups throughout the year.
• Training and development. We make sure that you are able to reach your full potential with TRI by offering you access to training and development, plus regular reviews and goal-setting with your line manager.
• Celebrating milestones. We celebrate your personal milestones and achievements as well, because we know there’s more to life than work

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.

Our History!
2013
Establishing our foundation in Cambridge, UK
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.

2016
Introducing OPRA, a new era of monitoring
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.

2020
Further advancing risk management
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.