Children's National Medical Center
Senior Financial Data Analyst
Children's National Medical Center, Silver Spring, Maryland, United States, 20900
Job DescriptionProject Duration: 24 monthsOur Grants Accounting Team is responsible for managing financial data for sponsored and non-sponsored programs, ensuring transparency, and compliance. The Senior Grants Financial Data Analyst is primarily responsible for Commitment Accounting (payroll and effort) responsibilities, grant financials reconciliation, and compliance analysis. In addition, the Senior Grants Financial Data Analyst assists the Team Lead, providing support and coverage in areas relating to audits, training efforts, monitoring, and reporting. This position works under the guidance of the Grants Accounting Team Lead and regularly gives reports to, and advises, senior leadership in the Office of Grants and Contracts Administration and Finance on relevant business process redesigns and assists on business office projects as assigned.Qualifications
Minimum EducationBachelor's Degree Finance, Accounting, Business Administration, or a related field (Required)Minimum Work Experience3 years related progressive experience in data analysis and/or preferably sponsored post award financial matters (Required)Required Skills/KnowledgeAdvanced Excel skills with a proven ability to manipulate and interpret complex financial data.Must complete an Excel assessment and demonstrate advanced Excel skills.Proficiency in financial analysis tools and data visualization software required.Strong attention to detail and commitment to accurate data management.Excellent communication and collaboration skills to work effectively within a team.Problem-solving mindset and ability to troubleshoot financial discrepancies.Analytical skills and knowledge of financial analysis techniques.Ability to think critically, multi-task, and prioritize projects.Self-motivated and intuitive thinker.Thorough understanding of office systems, including interfaces between systems.Working knowledge of PeopleSoft HCM and Finance and query development.Working knowledge of Huron Effort Certification (eCrt) system.Ability to prepare ad-hoc reports.Proficiency in managing and understanding data, including various grant and contract-related data.Familiarity with regulations governing grants and contracts.Ability to communicate effectively with process stakeholders.Functional Accountabilities
Payroll & Effort; Allocation ManagementDemonstrate a deep understanding of commitment accounting principles, with a focus on payroll and effort allocation, to accurately track grant expenditures.Collaborate with project managers, HR, and other stakeholders to ensure precise recording of payroll expenses and effort allocations for each grant.Support biweekly payroll processing.Maintain and update employee salary and effort allocations.Perform and oversee manual adjustments to financial data, ensuring the accuracy and integrity of grant commitments, expenses, and effort allocations.Conduct comprehensive reviews of payroll and effort adjustments, ensuring compliance with grant regulations and internal policies.Work closely with the HR team to validate payroll distributions aligned with approved budgets and project activities.Data Analysis & ReportingUtilize advanced Excel skills to conduct thorough data analysis related to grants and generate insightful reports to monitor spending, commitments, and project progress.Independently identify and explain significant trends or deviations of financial data.Present findings in a clear and organized manner to stakeholders and management.Perform periodic quality assurance checks on financial data to maintain data accuracy and integrity.Address ad hoc data requests from management and funding agencies, providing valuable insights in a timely manner.Subject Matter Expertise & Process ImprovementWork extensively in PeopleSoft Human Capital Management (HCM) and Finance modules, as well as Huron Effort Certification (ECRT) system and make daily use of the system to generate queries, reports, and carry out business-critical processes.Collaborate effectively with cross-functional teams, including Grants Management, HR, and Finance, to ensure seamless grant financial processes.Gain basic knowledge of the applicable OMB Circulars and other Federal regulations pertinent to grants and contracts accounting and undergo necessary training to stay up-to-date with these regulations.As a subject matter expert, contribute to system & process development and improvement discussion, planning, and testing.Work both independently and collaboratively to develop and facilitate training for GCAF.Audits & Special ProjectsInteract with Principal Investigators, Department Administrators, and provide analytical support to CNRI post-award financial management teams and leadership.Compile audit documentation requested for the Annual Single Audit (formerly A-133 audit), any sponsor audits and internal audit reviews, to assist with Annual Audit and Desk audits as needed.Prepare meeting agendas, and run meetings where Team Lead cannot be present, or in your capacity as a subject matter expert.Take on special projects to assist with the financial management of the CRI grants and contracts portfolio.Organizational AccountabilitiesOffice SupportComplete temporary projects and assignments as needed.Perform other duties as assigned.Organizational Commitment/IdentificationPartner in the mission and upholds the core principles of the organizationCommitted to diversity and recognizes value of cultural ethnic differencesDemonstrate personal and professional integrityMaintain confidentiality at all timesCustomer ServiceAnticipate and responds to customer needs; follows up until needs are metTeamwork/CommunicationDemonstrate collaborative and respectful behaviorPartner with all team members to achieve goalsReceptive to others’ ideas and opinionsPerformance Improvement/Problem-solvingContribute to a positive work environmentDemonstrate flexibility and willingness to changeIdentify opportunities to improve clinical and administrative processesMake appropriate decisions, using sound judgmentUse resources efficientlySearch for less costly ways of doing thingsPrimary Location
Maryland-Silver SpringWork Locations
Tech Hill 12211 Plum Orchard Drive Silver Spring 20904Job
Non-Clinical ProfessionalOrganization
Office Grants Contracts FinancePosition Status: R (Regular) - FT - Full-TimeShift: DayWork Schedule: 9-5Job Posting
Sep 15, 2024, 10:17:09 PMFull-Time Salary Range
57200 - 95347.2Childrens National Hospital is an equal opportunity employer that evaluates qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender, identity, or other characteristics protected by law.Please note that it is the policy of Children's National Hospital to ensure a “drug-free” work environment: a workplace free from the illegal use, possession or distribution of controlled substances (as defined in the Controlled Substances Act), or the misuse of legal substances, by all staff (management, employees and contractors).
#J-18808-Ljbffr
Minimum EducationBachelor's Degree Finance, Accounting, Business Administration, or a related field (Required)Minimum Work Experience3 years related progressive experience in data analysis and/or preferably sponsored post award financial matters (Required)Required Skills/KnowledgeAdvanced Excel skills with a proven ability to manipulate and interpret complex financial data.Must complete an Excel assessment and demonstrate advanced Excel skills.Proficiency in financial analysis tools and data visualization software required.Strong attention to detail and commitment to accurate data management.Excellent communication and collaboration skills to work effectively within a team.Problem-solving mindset and ability to troubleshoot financial discrepancies.Analytical skills and knowledge of financial analysis techniques.Ability to think critically, multi-task, and prioritize projects.Self-motivated and intuitive thinker.Thorough understanding of office systems, including interfaces between systems.Working knowledge of PeopleSoft HCM and Finance and query development.Working knowledge of Huron Effort Certification (eCrt) system.Ability to prepare ad-hoc reports.Proficiency in managing and understanding data, including various grant and contract-related data.Familiarity with regulations governing grants and contracts.Ability to communicate effectively with process stakeholders.Functional Accountabilities
Payroll & Effort; Allocation ManagementDemonstrate a deep understanding of commitment accounting principles, with a focus on payroll and effort allocation, to accurately track grant expenditures.Collaborate with project managers, HR, and other stakeholders to ensure precise recording of payroll expenses and effort allocations for each grant.Support biweekly payroll processing.Maintain and update employee salary and effort allocations.Perform and oversee manual adjustments to financial data, ensuring the accuracy and integrity of grant commitments, expenses, and effort allocations.Conduct comprehensive reviews of payroll and effort adjustments, ensuring compliance with grant regulations and internal policies.Work closely with the HR team to validate payroll distributions aligned with approved budgets and project activities.Data Analysis & ReportingUtilize advanced Excel skills to conduct thorough data analysis related to grants and generate insightful reports to monitor spending, commitments, and project progress.Independently identify and explain significant trends or deviations of financial data.Present findings in a clear and organized manner to stakeholders and management.Perform periodic quality assurance checks on financial data to maintain data accuracy and integrity.Address ad hoc data requests from management and funding agencies, providing valuable insights in a timely manner.Subject Matter Expertise & Process ImprovementWork extensively in PeopleSoft Human Capital Management (HCM) and Finance modules, as well as Huron Effort Certification (ECRT) system and make daily use of the system to generate queries, reports, and carry out business-critical processes.Collaborate effectively with cross-functional teams, including Grants Management, HR, and Finance, to ensure seamless grant financial processes.Gain basic knowledge of the applicable OMB Circulars and other Federal regulations pertinent to grants and contracts accounting and undergo necessary training to stay up-to-date with these regulations.As a subject matter expert, contribute to system & process development and improvement discussion, planning, and testing.Work both independently and collaboratively to develop and facilitate training for GCAF.Audits & Special ProjectsInteract with Principal Investigators, Department Administrators, and provide analytical support to CNRI post-award financial management teams and leadership.Compile audit documentation requested for the Annual Single Audit (formerly A-133 audit), any sponsor audits and internal audit reviews, to assist with Annual Audit and Desk audits as needed.Prepare meeting agendas, and run meetings where Team Lead cannot be present, or in your capacity as a subject matter expert.Take on special projects to assist with the financial management of the CRI grants and contracts portfolio.Organizational AccountabilitiesOffice SupportComplete temporary projects and assignments as needed.Perform other duties as assigned.Organizational Commitment/IdentificationPartner in the mission and upholds the core principles of the organizationCommitted to diversity and recognizes value of cultural ethnic differencesDemonstrate personal and professional integrityMaintain confidentiality at all timesCustomer ServiceAnticipate and responds to customer needs; follows up until needs are metTeamwork/CommunicationDemonstrate collaborative and respectful behaviorPartner with all team members to achieve goalsReceptive to others’ ideas and opinionsPerformance Improvement/Problem-solvingContribute to a positive work environmentDemonstrate flexibility and willingness to changeIdentify opportunities to improve clinical and administrative processesMake appropriate decisions, using sound judgmentUse resources efficientlySearch for less costly ways of doing thingsPrimary Location
Maryland-Silver SpringWork Locations
Tech Hill 12211 Plum Orchard Drive Silver Spring 20904Job
Non-Clinical ProfessionalOrganization
Office Grants Contracts FinancePosition Status: R (Regular) - FT - Full-TimeShift: DayWork Schedule: 9-5Job Posting
Sep 15, 2024, 10:17:09 PMFull-Time Salary Range
57200 - 95347.2Childrens National Hospital is an equal opportunity employer that evaluates qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender, identity, or other characteristics protected by law.Please note that it is the policy of Children's National Hospital to ensure a “drug-free” work environment: a workplace free from the illegal use, possession or distribution of controlled substances (as defined in the Controlled Substances Act), or the misuse of legal substances, by all staff (management, employees and contractors).
#J-18808-Ljbffr