Institutional Research Data Architect

  • The College of Charleston
  • Charleston, South Carolina
  • Mar 26, 2024
Full time Database

Job Description

Institutional Research Data Architect*

Posting Details

POSTING INFORMATION

Internal Title

Institutional Research Data Architect*

Position Type

Classified

Faculty / Non-Faculty / Administration

Non-Faculty

Pay Band

7

Level

1

Department

Institutional Research

Job Purpose

Institutional Research Data Architect designs systems for and manages complex data to support the data-driven decision-making functions of the institution. This position serves to support the Office of Institutional Research in providing a first-class reporting structure for national and state accountability reporting including IPEDS and SC CHE. The Office of Institutional Research serves a critical function for the College of Charleston in providing data to senior administrators, the College community, and external agencies.

Minimum Requirements

Bachelor’s degree in business administration, computer science, mathematics/statistics, engineering, management information science, data processing or related field and experience with Tableau, Cognos/Argos, SQL, and/or SAS is required. Experience with data mining, including techniques of data extraction, documentation, analysis, and reporting is required. Experience working in a higher education environment is preferred. Candidates with an equivalent combination of experience and/or education are encouraged to apply.

Required Knowledge, Skills and Abilities

Required:

Experience with Tableau, Cognos/Argos, SQL, and/or SAS. Advanced SAS programming experience is preferred.

Working knowledge and practitioner of methods and techniques of data extraction, documentation, analysis, and reporting.

Proficiency with MS Office including Outlook, Word, Excel, Teams, SharePoint and PowerPoint.

Knowledge and understanding of the data and information that is important to an academic institution.

Ability to establish and maintain effective working relationships with staff and to communicate effectively.

Must be able to work well under strict deadlines and have exceptional attention to detail.

Ability to manage multiple projects with shifting priorities in a fast-paced environment.

Must understand the significance of maintaining data integrity and confidentially with student records; knowledge of and adherence to FERPA regulations.

Preferred:

Exceptional organizational skills and experience managing and documenting complex projects.

Knowledge of higher education information systems such as Ellucian Banner and related data systems and repositories such as Salesforce, IPEDS, US News, and CSRDE.

Additional Comments Regarding Position

Limited overnight travel may be required to attend professional development conferences and meetings. Some weekend and evening activities may be required.

*This position may be eligible for limited remote telecommuting.

Please visit the College’s Telecommuting page and Academic Affairs divisional guidelines for more information: https://hr.cofc.edu/telecommuting/index.php.

Special Instructions to Applicants

Please complete the application to include all current and previous work history and education. A resume will not be accepted nor reviewed to determine if an applicant has met the qualifications for the position.

**Salary is commensurate with education/experience which exceeds the minimum requirements.

Offers of employment are contingent upon a successful background check.

 

All applications must be submitted online https://jobs.cofc.edu.

Salary

**$54,974 - $78,343

Posting Date

03/26/2024

Closing Date

04/19/2024

Benefits

  • Insurance: Health/Dental/Vision
  • Life Insurance
  • Paid Leave: Sick/Annual/Parental
  • Retirement
  • Long Term Disability
  • Paid Holidays
  • Free CARTA Bus Service
  • Employee Tuition Assistance Program (ETAP)
  • Employee Assistance Program (EAP)
  • Full Benefits Package – Click Here

Open Until Filled

No

Posting Number

2024045

EEO Statement

The College of Charleston is an Affirmative Action/Equal Opportunity employer and does not discriminate against any individual or group on the basis of gender, sexual orientation, gender identity or expression, age, race, color, religion, national origin, veteran status, genetic information, or disability.

Quicklink for Posting

https://jobs.cofc.edu/postings/15174

Job Duties

Job Duties

Activity

Designs and maintains database and reporting applications in various environments (i.e., SQLSAS) to run against the ERP system (Banner). Maintains and updates all Institutional Research data marts and scheduled processes to support external and internal decision support, accountability, and performance reporting needs. Monitors scheduled processes for successful completion and uses or sets up alerts for unsuccessful jobs. Analyzes current processes and procedures against best industry practices and to determine efficiencies or cost savings.

Essential or Marginal

Essential

Percent of Time

25

 

Activity

Designs and maintains complex systems for the extraction, compilation, analysis, processing and presentation of institutional data to fulfill annual IPEDS and SC CHE reporting requirements. Coordinates with the Assistant Director for Reporting and Data Management on successful generation and delivery of daily data integrity processing.

Essential or Marginal

Essential

Percent of Time

20

 

Activity

Works with the Executive Director and IR colleagues to design and maintain applications that utilize academic departmental data, finance, and human resource data from the College’s ERP system and other related data sources. Analyzes the reporting needs to determine the best data source and reporting tool. Develops data architecture and report structures in various formats including but not limited to Cognos, Argos, SAS and Tableau.

Essential or Marginal

Essential

Percent of Time

20

 

Activity

Maintains documentation (metadata) of all IR data architecture. Prepares flowcharts, block diagrams, and other documentation to illustrate programs and procedures and prepares user documentation. Routinely updates Tableau and Cognos/Argos report metadata and assists with archiving obsolete work.

Essential or Marginal

Essential

Percent of Time

15

 

Activity

Serves as a subject matter expert and resource for data stewards and on various implementation and integration projects (i.e. CRM Advise, PeopleAdmin, Salesforce.) Researches and reports on the impacts of system changes on the College’s data integrity and business processes. Guides the campus community on data standards and best practices in data management.

Essential or Marginal

Essential

Percent of Time

10

 

Activity

Supports and assists IR colleagues on projects such as: accreditation reporting; senior leadership and executive requests; maintaining the OIR website; and dashboard development and reporting using Tableau.

Essential or Marginal

Essential

Percent of Time

10

 

Salary

$54,974-$78,343