Data Analyst

NAFSA: Association of International Educators
Washington D.C.
May 22, 2021
Jun 26, 2021
IT, Analyst
Full Time

Position Summary:  As part of the Technology Solutions Team, the Data Analyst manages NAFSA’s data services, and implements, maintains, and conducts comprehensive data analytics to assist decision-makers in advancing NAFSA’s work.  This position is responsible for querying and report writing in NAFSA’s Association Management System (iMIS) and other databases, and for providing dashboards, reports and other analyzed data to departments across the association.  The Data Analyst is excited about what can be learned with data and how data can be applied to solving problems. (S)he is responsible for teaching others the best way to leverage data to enhance desired outcomes, and uses a variety of programs, including databases, spreadsheets, business intelligence software, mapping tools, statistical software, and advanced analytics to track performance, predict trends, and interpret data.

NOTE: Due to the current pandemic, NAFSA employees are currently working remotely. However, please note that the permanent work location for this position is the NAFSA headquarters office in Washington, D.C.

Major Functions and Responsibilities

Reporting and Data Analytics (55%)

  • Manage and support NAFSA’s analytics and BI platform (Acumen)
  • Develop dashboards and visualizations that will serve to: 
    • Standardize models for data visualizations (i.e. conference demographic data and survey reporting) 
    • Help stimulate thinking and excitement around the role of analytics in helping to solve real business needs.   
  • Work with cross-departmental teams to define metrics, guidelines, and strategies for effective use of data and trends consistent with the association’s goals. 
  • Work with internal staff units to translate data into trends and actionable business intelligence through in-depth analyses and visualizations 
  • Create queries and reports from NAFSA’s enterprise system data sets including, but not limited to, marketing, sales, and engagement data to support business objectives.
  • Regularly monitor data integrity for inconsistency with NAFSA business rules, and preventing data quality issues by identifying frequent user errors, system and legacy issues; Identify causes of poor data quality, recommend and implement solutions, and communicate findings to staff and management
  • Work with database administrators and data owners across all NAFSA data sources to correct data that is inconsistent with NAFSA business rules, and ensure data integrity in support of analytics and reporting. 
  • Field incoming data support tickets from end users to resolve data issues and support reporting needs.
  • Assist in translating and documenting procedures for data integration including: 
    • New/updated processes for querying and selecting information from databases/warehouse; 
    • How to integrate information from multiple sources (AMS, web analytic tools, financial software, and other key databases); 
    • Standardization processes for extracting/blending data from data warehouse into visualization and analytics software like Tableau, PowerBI, Python, R, etc. 

Training and Communication (20%)

  • Train NAFSA staff on the use of enterprise data analytics and visualization tools that help develop data literacy, enhances data ownership and encourages analytics self-service prescribed using analytics tools and data-guided thinking.  
  • Proactively train & support business owners of enterprise data sets in data maintenance according to NAFSA business rules; develop & maintain current end-user training materials & business process documentation for data governance.
  • Prepare and deliver reports, recommendations, or alternatives for improving processes in reporting systems across the organization. 
  • Communicate reporting changes, enhancements, and modifications – verbally and through written documentation – to management and other stakeholders so that issues and solutions are understood.
  • Document and catalog learning resources for future deployment in staff capacity-development including resources such as (online learning courses, workshops, blogs/articles, apps, etc.). 
  • Research, document, and catalog available resources for capacity building related to data literacy, analysis, and adoption.   Maintain a repository for information and processes related to data warehouse implementation, processes, integration/blending, and ETL (extraction-translation-loading). 
  • Support adherence to GDPR & other compliance requirements across NAFSA’s data systems.
  • Advise on data structure within the Association Management System for new and revised system integrations.

Strategy and Planning (10%)

  • Chart the existing and future-state data analytics environment (data sources, activities and processes) and keeps documentation current for knowledge-transfer across the organization.
  • Develop and implement policies and practices for working with internal stakeholder groups in collecting, analyzing, and operationalizing their data. 
  • Develop routines and procedures for end-users to facilitate best practices use of reporting and business intelligence tools and applications.
  • Develop data management policies and procedures with the technology team & data owners.
  • Work with cross-departmental teams to define metrics, guidelines, and strategies for effective use of data and trends consistent with the association’s goals.
  • Research, review, and analyze the effectiveness and efficiency of existing report procedures and develop strategies for enhancing or further leveraging these processes, and incorporating into the data warehouse, where appropriate.
  • Participate in the identification, evaluation, recommendation of new data systems and data analytics tools that support NAFSA’s analytics goals and that improve customer interaction with the NAFSA website.

Staff and Vendor Management (10%)

  • Lead and guide NAFSA cross-departmental teams in the implementation of analytics platforms and services.
  • Motivate, support, assess and evaluate direct reports in the production of timely, high quality technology support and service. 
  • Partner closely with numerous external vendors providing technology and analytics infrastructure support; ensure contracts and service level agreements are fulfilled; lead contract review & renewal process for systems identified in annual workplan.
  • Consult with supervisor on the strategies, problem-solving and accomplishments of the team.

Other projects as assigned (5%)

Required Qualifications:

  • University degree in the field of computer science, mathematics, information management, data analytics, statistics and/or equivalent experience.
  • Five plus years of proven work experience as a data analyst working with advanced analytics software including direct experience programming for data analysis, ideally Python, SQL, and/or R.
  • A minimum of two years direct experience working with data visualization software, ideally Power BI
  • Good working knowledge of SQL (sequential query language)
  • Demonstrated experience working within project-based work structures and/or developing or leading programs or projects.
  • Strong working knowledge of RDBMS (relational database management systems), reporting tools, Excel, and data visualization tools.
  • Demonstrated experience to apply scientific approaches to analyze qualitative and quantitative data to ensure rigor in data quality.
  • Experience with the collection, manipulation, and visualization of large, varied data sets
  • Experience working with data sets pertaining to sales, product/event trends, web analytics and/or marketing.
  • Experience working with cross-departmental teams to define metrics, guidelines, and strategies for effective maintenance and use of data.
  • Demonstrated capabilities in communicating data insights to people beyond the data science team; Knowing how to best craft your message and selecting the right visualizations to support decision-making
  • Strong customer service orientation and capacity to work collaboratively with a diverse group of internal clients.
  • Strong oral and written communication skills, including around analytical concepts and methods.

Desired Qualifications:

  • Experience working with nonprofit, education, or international education institutions
  • Experience with AMS (Association Management System) database, preferably iMIS
  • Experience with ETL processes
  • Experience working with unstructured and survey data 
  • Knowledge of R or Python
  • Basic research and survey analysis skills
  • Knowledge of cloud technologies such as AWS or Google Cloud.
  • Flexible, multi-task oriented, creative, and able to work in a fast-paced team environment as well as independently.
  • Highly organized and detail-oriented, with ability to effectively prioritize and execute tasks
  • Self-starter: able to take initiative and facilitate meaningful conversations about data.

Similar jobs