Research Data Analyst Associate

Department: MED-Psych & Behavioral Science
Salary/Grade: EXS/6

Job Summary:

The Research Data Analyst position is part of the Mental Health Services and Policy Program (MHSPP) within the Department of Psychiatry and Behavioral Sciences (PBS) at the Feinberg School of Medicine (FSM), Northwestern University (NU). MHSPP's mission is to improve the well-being of children and families who rely on publicly funded mental health services by conducting research, evaluations, and providing technical assistance. The program is staffed by a diverse team, including psychologists, health services researchers, social workers, database administrators, and data analysts.

This Research Data Analyst role will provide data management, quality assurance, analysis and reporting for the Illinois Department of Children and Family Services (IL-DCFS) under a contract with NU/MHSPP. The analyst will interpret findings and generate decision-support reports for various stakeholders, ensuring the information is clear and actionable. The role also involves setting and maintaining high standards for data quality, identifying and resolving data-related issues, and ensuring the accuracy and integrity of all reporting. The analyst will collaborate with MHSPP faculty, researchers, and external partners to align data insights with program objectives and inform decision-making. All tasks will be carried out in compliance with Good Clinical Practices (GCP) and relevant local, state, and federal regulations, as well as Northwestern University Institutional Review Board (IRB) guidelines.

Key responsibilities include: utilizing multiple quantitative and qualitative datasets from a variety of sources and interprets results using various techniques, ranging from simple data aggregation via statistical analysis to complex data mining; assisting in the design, development and implementation of business solutions partnering with clients to identify analytical requirements; and compiling reports, charts, and tables based on established statistical methods.

Specific Responsibilities:

Strategic Planning

• Partners with clients to define requirements based on business objectives.

Administration

• Develop standardized templates, policies, and procedures for internal and external reporting.
• Designs and prepares documentation for qualitative and quantitative data analysis.

Development

• Completes a variety of statistical analyses using appropriate data and software
• Merges data from multiple sources in preparation for analysis.
• Interprets results of analyses for use in reports and presentations

Performance

• Completes data cleaning and organizes data files for analysis.
• Reviews data and Identifies quality issues

Miscellaneous

• Other duties as assigned.

Minimum Qualifications: (Education, experience, and any other certifications or clearances)

• Successful completion of a full 4-year course of study in an accredited college or university leading to a bachelor's or higher degree; OR appropriate combination of education and experience.
• Microsoft Office (Word, Excel, Powerpoint, Access, Outlook)
• PL/SQL
• Python
• SQL/MySQL/Postgres
• data mining
• data modeling
• database design/ data structure
• Debugging
• problem solving
• Troubleshooting
• Code documentation
• collaboration and teamwork

Minimum Competencies: (Skills, knowledge, and abilities.)

• Intermediate knowledge of programming languages like Python or R, and database tools like SQL and Microsoft Excel.

Preferred Qualifications: (Education and experience)

• A Bachelor's degree from an accredited institution of higher learning.
• Two years' experience working with structured data using common software applications.

Preferred Competencies: (Skills, knowledge, and abilities)

• Ability to analyze and visualize structured data using common software applications.

Target hiring range for this position will be between $56,782 - 79,850 per year. Offered salary will be determined by the applicant's education, experience, knowledge, skills and abilities, as well as internal equity and alignment with market data.

Benefits:
At Northwestern, we are proud to provide meaningful, competitive, high-quality health care plans, retirement benefits, tuition discounts and more! Visit us at https://www.northwestern.edu/hr/benefits/index.html to learn more.

Work-Life and Wellness:
Northwestern offers comprehensive programs and services to help you and your family navigate life's challenges and opportunities and adopt and maintain healthy lifestyles.
We support flexible work arrangements where possible and programs to help you locate and pay for quality, affordable childcare and senior/adult care. Visit us at https://www.northwestern.edu/hr/benefits/work-life/index.html to learn more.

Professional Growth & Development:
Northwestern supports employee career development in all circumstances whether your workspace is on campus or at home. If you're interested in developing your professional potential or continuing your formal education, we offer a variety of tools and resources. Visit us at https://www.northwestern.edu/hr/learning/index.html to learn more.

Northwestern strongly recommends COVID-19 vaccinations and boosters for people who can obtain them as a critical tool for minimizing severe illness. More information can be found on the COVID-19 and Campus Updates webpage.

The Northwestern campus sits on the traditional homelands of the people of the Council of Three Fires, the Ojibwe, Potawatomi, and Odawa as well as the Menominee, Miami and Ho-Chunk nations. We acknowledge and honor the original people of the land upon which Northwestern University stands, and the Native people who remain on this land today.

Northwestern University is an Equal Opportunity, Affirmative Action Employer of all protected classes, including veterans and individuals with disabilities. Women, racial and ethnic minorities, individuals with disabilities, and veterans are encouraged to apply. Click for information on EEO is the Law.

#LI-JP1