Institutional Research Data Architect*

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.
Job Duties Activity Designs and maintains database and reporting applications in various environments (i.
e.
, SQL, SAS) 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