Analyst Programmer 3

Case Western Reserve University; Cleveland (OH); On-site; USD 56,000 - 71,000; Full time

Benefits offered by this job

Healthcare benefits

Tuition assistance

Paid time off

Winter recess

Job summary

Case Western Reserve University is committed to transparent salary estimates for this posting. The Analyst Programmer 3 will work with investigators to design and maintain complex data systems for funded oral health disparities projects.

The role involves developing data collection instruments, performing statistical analyses, generating reports, and coordinating data across multiple sources with REDCap, SAS, SPSS, or R. Collaboration and proactive problem solving are essential.

Qualifications

• Associate's degree with 5 years of progressive experience, or a Bachelor's with 3–5 years; master's preferred.
• Experience with data capture and coding of complex longitudinal clinical dental data, medical history data, and medications.
• Proficiency in REDCap, REDCap Custom Modules, REDCap API, and REDCap Twilio API integration.
• Experience with SAS, SPSS, or R and managing the full analysis process with codebooks.
• Programming experience in at least one language (C/C++, Perl, Python, or Java) for real-time data analysis.
• Strong troubleshooting and front-end development using HTML, CSS, JavaScript.

Responsibilities

• Analyze and define system scope; build data management systems for electronic data capture.
• Design/modify applications (REDCap) and forms using front-end tech.
• Create and deliver real-time, monthly, quarterly, and annual reports to sponsors.
• Transition data from REDCap to statistical software for cleaning and analysis.

Skills

Data analysis

Statistical software (SAS/SPSS/R)

Programming (Python/C/C++/Java)

Front-end development (HTML/CSS/Java)

Data management

Communication and teamwork

Education

Associate's degree

Bachelor's degree

Master's degree preferred

Tools

REDCap

REDCap API

REDCap Twilio API

Tableau

Google Maps API

NIH RxNorm API

SAS

SPSS

R

Job description

Case Western Reserve University is committed to providing a transparent estimate of the salary range available for this position at the time of its posting. The salary range is between $56,395 and $71,340, depending on qualifications, experience, department budgets, and industry data.

Employees receive more than just a paycheck. University employees enjoy a comprehensive benefits package that includes excellent healthcare, retirement plans, tuition assistance, paid time off, and a winter recess.

POSITION OBJECTIVE

Working under minimal supervision, the Analyst Programmer 3 will closely collaborate with the principal investigator and co-investigators to formulate and define integrated data systems for funded oral health disparities projects. In this role, the analyst programmer 3 will be an integral part of the research team for multiple research projects. This individual will formulate, design, deploy and maintain highly complex database systems, design data collection instruments, write programs to process the data, conduct statistical analyses, develop presentation methods, and coordinate real time, monthly, quarterly, annual and ad-hoc reports that compile results from multiple data sources within the evaluation system.

Essential Functions

• Analyze and define system scope based on the complex needs of the research project. Build the data management system related to electronic data capture, data cleaning, data analysis, custom report creation and remote data collection. Coordinate and take a lead role in screening and compiling data from multiple data sources. This includes conducting preliminary data screenings (missing data, distribution, etc.) to ensure the quality of the data. (30%)
• Design and/or modify applications such as REDCap to make recommendations for system improvements and enhancements specific to each study. Create custom forms leveraging REDCap custom modules and front end programming (HTML, CSS and Javascript). (25%)
• Monitor study progress in real time via custom reports and provide feedback and reports to the principal investigator, project manager, study staff and external reports for funding agencies on a monthly, quarterly and annual basis. (15%)
• Develop plans to transition data from REDCap to statistical software (SAS, SPSS and/or R) for data cleaning and analysis. Conduct and/or verify the analysis of longitudinal dental data (ICDAS, DMFT) using SAS, SPSS and/or R. (6%)
• Work with users, application teams and technical staff to diagnose and resolve problems relating to a variety of research processes for data capture and study management. (6%)

Nonessential Functions

• Deploy and maintain cloud based data captures platforms in the field and provide onsite technical support for these platforms. (5%)
• Design, code, test, debug, modify and document complex systems requiring thorough knowledge of the REDCap, REDCap custom modules, the REDCap API, Tableau, the Twilio API, the Google Maps API, and NIH RxNorm API. (5%)
• Contribute to the writing of publications; develop presentations for funding agencies, and present research to external bodies. (5%)
• Perform other duties and responsibilities as assigned. (3%)

CONTACTS

Department: Daily contact with department staff to exchange information.

University: Frequent contact with faculty and department administrators to exchange information.

External: Regular contact with outside faculty, consultants and representatives of the consortium coordinating center to exchange information.

Students: Regular contact managing work study students.

Supervisory Responsibilities

This position has no direct supervision of staff employees.

Qualifications

Experience and Education: Associate's degree and 5 years progressive experience OR Bachelor's degree and 3 to 5 years of progressive experience. Master's degree preferred.

Required Skills

• Accountability/integrity, customer/quality focus, maturity, flexibility/receptivity, interpersonal relations, leadership/supervision, planning/organizing, problem solving, project management, self-development, and teamwork.
• Experience with data capture and coding of complex longitudinal clinical dental data, medical history data and medications data.
• Demonstrated proficiency in REDCap, REDCap Custom Modules, REDCap API and the REDCap Twilio API integration.
• Experience with statistical packages such as SAS, SPSS and/or R and managing the entire analysis process including handover of the final datasets, analysis code and codebooks.
• Programming experience in at least one computational language (C/C++, Perl, Python, or Java) for the purpose of real-time data analysis.
• Knowledge of network systems/operating systems supporting applications and the ability to troubleshoot these remotely.
• Demonstrated proficiency in front-end languages such as HTML, CSS and JavaScript for the purpose of designing custom data capture form and web-based applications for data collection and study management.
• Knowledge of relational databases for the purpose of maintaining complex relational databases that have clinical longitudinal data from multilevel trials.
• Advanced knowledge of operating systems such as Mac, iOS and Windows and the ability to troubleshoot these remotely.
• Advanced knowledge of Microsoft and Google productivity tools such as Excel, Word and PowerPoint, Google Drive, Google Docs, and Google Sheets.
• Knowledge of Adobe Creative Cloud for the purpose of creating complex figures for publication and creating high quality print ready study documents.
• Demonstrated SHELL script experience.
• Willingness to learn and work with artificial intelligence (AI) tools and technologies.
• Ability to demonstrate successful support, education, and advocacy for all students, aligned with the values, mission, and messaging of the university, while adhering to the staff policy on conflict of commitment and interest.
• Ability to meet consistent attendance.
• Ability to interact with colleagues, supervisors, and customers face to face.

WORKING CONDITIONS

General office environment. Limited manual dexterity required. Work requires negligible physical exertion. Little or no exposure to hazards. Must have reliable transportation and be willing to travel to housing sites to facilitate set-up and smooth execution of electronic data collection on a regular basis.

Case Western Reserve University is an equal opportunity employer. All applicants are protected under federal and state laws and university policy from discrimination based on race, color, religion, sex, sexual orientation, gender identity or expression, national or ethnic origin, protected veteran status, disability, age and genetic information.

Case Western Reserve University complies with the Americans with Disabilities Act regarding reasonable accommodations for applicants with disabilities. Applicants requiring a reasonable accommodation for any part of the application and hiring process should contact the CWRU Office of Equity at 216-368-3066 to request a reasonable accommodation. Determinations as to granting reasonable accommodations for any applicants will be made on a case-by-case basis.