Business Data Analyst

Northwestern University

Evanston, IL

ID: 7114500
Posted: October 24, 2022
Application Deadline: Open Until Filled

Job Description

Job Summary:

The Office of Accounting Services for Research and Sponsored Programs (ASRSP) helps university researchers with financial reporting, invoicing, collecting revenue, coordinating audits, and processing transactions related to their sponsored projects.

Under supervision of the Assistant Director of Compliance, the Business Data Analyst Sr. provides expertise in data management, quality assurance, analysis and reporting to assist ASRSP in achieving its business objective.

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.
Specific Responsibilities:

Strategic Planning

Partners with clients (internal and external) to define requirements based on business objectives.
Collaborates with technical staff explaining needs of functional users. Serve on committees related to data structure and governance.

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.

Develops queries and quality metrics.
Interprets results using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex statistical analysis.
Manages complex databases.

Completes data cleaning and organizes data files for analysis.
Reviews data and identifies quality issues.
Presents findings in an appropriate manner.
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.
Please see information highlighted in tables below.
Enterprise Applications

Cognos BI (preferred, not mandatory)
OnBase (preferred, not mandatory)
PeopleSoft Financials/SCM (NU Financials) (preferred, not mandatory)
Infrastructure (extends across applications)

Microsoft Office (Word, Excel, Powerpoint, Access, Outlook)
Programming Languages and Frameworks


critical thinking
database design/ data structure
decision making
problem solving
use-case analysis

collaboration and teamwork
functional documentation
organizational skills
workflow development & documentation
Minimum Competencies: (Skills, knowledge, and abilities.)

Understanding of data analysis processes, strong technical skills to support collecting and analyzing data.
Excellent computer skills and proficiency with word processing, databases, and spreadsheet applications (Excel, Word, PowerPoint, Access).
Ability to work independently and proactively identify and implement solutions to problems.
Strong oral/written communication and organizational skills.
Continuous improvement mindset.
Preferred Qualifications:

Experience working in a research-intensive organization.
Experience recognizing and implementing areas of improvement in the use of business data and/or business processes.