Business Intelligence and Data Warehouse Analyst - Charleston, SC

[lisaspace]

The Citadel, The Military College of South Carolina, located in Charleston, South Carolina invites applications for a Business Intelligence and Data Warehouse Analyst in the Office of Institutional Research. 

The successful candidate will work collaboratively with the college community in designing and extracting data and reports from the Enterprise Data Warehouse and Operational Data Store for projects.  Will be required to assist with the implementation, customization and maintenance of Ellucian's Recruiting and Admissions Performance (RAP) and Student Retention and Performance packages.

Will work to develop and deliver appropriate training to end-users to enable them to be self-sufficient in their use of Cognos reporting software.  Will be required to assist users in the interpretation and use of results extracted via reports.  Will assist the Cognos Administrator with the data reporting tool environment and processes, data source extract, transform and load (ETL) design and processes, reporting toolset configuration, implementation, and maintenance.

Will use expert-level knowledge of transactional and analytical data and processing to determine data capture and reporting solutions to best meet the College's goals; to possibly include complex programming analyses for a wide range of requests using data in different formats and from various platforms. Must be able to design dashboard metrics, reports, performance charts and scorecards, both for internal and external publication, to support the institution's strategic planning, assessment, and accreditation processes. 

Will design and perform the necessary operational and reconciliation tasks to ensure the quality, security and timeliness of the data in the data warehouse (EDW) as well as perform data validation, data cleansing and correction to ensure data integrity within the data warehouse.  Will maintain expertise in the enterprise data warehouse and business intelligence tool set and strategic product direction.

Qualifications:

The successful candidate must have a bachelor's degree and professional experience in a related field.   The individual must possess an extensive knowledge of specific computer software, including SQL, Cognos and Microsoft Office.  The individual should be familiar with institutional data and should have knowledge of various methods of data extraction, as well as data warehouse systems and accountability systems.  The individual must have a strong background in Business Intelligence development using Cognos, including Framework Manager, Report Studio and Metric Studio.  Must have the ability to analyze data and provide solutions to complex problems. The individual must be able to interpret the needs and policies of the institution and formulate procedures to effectively present information, both orally, electronic and in writing.  The individual must have the ability to collaborate on a team with infrastructure, data warehouse, and business analyst resources, and clearly communicate solutions to both technical and non-technical team members.

Previous experience with SunGard's Operational Data Store (ODS) and Enterprise Data Warehouse (EDW) preferred.  The individual must be able to work well under strict deadlines.   Previous experience in a higher education institution preferred.  Prefer experience with Oracle databases, data warehousing, database schemas design, and metadata management and documentation. Prefer IT development/systems configuration experience.

Additional Comments:

Military experience is not a requirement of this position, but the successful candidate will develop an understanding of the military character of The Citadel as an integral part of the college's identity. 

Applicants indicating college credit or degree(s) on the application may be required to present an official copy of the college transcript upon employment.

The Citadel is an affirmative action/equal opportunity employer actively committed to ensuring diversity in all campus employment.

To Apply:

Apply via the South Carolina E-Recruitment System: 
http://www.jobs.sc.gov/OHR/OHR-jobs-portal-index.phtm

Deadline for applications: Until Filled