Data Analyst, Healthcare & Life Sciences - Norstella

Data Analyst, Healthcare & Life Sciences Company: Citeline Location: Remote, United States Date Posted: Oct 1, 2024 Employment Type: Full Time Job ID: R-406 **Description** **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** + Experience working in healthcare/life science industry **(REQUIRED)** + Bachelors or Masters degree in a relevant field such as data science, statistics, computer science, or a related discipline or equivalent real-world experience. + 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. **Benefits:** + 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 opportunity employer. All job applicants will receive equal treatment regardless of race, creed, color, religion, alienage or national origin, ancestry, citizenship status, age, physical or mental disability or handicap, medical condition, sex (including pregnancy and pregnancy-related conditions), marital or domestic partner status, military or veteran status, gender, gender identity or expression, sexual orientation, genetic information, reproductive health decision making, or any other protected characteristic as established by federal, state, or local law._ _All legitimate roles with Norstella will be posted on Norstella's job board which is located at norstella.com/careers. If a role is not posted on this job board, a candidate should assume the role is not a legitimate role with Norstella. Norstella is not responsible for an application that may be submitted by or through a third-party and candidates should proceed with extreme caution if a third-party approaches them about an open role with Norstella. Norstella will never ask for anything of value or any type of payment during or as part of any recruitment, interview, or pre-hire onboarding process. If you are aware of or have reason to believe a job posting purportedly for a role with Norstella is fraudulent or otherwise not authorized by Norstella, please contact the Company using the following email address:_ _[email protected]_ _._ Norstella is an equal opportunity employer. All job applicants will receive equal treatment regardless of race, creed, color, religion, alienage or national origin, ancestry, citizenship status, age, physical or mental disability or handicap, medical condition, sex (including pregnancy and pregnancy-related conditions), marital or domestic partner status, military or veteran status, gender, gender identity or expression, sexual orientation, genetic information, reproductive health decision making, or any other protected characteristic as established by federal, state, or local law.