SQL Developer

at OPEN Health (view profile)
Location London, England, United Kingdom
Date Posted January 23, 2023
Category Real World Evidence or Evidence Development
Job Type Full-time
Job Level Other


OPEN Health brings together deep scientific knowledge, global understanding, and broad specialist expertise to support our clients in improving health outcomes and patient wellbeing.

We are united as one flexible organization, harnessing the power of the collective to solve complex challenges. Being built from cohesive partnerships across a range of specialist sectors gives us the ability to approach opportunities from fresh perspectives, creating solutions and innovations for market access and medical communications that are informed by the experience and knowledge of the many.

Our global team of experts — many with PhD and PharmD degrees — work strategically alongside our client partners in Medical Affairs, Health Economics and Outcomes Research (HEOR), Market Access, and Commercial teams across a wide range of therapy areas.

You will love this role if you:

  • Have a passion for making complex data palatable for your audience
  • Like working closely with front-end developers and data analysis teams to produce cutting-edge reports
  • Enjoy working within health informatics or have a keen interest in this area

As part of the OPEN Health Real World Evidence team, you will be responsible for the following activities:

  • Providing expertise regarding SQL queries including writing, indexing, optimisation, and best practice
  • Extracting, transforming and loading data from raw text files into MS SQL Server and providing data from MS SQL to My SQL
  • Working alongside our development team to provide support and data expertise
  • Managing the overall structure of the data warehouse databases, including import/export processes and data accuracy
  • Securing backup of the data and data models and providing basic MS SQL server administration
  • Working independently and as part of the data analyst team to provide data insights
  • Working in Excel including pivot tables and cell calculations/functions
  • Ensuring all data imported and produced are factually correct and meet the requirements of the data specified
  • Ensuring all data import tasks are delivered within pre-agreed timelines to meet the specification
  • Making suggestions to improve the data warehouse through enhanced processes

What you’ll bring:

  • Experience with SQL Server 2016+ with Excellent T-SQL skills
  • Experience across MS BI Stack – SSAS, SSIS, SSRS with particular strength/experience in SSAS (Tabular & Multidimensional)
  • Experience with scripting DAX is desirable
  • Strong data modelling and data warehousing development experience
  • Ability to adapt to changing priorities and effectively use teamwork skills to interact and collaborate on alternative approaches to issues
  • Excellent communication and listening skills
  • Experience with NHS data a plus

What we offer:

As a global organization, OPEN Health is committed to supporting our employees and their families through a comprehensive benefits program

  • Competitive pay, generous paid vacation and holidays, and health insurance programs across all our locations
  • Ongoing training and development opportunities which foster and shape your individual career path
  • An active and growing commitment to bettering the communities our employees call home through our Corporate Social Responsibility program
  • The opportunity to thrive in a global, collaborative environment while working every day to improve health outcomes and patient wellbeing
  • Diverse, inclusive culture that encourages you to bring your whole self to work

If we sound like the sort of business environment in which you would thrive, then we would love to hear from you.

Drop files here browse files ...