• Job Type: Officer of Administration
• Regular/Temporary: Regular
• Hours Per Week: 35
• Salary Range: Commensurate with experience

Position Summary

We are an innovative research entity in the Division of Cardiology and General Medicine looking for a highly organized, equity driven, detail-oriented and enthusiastic candidate to support the patient-oriented research portfolio of the Center for Behavioral Cardiovascular Health. 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. 

Responsibilities

• 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 in R and other programming languages
• Devising automation techniques
• Integrating Qualtrics with FileMaker solutions
• Automating the data download from FileMaker solutions, Qualtrics, REDCap, 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
• Performing other responsibilities as assigned

Minimum Qualifications

• Bachelor's degree in computer science or related field, plus 2 years of related experience or equivalent in education and experience required.

Preferred Qualifications

• 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

Other Requirements

• Experience with programming languages (SQL, Javascript, HTML, XML, etc)
• 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
• Well-organized, proactive, extremely organized and detail-oriented with excellent time management skills.
• Able to balance working independently and within a multidisciplinary team 
• Excellent interpersonal, and communication skills.
• Able to multitask in a diverse and demanding environment with frequently shifting priorities.
• Able to demonstrate flexibility in workload/work hours to meet critical deadlines.
• Ability to prioritize multiple projects to ensure the completion of essential tasks.
• Strong commitment to equity, diversity, and inclusion.
• Must successfully complete systems training requirements.

Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.