Reporting and Analytics Analyst

Job Description:

• Provide customer support to current users through analysis, report creation, report maintenance, and custom data requests
• Design analytical approaches and communicate insights through reports, dashboards, presentations, and storytelling
• Consume and interpret datasets from multiple sources to support performance optimization, goal setting, and strategic decisions
• Create Tableau data sources and reports using the RAE database
• Analyze and mine financial and research operations data for the cancer research program
• Create financial analytical reports, scorecards, and summaries for Comprehensive Cancer Center programs, membership, departments, and divisions
• Maintain spreadsheets and funding databases for supported recruits, Intramural Research Awards, Pelotonia Scholarship Awards, CCC Funding, and new CCC databases
• Validate data accuracy, consistency, and appropriate use in reports
• Coordinate with IT and Finance teams on database creation and maintenance
• Support General Ledger reporting, CCC financial reconciliation, and budgeting processes
• Assist with monthly, quarterly, and annual budget-to-actual analysis, forecasting, and variance analysis
• Create and maintain monthly and quarterly reports for CCC leadership
• Maintain and update the CCC Workday Tag mapping dashboard
• Create and review progress reports and analyze financials and grants for programmatic ROI reporting
• Collect data from PI Portal, NIH Reporter, and PubMed
• Prepare customized reports and support special projects
• Provide financial management, budgeting, reporting, and other financial services to faculty and Cost Center Managers
• Perform other analysis and reporting as assigned

Requirements:

• Bachelor’s Degree in relevant field
• 2 years of relevant experience required
• 2–4 years of relevant experience preferred
• Equivalent combination of education and experience accepted
• Strong analytical skills
• Strong computer skills
• Ability to manage time efficiently and complete multiple tasks with competing deadlines
• Proficiency in Excel, Access, Tableau, and Microsoft Office desired
• Knowledge of the general ledger and SQL desirable
• Successful completion of a background check required for final candidates
• Drug screen or physical may be required during the post-offer process

Benefits:

• Regular position
• 40 scheduled hours per week
• First shift
• Equal opportunity employer, including veterans and disability