Data Analyst

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.

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.