REMOTE Sr Data & Reporting Analyst
Job posting number: #7117268 (Ref:10018740)
Posted: January 27, 2023
Salary / Pay Rate: $40.70 - $63.08 / hour
Application Deadline: Open Until Filled
About City of Hope
City of Hope is an independent biomedical research and treatment organization for cancer, diabetes and other life-threatening diseases.
Founded in 1913, City of Hope is a leader in bone marrow transplantation and immunotherapy such as CAR T cell therapy. City of Hope’s translational research and personalized treatment protocols advance care throughout the world. Human synthetic insulin, monoclonal antibodies and numerous breakthrough cancer drugs are based on technology developed at the institution.AccessHope™, a subsidiary launched in 2019 serves employers and their health care partners by providing access to City of Hope’s specialized cancer expertise.
A National Cancer Institute-designated comprehensive cancer center and a founding member of the National Comprehensive Cancer Network, City of Hope is ranked among the nation’s “Best Hospitals” in cancer by U.S. News & World Report and received Magnet Recognition from the American Nurses Credentialing Center. Its main campus is located near Los Angeles, with additional locations throughout Southern California and in Arizona.
City of Hope’s commitment to Diversity, Equity and Inclusion
We believe diversity, equity and inclusion is key in serving our mission to provide compassionate patient care, drive innovative discovery, and advance vital education focused on eliminating cancer and diabetes in all of our communities. Our commitment to Diversity, Equity and Inclusion ensures we bring the full range of skills, perspectives, cultural backgrounds and experiences to our work -- and that our teams align with the people we serve in order to build trust and understanding.We are dedicated to fostering a community that embraces diversity - in ideas, backgrounds and perspectives; this is reflected in our work and represented in our people.
** This is a Fully Remote Opportunity. You may sit at any of the 48 States. Must be willing to work Pacific Hours **
City of Hope’s mission is to “turn hope into reality.”Focused on eliminating cancer, diabetes and other life-threatening illnesses, City of Hope has established itself as a world-class leader in transforming the future of health. Raising the philanthropic resources to fuel its leading-edge research, its exquisite and compassionate clinical care, and its advancement of biomedical education and training, is a vital component of the City of Hope model of success.Each member of the Office of Philanthropy is a stakeholder in this work, with personal accountability for his/her role in building a successful future of delivering new cures, treatments and education.
The Office of Philanthropy’s vision is to support this life-saving work by being known institutionally and nationally as a model of excellence among elite fundraising programs. Recent recruitments of nationally and internationally renowned faculty offer advancement leaders new opportunity for partnership among philanthropy, research and patient care.
To this end, we invest in our staff through the Team Activation Program (TAP) initiative. This initiative increases the effectiveness of our team through focused transparency & accountability, building trust within teams; training & development; celebrating innovation & risk taking; enhancing team communications and removing roadblocks to maximize activation. The TAP initiative ensures that the Office of Philanthropy is poised to move quickly, effectively and efficiently to maximize opportunities on behalf of City of Hope.
Under the supervision of the Manager of Finance and Administration, performing a variety of financial, operational, and administrative duties and analysis functions in support of the day-to-day operations for the Philanthropy Group. Assists in the resolving problems that have a significant impact on the overall goals for the City of Hope (COH) and the group. Has the ability to work independently and in groups and ensures the integrity of financial related reports and trends.
Key Responsibilities include:
- Compile, reconcile, analyze, summarize, and interpret accurate financial data for reports, trends, and presentations to all levels in the organization. Knowledge of GAAP, CASE, and/or other financial and fundraising performance reporting methodologies are helpful.
- Research and prepare variance analysis and explanations for commentary in management reports, financial reviews, and special projects critical to making business decisions. Primary focus is tracking fundraising/fundraiser performance reports, analysis, and trends from CRM; operating and capital expenses– actual vs. budget, historical trend, discretionary vs. non-discretionary, labor and non-labor expenses by VP or department from PeopleSoft; generation and maintenance of end to end dashboard consisting of contributions from CRM combined with expenses in PeopleSoft from the EDW data mart.
- Routine communication with Gift Administration and Corporate Accounting relating to revenue and expense processing, financial close, issues, and deliverables.
- Cross train, provide coaching and direction, and review work as requested by financial analyst, event budget analyst, financial reporting specialist, and temporary personnel in the department.
- Create and maintain detailed financial models and templates for actual, budget, projections, and forecasts.
- Identify, investigate, analyze, and cordially communicate to responsible areas reporting requirements, potential enhancement or improvement and any discrepancy among processes that should be tracked and monitored by others. Research current trends and implement measures and procedures that can help improve process flows for colleagues and others in the daily routine.
- Plan, evaluate, create, and maintain internal templates in the preparation and review of Philanthropy group’s annual operating budget to support and assist Corporate Finance.
- Train and work with staff members within Philanthropy group in running and understanding monthly reports; help resolve budget issues; interpret budget policies and procedures to various staff members.
- Annually assist in gathering data to complete various benchmarking surveys.
- Maintain key performance indicator in the system such as annual drive or campaign, fundraising designation and hierarchy that impacts fundraising performance; assign users to type of reports and departmental or projects to reports in PeopleSoft.
- Scope business needs and either independently develop adhoc queries in AccessHope or test ITS delivered queries in PeopleSoft in order to retrieve aggregated data needed for reports and analysis.
- Assist Manager of Finance and Data/Reporting Systems Analyst with maintaining Data Mart as primary tool for financial reports and analysis. Develop and maintain insightful financial metrics and reporting solutions for operational team as well as executive presentation using dashboards developed in Excel, Tableau, and other available tools.
- Perform special requests, projects, and other duties as assigned.
Basic education, experience and skills required for consideration:
- Bachelor’s Degree in accounting, finance or related field
- 4-8 years related experience in business or financial analysis in applying generally accepted accounting principles, personnel practices, and operational support.
- Proven experience in financial reporting producing a variety of reports using data migration skills including pivot tables, vlookup, macros, visual basics, or other data extraction methods.
Preferred education experience and skills:
- Experience in fundraising or event services.
- As a condition of employment, City of Hope requires staff to comply with all state and federal vaccination mandates.
Salary / Pay Rate Information:
Pay Rate: $40.70 - $63.08 / hour
The estimated pay scale represents the typical [salary/hourly] range City of Hope reasonably expects to pay for this position, with offers determined based on several factors which may include, but not be limited to, the candidate’s experience, expertise, skills, education, job scope, training, internal equity, geography/market, etc. This pay scale is subject to change from time to time.
City of Hope is a community of people characterized by our diversity of thought, background and approach, but tied together by our commitment to care for and cure those with cancer and other life-threatening diseases. The innovation that our diversity produces in the areas of research, treatment, philanthropy and education has made us national leaders in this fight. Our unique and diverse workforce provides us the ability to understand our patients' needs, deliver compassionate care and continue the quest for a cure for life-threatening diseases. At City of Hope, diversity and inclusion is a core value at the heart of our mission. We strive to create an inclusive workplace environment that engages all of our employees and provides them with opportunities to develop and grow, both personally and professionally. Each day brings an opportunity to strengthen our work, leverage our different perspectives and improve our patients’ experiences by learning from others. Diversity and inclusion is about much more than policies and campaigns. It is an integral part of who we are as an institution, how we operate and how we see our future.