Job Title: Data/Business System Analyst
Location: Case Main Campus
Full/Part Time: Full-Time
Job ID: 8888
Job Description POSITION OBJECTIVE
Working with a high degree of independence and under general supervision, this person will provide ongoing support for the federally-mandated reporting requirements of the Cancer Center Support Grant (CCSG) of the Case Comprehensive Cancer Center. The Data Coordinator/Analyst will be responsible for a variety of tasks in translating business and operational requirements into SQL-based database reports, standardized operational procedures, and workable IT and administrative solutions. This person will collect, organize, and report on Cancer Center data including, but not limited to, information about Cancer Center members’ grants, publications, events, internal funding, and community outreach. The Coordinator/Analyst will assist in developing better data coordination and management procedures, managing and creating reports for existing databases, and providing recommendations for strategic improvements to the Cancer Center’s data organization.
- Optimize the quality and use of the Cancer Center’s databases by staying current on enhancements to functionality. Maintain the overall integrity and quality of the membership, publication, and grant databases, including regular data improvement and cleaning. Identify and analyze ambiguous or conflicting work processes related to information management and reporting issues and lead improvement efforts. Train staff and faculty in the appropriate use of the existing functionality. (30%)Develop, refine, and maintain reports using available reporting tools (including SQL/JasperSoft) and NCI required templates, for a wide range of external and internal reports, Cancer Center program meetings and retreats, grant applications, and other research related activities. Analyze business rules, process requirements, and federally-mandated regulations to provide feedback on updating current software systems. Advise leadership on selecting additional information to be collected and organized to further the Cancer Center’s mission. (25%)Guide staff in the development and maintenance of tracking mechanisms and identifying new sources for information elements that will increase the value of the data maintained by the Cancer Center. Develop user manuals and standard operating procedures for existing and new information systems. Train staff members and Cancer Center leaders on how to use new applications. (15%)Manage Cancer Center membership application process. Provide recommendations for and implement improvements to this process. (10%)Oversee quality assurance procedures for existing data. Identify problems with current quality assurance systems. Develop and refine new business processes for these systems. (10%)
- Monitor and optimize performance of the databases. Plan for backup and recovery of database information and establishes guidelines for archiving data and maintaining archived data. (5%)Perform other duties as assigned. (5%)
Department: Daily contact with department staff to gather data reporting requirements and provide guidance on using databases or running reports.
University: Frequent contact with outside department administrators to gather and clean data to enter into the Cancer Center’s records.
External: Regular contact with outside consultants and administrators at other Cancer Centers to troubleshoot technologies and learn best practices for CCSG data gathering/reporting. Occasional attendance at national conferences to share our ideas and learn from other centers.
Students: Contact with students as needed to accomplish project objectives within the Cancer Center.
This position has no direct supervision of staff employees. This position may supervise student workers for short-term projects.
Experience: 1 to 3 years of experience in a similar role.
Education/Licensing: Bachelor’s degree required. Bachelor’s degree in Information Systems, Computer Science, Data Science/Analytics, or a related field preferred.
- Proficient use of SQL and relational database querying software to modify existing reports and create new ones. Ability to effectively communicate with technical data architects and operational leadership. Adaptability and flexibility to adjust to fluctuating changes in project needs. Comfort in navigating ambiguity with a can-do attitude, adaptable and quick learner, willingness to acquire and develop new skills as needed Must have excellent writing, organizational and quantitative skills. Must have excellent communication skills in order to lead and/or work effectively with teams as well as independently. Must be flexible and creative. Must be able to communicate well with a wide variety of stakeholders, including administrative staff, IT staff, faculty members, researchers, and software vendors. Must have demonstrated problem solving ability. Must be able to work under pressure while remaining attentive to detail. Must have established project management skills. Must be highly organized and a self-motivator. Must have a high degree of knowledge and experience with a range of software programs, such as Microsoft Office Suite and database programs. Must have sufficient technical capabilities to be able to establish new systems and enhance them as needed. Must have the capability to be proactive to assure smooth operations and maintain accurate records. Ability to meet consistent attendance. Ability to interact with colleagues, supervisors and customers face to face.
General office environment. The employee will perform repetitive motion using computer mouse and keyboard to type. Limited manual dexterity required. Work requires negligible physical exertion. Little or no exposure to hazards.
In employment, as in education, Case Western Reserve University is committed to Equal Opportunity and Diversity. Women, veterans, members of underrepresented minority groups, and individuals with disabilities are encouraged to apply.
Case Western Reserve University provides reasonable accommodations to applicants with disabilities. Applicants requiring a reasonable accommodation for any part of the application and hiring process should contact the Office of Equity at 216-368-3066 to request a reasonable accommodation. Determinations as to granting reasonable accommodations for any applicant will be made on a case-by-case basis.
We invite interested, qualified applicants to browse our website at jobs.case.edu for job ID 8888.