Data Analyst, RWD

Data Analyst, RWD


About Citeline

Citeline is one of the world's leading providers of data and intelligence on clinical trials, drug treatments, medical devices and what's new in the regulatory and commercial landscape. Relying on us to deliver vital advantage when making critical R&D and commercial decisions, our customers come from over 3000 of the world’s leading pharmaceutical, contract research organizations (CROs), medical technology, biotechnology and healthcare service providers, including the top 10 global pharma and CROs.

From drug and device discovery and development to regulatory approval, and from product launch to lifecycle management, we provide the intelligence and insight to help our customers seize opportunities, mitigate risk and make business-critical decisions, faster. As the pharma and healthcare sector faces unparalleled upheaval, customers rely on our independent advice, enabling them to cut through the clutter and make sense of changing drug development, regulatory and competitive landscapes.

Now, Citeline is proud to be a part of Norstella, an organization that consists of market-leading pharmaceutical solutions providers united under one goal: to improve patient access to life-saving therapies. Within this organization, Citeline plays a key role in helping clients connect the dots from pipeline to patient.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time.

Job Description

We are seeking a Data Analyst with strong SQL experience to join our team. As a Data Analyst, you will play a crucial role in supporting life sciences analytical use cases by querying and analyzing a wide range of healthcare data sources, including claims, lab results, electronic medical records (EMR), and other real-world data. Your expertise in SQL and data analysis will contribute to enhancing our understanding of healthcare trends, optimizing patient care, and driving evidence-based decision-making.

Key Duties and Responsibilities

  • Query and analyze large volumes of healthcare data from diverse sources, including claims, lab results, EMR, and real-world data sets, to support life sciences analytical use cases.      
  • Design and develop SQL queries, stored procedures, and functions to extract and transform data for analysis and reporting purposes. Work with a variety of file formats including Parquet, CSV, TSV, and PSV.      
  • Collaborate with cross-functional teams, including data scientists, statisticians, and healthcare professionals, to identify and define analytical requirements and deliver actionable insights.      
  • Clean, validate, and transform raw data into structured formats suitable for analysis, ensuring data quality and integrity throughout the process.      
  • Develop and maintain data documentation, including data dictionaries, data mappings, and data lineage, to ensure data transparency and accessibility.      
  • Create visually compelling reports, dashboards, and data visualizations to effectively communicate analytical findings and insights to stakeholders.       

Key Requirements

  • Bachelors or Masters degree in a relevant field such as data science, statistics, computer science, or a related discipline or equivalent real-world experience. 
  • Experience working in healthcare/life science industry. 
  • 2+ years of experience designing and developing SQL queries. 
  • 2+ years of experience working within any programming language. 
  • Strong attention to detail and a commitment to maintaining data integrity and quality. 
  • Ability to work collaboratively in a team environment, as well as independently, with a proactive and self-driven approach. 

Preferred Requirements:

  • Experience working with Real-World Data 
  • Experience working with AWS Redshift 

Our guiding principles for success:

01:  Bold, Passionate, Mission-First    

We have a lofty mission to Smooth Access to Life Saving Therapies and we will get there by being bold and passionate about the mission and our clients.  Our clients and the mission in what we are trying to accomplish must be in the forefront of our minds in everything we do.

02:  Integrity, Truth, Reality   

We make promises that we can keep, and goals that push us to new heights.  Our integrity offers us the opportunity to learn and improve by being honest about what works and what doesn’t.  By being true to the data and producing realistic metrics, we can create plans and resources to achieve our goals.

03:  Kindness, Empathy, Grace   

We will empathize with everyone's situation, provide positive and constructive feedback with kindness, and accept opportunities for improvement with grace and gratitude.  We use this principle across the organization to collaborate and build lines of open communication.

04:  Resilience, Mettle, Perseverance   

We will persevere – even in difficult and challenging situations.  Our ability to recover from missteps and failures in a positive way will help us to be successful in our mission.

05:  Humility, Gratitude, Learning   

We will be true learners by showing humility and gratitude in our work.  We recognize that the smartest person in the room is the one who is always listening, learning, and willing to shift their thinking.


  • Medical and Prescription Drug Benefits  
  • Health Savings Accounts (HSA) or Flexible Spending Accounts (FSA) 
  • Dental & Vision Benefits  
  • Basic Life and AD&D Benefits  
  • 401k Retirement Plan with Company Match  
  • Company Paid Short & Long-Term Disability 
  • Paid Parental Leave  
  • Education Reimbursement    
  • Paid Time Off & Company Holidays  

The expected base salary for this position ranges from $90,000 – 100,000. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, licensure or certifications obtained. Market and organizational factors are also considered. In addition to base salary and a competitive benefits package, successful candidates are eligible to receive a discretionary bonus.

Norstella is an equal opportunities employer and do not discriminate on the grounds of gender, sexual orientation, marital or civil partner status, pregnancy or maternity, gender reassignment, race, colour, nationality, ethnic or national origin, religion or belief, disability or age. Our ethos is to respect and value people’s differences, to help everyone achieve more at work as well as in their personal lives so that they feel proud of the part they play in our success. We believe that all decisions about people at work should be based on the individual’s abilities, skills, performance and behaviour and our business requirements. Norstella operates a zero tolerance policy to any form of discrimination, abuse or harassment.

We know that sometimes the 'perfect candidate' doesn't exist, and that sometimes the best opportunities are hidden by self-doubt. We disqualify ourselves before we have the opportunity to be considered. Regardless of where you came from, how you identify, or the path that led you here, you are welcome. If you read this job description and feel engaged and excited, we’d love to see you apply.

Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.