Data Analyst, Institutional Effectiveness

Posting Date: November 16, 2018

Closing Date: Open until filled

Full-time 12 month, Administrative and Professional


Join the Department of Institutional Effectiveness where the belief is that information and information systems are fundamental to purposeful, meaningful institutional planning, research and effectiveness reporting.  


The Data Analyst serves in the capacity of technical arm of a proactive Institutional Effectiveness (IE) team. Internally, the Data Analyst works both independently and in collaboration with Information Technology and other data stewards to develop, support and promote data; create reports and perform analytics for operational, management and strategic purposes.  She or he also works independently and collaboratively on projects and is expected to exercise professional judgment in system application decisions and design. The Data Analyst also supports Institutional Effectiveness (IE) reporting by extracting, combing and cleaning data for a variety of uses.


Reporting relationship:  Executive Director of Institutional Effectiveness (IE)


Duties and responsibilities include, but are not limited to:


  • Develop solutions using University applications and data sources by using advanced knowledge of data warehousing and business intelligence concepts


  • Develop and maintain in-depth knowledge of the data, information, analytics needs of the University community.


  • Serve as the IE functional administrator for SAS and SPSS providing: high level support to report developers across the University, new data modeling, and incorporating data from other sources into the Oracle database which houses the data warehouse.


  • Provide leadership, establish protocol, processes and procedures and administer data warehouses including, but not limited to designing data warehouse objects, creating and maintaining tables, views, indexes, functions, stored procedures, packages and scheduled events.  


  • Work in conjunction with IT to establish user accounts and roles, set up parameters, schedule processes, run utilities, maintain freeze data and resolve reporting tables and warehouse errors.


  • Maintains data warehouse systems of information and reports including an accreditation –based evidence repository.


  • Work collaboratively with data stewards and custodians of data systems to understand functional business processes; how data in those systems translate into established data standards and identify potential areas for improvement.


  • Establish and maintain documentation within the University’s Data Cookbook, which may include needs assessment and metadata.


  • Create, execute and maintain IE ad-hoc and point-in-time data extracts and frozen files as required.


  • Provide data support for predictive analytics initiatives including extracting, combining and standardizing data from varied sources and source types.


  • Assist in the maintenance of the IE office web pages.


  • Assist in the production, administration and analysis of surveys originated by IE.


  • Work collaboratively with internal and external constituencies regarding data gathering and reporting.


  • Maintain knowledge and apply best practices in the field by participating in State and regional professional organizations


  • Work with various constituents on Data Governance committees and other University committees as needed.



Required qualifications:


  • Bachelor’s degree from an accredited college or university and five (5) years of progressively responsible  professional experience in institutional research in a post-secondary institution, including experience in student learning assessment or Master’s degree in Computer Science, Management Information Systems or related field and a minimum of three (3) years’ progressively responsible  professional experience. 
  • Advanced knowledge and experience writing SAS, SQL or   SPSS syntax as well as data extraction and reporting with SAS or similar data reporting tools.
  • Demonstrated technical and analytical skills required in using software to produce and administer reports for internal and external constituents.
  • Proficiency in the use of Microsoft Office Suite   applications.
  • Evidence of excellent time management, organizational, interpersonal, verbal and written communication skills; ability to work independently and effectively manage multiple and changing priorities and projects.
  • Demonstrated ability to work collaboratively with a diverse range of constituents.


    Preferred qualifications:


  • Demonstrated experience with ERP data, information and reporting needs of a comprehensive institution of higher education.
  • Demonstrated functional user experience with Ellucian Banner Student, Finance, Advancement and Human Resources modules.

    Personal attributes and traits:


  • Able to pay attention to specific detail elements, facets or parts of a situation or work assignment
  • Balanced decision making; able to make consistently sound and timely decisions
  • Able to envision comprehensive, long-range plans or goals and identify, evaluate an allocate necessary resources
  • Record of being consistent and reliable; able to regularly and dependably engage in and complete tasks or processes
  • A demonstrated attitude of enjoyment toward chosen job and career
  • Proven ability to fulfill professional duties in an ethical and moral way
  • Committed to self- assessment, self-improvement, self-management, and self-direction
  • Dedication to systems and processes by understanding and leveraging knowledge, language, authority structures and work within a given context to establish and honor norms, rules, policies, and procedures


About William Paterson:

William Paterson University is the third most diverse public university in New Jersey. As a longstanding member of the Hispanic Association of Colleges and Universities (HACU), we have been designated by the US Department of Education as a Hispanic-Serving Institution. The University offers more than 250 undergraduate and graduate academic programs that range from liberal arts and sciences to pre-professional and professional programs; it enrolls nearly 10,000 students from across the country and from over 40 nations. The University is situated on a beautiful, 370-acre suburban campus in Wayne, New Jersey, just twenty miles west of New York City.


Invitation to apply:

Please click to apply for the position.


Interested candidates will be prompted to:

•             Complete an application
•             Submit a cover letter & CV
•             Provide names/contacts of three professional references.  

Submission of all documents listed above is required for consideration.

Review of applications will begin immediately and will continue until the position is filled.


Please email for any general questions related to this application process.

The Clery Act (The Jean Clery Disclosure of Campus Security Policy and Campus Crime Statistic Act) requires all institutions of higher learning to make available to prospective employees our agency's Annual Security Report. A copy of this information is available on the University Police Department website at the Clery Act page. A paper copy of this report can be obtained at the University Police Department upon request.

William Paterson University is an equal opportunity employer that actively values and supports diversity among faculty, staff and students. Women, minorities, and members of under-represented groups are encouraged to apply.