• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building: ARB
• Salary Range: 70,000.00-95,000.00

---

Position Summary

The Department of Epidemiology in the Mailman School of Public Health seeks a Data Analyst to provide data management, project management, and conduct analysis of several ongoing projects, including involving Medicaid longitudinal data. Ongoing projects involve substance use epidemiology with a specific focus on social determinants of health and a methodological focus on causal inference; a candidate with an interest in these areas is preferred. The successful candidate will be detail-oriented, organized, strong writing skills, and have experience analyzing data, and proficiency in R. She/he/they will provide: assistance with managing a large, complex database of longitudinal Medicaid data; assistance with preparation of reports and papers for publication; assistance with developing related grant proposals and research protocols to extend the scope of the project; assistance with data analyses, and other support as required.

---

Responsibilities

Data management: Assistance with managing a large, complex database of longitudinal Medicaid data (20 million beneficiaries, 4 years of data), stored and analyzed on a HIPAA-secured AWS server. Data management includes writing code to make new variables and cohort creation. 40%

Data analysis: Executing pre-planned analyses on the data described above. Experience with these estimators is not required if the candidate is willing to learn. 35%

Manuscript, report, and grant preparation: Assistance with preparation of reports and papers for publication; assistance with developing related grant proposals and research protocols to extend the scope of the project. 20%

Administrative tasks: These may include server and grants management tasks, as needed. 5%

---

Minimum Qualifications

• Requires a bachelor's degree or equivalent in education and experience; plus, three years of related experience.

---

Preferred Qualifications

• A Master’s degree or equivalent in training, education, and/or experience.
• Experience with quantitative data management and analysis.
• Ability to work well and flexibly with teams of investigators.
• Proficiency in R.
• Excellent written and oral communication skills and extremely detail oriented.
• High-level interpersonal and organizational skills.

---

Equal Opportunity Employer / Disability / Veteran

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