Department: Research Analytics
Salary/Grade: EXS/8
Job Summary: Provides expertise in data management, quality assurance, analysis and reporting. Establishes data accuracy and validity derived from a variety of systems. Performs data analysis using statistical techniques. Researches and analyzes information using multiple databases and creates reports of data and results. Assists in the preparation and delivery of decision support reports to both internal and external customers.
The Research Analytics unit resides within the Office for Research (OR), designed to serve and collaborate with other OR units to support their analytics and reporting needs.
The Research Data Analyst will work closely with the Director of Research Analytics, to respond to stakeholder needs by gathering requirements and translating them into reports, visualizations, and dashboards that fulfill project requirements. The position will work with institutional data from a variety of sources, including but not limited to research IT systems, finance, human resources, facilities, bibliometrics, and publicly available data sets.
The creation of deliverables for this position will rely upon expertise with and utilization of data visualization software, primarily the Tableau software suite and Power BI. The Research Data Analyst will be required to create data visualizations and analytics within the software, including the design and maintenance of user-facing dashboards for publishing to the web along with all appropriate data security measures. The Research Data Analyst will be expected to bring creativity to collaborations with the Designer in the Research Analytics unit to ensure dashboards are user-friendly, create design templates that reflect University branding standards, and comply with best practices in user experience and user interface design.
The Research Data Analyst will be tasked with both creating new resources for analytics and reporting, as well as maintenance and refinement of these resources to ensure they continue to meet the needs of end user stakeholders.
The Research Data Analyst Sr will support the OR mission and values of understanding empathy, modeling accountability, ensuring fairness, embracing community, and valuing creativity.
Specific Responsibilities:
Strategic Planning
- Partners with clients to define requirements based on business objectives.
- Manages and plans for data/analysis requests and projects.
Administration
- Develop standardized templates, policies, and procedures for internal and external reporting.
- Designs and prepares documentation for qualitative and quantitative data analysis.
- Discuss findings with senior management
Development
- Develop queries and quality metrics.
- Interprets results using a variety of techniques, ranging from simple data aggregation to more complex statistical analysis.
- Manages complex databases.
Performance
- Completes data cleaning and organizes data files for analysis.
- Reviews data and identifies quality issues.
- Presents findings in an appropriate manner.
Supervises
- Provides work direction and/or supervises staff such as team members, contractors, vendors, students, etc.
Miscellaneous
Performs other duties as assigned.
Minimum Qualifications: - 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.
- 2 years data analysis/report writing or similar experience required.
Enterprise Applications
Infrastructure
- Microsoft Office (Word, Excel, Powerpoint, Access, Outlook)
- Microsoft SharePoint
- Tableau (Desktop, Server< Prep Builder)
Analytical
- critical thinking
- data mining
- data modeling
- judgment
- metadata creation and management
- problem solving
Project
- collaboration and teamwork
- evaluate resources
- iterative & incremental development
- organizational skills
- planning
- data visualization
Minimum Competencies: (Skills, knowledge, and abilities.) - Demonstrated knowledge and familiarity with Tableau software (Desktop, Prep Builder, Server).
- Demonstrated knowledge and familiarity with Power BI
- Ability to use and understand data from a variety of sources with an emphasis on data accuracy and integrity.
- Ability to quickly learn new data-sets and data management systems.
- Familiarity with and ability to use the latest data visualization technologies and preparation of presentations for diverse audiences.
- Ability to work with sensitive information, often of a confidential nature.
- Ability to maintain a collaborative relationship with a diverse body of stakeholders and work together to find solutions to challenges.
Preferred Qualifications: - Work experience in a university research environment.
- Experience with graphical design and best practices for user experience/user interface design.
Preferred Competencies: (Skills, knowledge, and abilities) - Advanced Tableau skills, specifically those related to data access and filtering based on user roles.
- Knowledge of institutional data sets in a university research environment.
- Familiarity with Northwestern enterprise data and reporting systems including but not limited to Cognos, InfoEd, eIRB+, LUMEN, Facilities Connect, Northwestern Scholars, PeopleSoft.
- Knowledge of external databases and data sets related to the higher education research enterprise, including but not limited to InCites, Academic Analytics, federal databases, and similar.
Target hiring range for this position will be between $78,500-$90,000 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 and competitive benefits. The available benefits package for this position will include health, dental, vision, disability, and life insurance; paid vacation and holidays; paid medical/sick and parental leave; tuition benefits for the employee and dependents; pre-tax and flex spending accounts for commuting and dependent care; generous retirement savings options; and wellness programs. For a comprehensive overview of available benefits, including eligibility details, 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
. #LI-EN1