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
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., 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
Located in the heart of historic downtown Charleston, South Carolina, the College of Charleston is a nationally recognized, public, liberal arts and sciences university. Our beautiful and historic campus, student-focused programs, and contemporary facilities attract approximately 11,000 students from across the region, U.S., and internationally. Our students are immersed in a collaborative and supportive environment that enables them to form great relationships with our faculty and staff. Colleagues from various backgrounds – private sector, armed forces, and other higher education institutions – form our diverse team, which includes over 500 distinguished teacher-scholars. If you share our core values and our goal to create an inclusive campus that inspires excellence and innovation, consider a career at the College of Charleston.