Data Analyst, DCA - Operations, Research, & Advancement

Occupational Summary:

The Data Analyst will be responsible for providing data analysis, data cleaning, data storage, and data access support for a number of campus and community partnerships. The individual in this role will work with a variety of data types and sources, and be able to provide technical support for applied and community-engaged research activities, including planning, organizing, conducting, storing, and accessing quantitative analyses and data. This position regularly interacts across units within the Duke Office of Durham and Community Affairs (DCA), and the senior team and engages with internal and external stakeholders.

 

This is a one-year term-limited position, with the possibility for renewal based on satisfactory performance and grant availability.

 

Areas of Responsibility:

 

Partnership Database Management (40%)

• Translate, update, and maintain our accumulated and growing datasets, devise displays and graphics, and generally improve their accessibility.
• Request and integrate updated data into existing datasets.
• Plan and program new databases.
• Develop public-facing dashboards with functionality for community partners to search and sort the data, display descriptive values based on search and filter parameters, generate data visualizations, etc.
• Collaborate with colleagues in the establishment, maintenance, and execution of best practices associated with data security, data governance, testing, documentation, data dictionaries, and metadata repositories.

 

Campus and Community Partner Data Support (55%)

• Provide technical data processing, cleaning, and analysis assistance to campus and community partners around Duke’s Strategic Community Impact Plan (SCIP) Five Focus Areas and Strategic Priorities: 1) Housing – Housing Affordability and Infrastructure; 2) Health – Food Security and Nutrition; 3) Education – Early Childhood Education and K-12 School Readiness; 4) Employment – College and Career Readiness; and, 5) Community – Nonprofit Capacity.
• Document SCIP impact metrics by focus area, location, target population, and time.
• Generate reproducible data-cleaning code in accordance with a portfolio of applied research project needs, providing information and updates on dataset contents and status, preparing datasets for statistical analysis, and providing preliminary descriptive summaries and statistics of datasets.
• Gather needs from campus and community partners to provide support for community-engaged applied research projects, including assessing utility in applied research projects to reach SCIP major goals, linking with other datasets, and identifying and seeking additional data that could supplement current projects.
• Analyze indicators based on local economic data and statistics that demonstrate progress and outcomes related to the five focus areas.
• Collect and analyze progress/final report grants and sponsorship data from campus and community partners, sharing pertinent information with internal and external stakeholders.
• Support possible Carnegie Elective Re-Classification for Community Engagement efforts in collecting data and information, analyzing, writing, and communicating community engagement activities across learning and teaching, scholarship, research, clinical, and creative activity across the enterprise and with communities.
• Translate data into meaningful visualizations for different audiences, including community partners, campus partners, the DCA team, researchers, and other key stakeholders.
• Communicate data to internal and external audiences in accessible and impactful ways, including low-tech and high-tech methods (e.g., graphics, presentations, shareable content, interactive reports / pages on the Partnership Platform). 
• Contribute to the unit and overall organization’s knowledge base.

 

Other Duties as Assigned (5%)

• Performs other tasks, duties, and responsibilities as assigned.

 

Minimum Required Qualifications:
 

Education/Training

Work requires knowledge and skills generally acquired through completion of a Bachelor's degree program in business, computer science, mathematics, statistics or social sciences.
 

Experience

Work requires knowledge of both statistical analysis and interpretation generally acquired through at least two years of relevant experience.

 

Preferred Qualifications:

 

Education/Training

Masters preferred.
 

Skills and Abilities

• Experience in community-engaged research and participatory methods.
• Knowledge of ethical considerations in community-engaged research.
• Cultural competency and respect for diverse communities.