Senior Statistical Programmer
- for lists. Use
for prose. Remove boilerplate, navigation, EEO, etc. Keep substantive info. We need to parse the posting. Key sections: - Responsibilities: The description includes responsibilities paragraphs. Should be under
Responsibilities
withor
- as appropriate. The responsibilities text includes multiple sentences; we can put as
- items. But we need to preserve all detail; we can list each bullet as separate
- . Education: two options (BA/BS + 5-9 years; MS + 3-7 years). Could be two
- .
Department Required Skills And Experience: list items.
Specific Required Skills And Experience: list items.
Required Skills (the list after Preferred Skills): list items.
We could also include Preferred Skills And Experience as separate section maybe under Skills.
But we have limited headings: Skills, Requirements, Benefits, Pay.
We could put education/experience under Requirements, and skills (both required and preferred) under Skills.
Thus:
Requirements
- BA/BS in Computer Science, Statistics, Applied Mathematics, Life Sciences, Engineering or related field plus 5-9 years SAS/R programming experience in a clinical trial environment
- MS in Computer Science, Statistics, Applied Mathematics, Life Sciences, Engineering or related field plus 3-7 years SAS/R programming experience in a clinical trial environment
- Effective interpersonal skills and ability to negotiate and collaborate effectively
- Effective written, oral, and presentation skills
- Effective knowledge and experience in developing analysis and reporting deliverables for research and development projects (data, analyses, tables, graphics, listings)
- A project leader; completes tasks independently at a project level; ability to collaborate with key stakeholders
- Experience in CDISC SDTM and ADaM standards
- Significant SAS or R programming experience for data manipulation, analysis and reporting
- Designs and develops complex programming algorithms
- Ability to comprehend analysis plans which may describe methodology to be programmed; understanding of statistical terminology and concepts; Implements statistical methods not currently available through commercial software packages
- Demonstrated ability to work in an exploratory environment, handling non-standard data in a variety of formats with minimal requirements; knowledge of pharmaceutical development processes
Skills
- Programming expertise with pharmacokinetic data (raw concentration data, derived PK parameters)
- Familiarity with clinical pharmacology concepts and pharmacokinetics concepts
- Efficiently manipulates very large databases including complex data preprocessing, filtering, and manipulation; programming expertise with clinical endpoint data (efficacy and safety) and pharmacokinetic data (raw concentration data, derived PK parameters)
- Experience with at least one other software than SAS (e.g., R, Python, NonMem)
- Good working knowledge of reporting processes (SOPs) and software development life-cycle (SDLC)
- Utilizes and contributes to the development of standard departmental SAS macros
- Ability and interest to work across cultures and geographies
- Ability to complete statistical programming deliverables through the use of global outsource partner programming staff
- Active in professional societies
- Clinical Database Programming
- Clinical Trials
- Collaborative Development
- Data Modeling
- Pharmaceutical Development
- Project Leadership
- Stakeholder Relationship Management
- Statistical Programming
. - Education And Minimum Requirement: This is a heading? The posting has "Education And Minimum Requirement". Should be
Education And Minimum Requirement
with content. - Department Required Skills And Experience: heading? Actually "Department Required Skills And Experience". Might be a heading. We'll treat asDepartment Required Skills And Experience
. - Specific Required Skills And Experience: heading. - Preferred Skills And Experience: heading. - Required Skills: heading? Actually after Preferred Skills there is "Required Skills Clinical Database Programming, Clinical Trials, ..." then "Preferred Skills Current Employees apply HERE ..." This seems like a list of skills. Might combine. But we need to follow instruction: include a section ONLY when posting has real, specific content for it. Use headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. However they gave examples of headings but we can use those headings. They said: usefor section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we should map content to those standard headings, not necessarily use the exact headings from posting. They want us to use those headings if applicable. So we need to decide which sections to include: Responsibilities, Requirements (maybe Education And Minimum Requirement etc), Skills, Benefits, Pay. Possibly also Qualifications (could combine with Requirements). They said prefer a few substantive sections over many thin ones. Thus we can create sections: - Responsibilities (with responsibilities paragraph) - Requirements (combining Education And Minimum Requirement, Department Required Skills And Experience, Specific Required Skills And Experience, maybe Required Skills list) - Skills (maybe Preferred Skills And Experience plus Required Skills list? But we already put skills in Requirements. Could separate: Requirements for education/experience, Skills for technical skills.) - Benefits (benefits paragraph) - Pay (salary range) We should not include Schedule (no info). Not include About the role (maybe we could but not needed). Qualifications maybe redundant. We must preserve all substantive information; do not invent or summarize away detail. So we need to include all details from the posting, but we can group them. Let's extract substantive content: Responsibilities text: "This position provides high quality statistical programming deliverables for global stakeholders in Early Development Statistics and/or PK/PD Modeling and Simulation spanning all our Company's therapeutic areas. The senior statistical programmer will gather and interpret user requirements for programming requests, retrieve required data, transform data into analysis/modeling datasets, and develop tables, listings and figures according to statistical/modeling analysis plan. The senior programmer will partner with stakeholders to solve problems; reduce the amount of programming tasks being completed by stakeholders to facilitate an increase in efficiency and compliance for the analyses. The senior programmer will also write programs to analyze data with statistical methods which are not currently available through commercial software packages. The programmer will be a key collaborator with statisticians, pharmacokinetic (PK) modelers, and other project stakeholders. Primary Activities Programmatically develop, validate and maintain complex datasets, tables, listings, and figuresProvide technical consultation and analytical support to statisticians and PK modelers for exploratory and unplanned statistical analysesPrepare compliant programming code for regulatory submissions including analysis datasets, tables, listings, figures and associated documentationEnsure programmatic traceability from data source to analysis / modeling resultSupport the development of programming standards to enable efficient and high quality production of programming deliverables" We need to keep that as prose. Could split into
elements. Education And Minimum Requirement: "BA/BS in Computer Science, Statistics, Applied Mathematics, Life Sciences, Engineering or related field plus 5-9 years SAS/R programming experience in a clinical trial environmentMS in Computer Science, Statistics, Applied Mathematics, Life Sciences, Engineering or related field plus 3-7 years SAS/R programming experience in a clinical trial environment" Note there is no space between the two lines; but we can treat as two bullet points. Department Required Skills And Experience: "Effective interpersonal skills and ability to negotiate and collaborate effectivelyEffective written, oral, and presentation skillsEffective knowledge and experience in developing analysis and reporting deliverables for research and development projects (data, analyses, tables, graphics, listings)A project leader; completes tasks independently at a project level; ability to collaborate with key stakeholders" Specific Required Skills And Experience: "Experience in CDISC SDTM and ADaM standardsSignificant SAS or R programming experience for data manipulation, analysis and reportingDesigns and develops complex programming algorithmsAbility to comprehend analysis plans which may describe methodology to be programmed; understanding of statistical terminology and concepts; Implements statistical methods not currently available through commercial software packagesDemonstrated ability to work in an exploratory environment, handling non-standard data in a variety of formats with minimal requirements; knowledge of pharmaceutical development processes" Preferred Skills And Experience: "Programming expertise with pharmacokinetic data (raw concentration data, derived PK parameters)Familiarity with clinical pharmacology concepts and pharmacokinetics conceptsEfficiently manipulates very large databases including complex data preprocessing, filtering, and manipulation; programming expertise with clinical endpoint data (efficacy and safety) and pharmacokinetic data (raw concentration data, derived PK parameters)Experience with at least one other software than SAS (e.g., R, Python, NonMem)Good working knowledge of reporting processes (SOPs) and software development life-cycle (SDLC)Utilizes and contributes to the development of standard departmental SAS macrosAbility and interest to work across cultures and geographiesAbility to complete statistical programming deliverables through the use of global outsource partner programming staffActive in professional societies" Then after that there is "BARDS2020 eligibleforERP SPjobs VETJOBS EBRG" seems like tags, ignore. Then "Required Skills Clinical Database Programming, Clinical Trials, Collaborative Development, Data Modeling, Pharmaceutical Development, Project Leadership, Stakeholder Relationship Management, Statistical Programming" Then "Preferred Skills Current Employees apply HERE Current Contingent Workers apply HERE US And Puerto Rico Residents Only" etc. That's boilerplate. Then EEO etc remove. Then salary range: "The salary range for this role is $117,000.00 - $184,200.00 This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. An employee’s position within the salary range will be based on several factors including, but not limited to relevant education, qualifications, certifications, experience, skills, geographic location, government requirements, and business or organizational needs. The successful candidate will be eligible for annual bonus and long-term incentive, if applicable." Then benefits: "We offer a comprehensive package of benefits. Available benefits include medical, dental, vision healthcare and other insurance benefits (for employee and family), retirement benefits, including 401(k), paid holidays, vacation, and compassionate and sick days. More information about benefits is available at https://jobs.merck.com/us/en/compensation-and-benefits." Then other info like application deadline etc remove. We need to keep all substantive info: responsibilities, education, skills, benefits, pay. We must not repeat job title as heading. Not include Job ID etc. We must not include boilerplate like EEO, accommodation, etc. We must not include navigation, cookie, legal, etc. We must not include duplicated lines. We must not create sections with filler like "commensurate with experience". Not present. We need to output only HTML fragment. Let's structure:
Responsibilities
... (maybe multiple paragraphs)
Requirements
We can combine education and skills into