The Center for Behavioral Cardiovascular Health (CBCH) is an innovative clinical research entity looking for highly organized, detail-oriented and enthusiastic candidates to support the patient -oriented research portfolio of the Center. We are looking for a Data Programmer who is passionate about the intersection between technology and health research, a creative problem-solver, can think outside the box, and can recommend and/or develop web-based and/or mobile tools for efficient implementation of our various research protocols.
Developing new FileMaker solutions, and updating existing solutions to fix bugs, and implement changes due to study protocol modifications and feature-requests from end-users
Processing data and transforming data from various formats (e.g. JSON, XML, etc.) to CSV, SAS or Excel
Implementing, testing, modifying and debugging programming code
Devising automation techniques
Integrating Qualtrics with FileMaker solutions
Automating the data download from FileMaker solutions, Qualtrics, Fitbit, and similar tools via the corresponding APIs or ODBC, if applicable
Automating the distribution of scheduled email and SMS surveys via the Qualtrics API
Assisting with data cleaning processes to create key variables datasets for statistical analysis
Performs related duties & responsibilities as assigned/requested
Bachelor's degree in computer science or related field or equivalent in education and experience, plus 2 years relevant experience.
Experience with data analysis and professional software language (SAS or R)
Experience developing and maintaining relational database management systems, ideally with FileMaker Pro
Experience processing and performing complex transformation of data from various formats (e.g. JSON, XML, etc.) from FileMaker, web/mobile apps, and other digital technology into the following analyzable formats: CSV, SPSS, SAS and Excel
Experience with API programming including, but not limited to, Qualtrics and Fitbit
Experience developing web/mobile-based apps for research data collection, or a good understanding of the app development process
Experience with building data visualizations and dashboards with Tableau, R, Shiny, D3.js or similar tools
Master's degree in computer science or related field
Experience with statistical analysis methods used in clinical trials and epidemiological studies
Familiarity with the Health Insurance Portability and Accountability Act (HIPAA), and experience working in an academic or health research environment
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 501413
About Columbia University
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.