Financial Services Reporting Analyst

CommonSpirit Health was formed by the alignment of Catholic Health Initiatives (CHI) and Dignity Health. With more than 700 care sites across the U.S. from clinics and hospitals to home-based care and virtual care services CommonSpirit is accessible to nearly one out of every four U.S. residents. Our world needs compassion like never before. Our communities need caring and our families need protection. With our combined resources CommonSpirit is committed to building healthy communities advocating for those who are poor and vulnerable and innovating how and where healing can happen both inside our hospitals and out in the community.

Job Summary:

The Reporting Analyst, Financial Services position will be responsible for assessing and supporting reporting needs for Financial Services (AP and Payroll). The  position will be responsible for all AP / Payroll reports - regulatory, compliance, audits, time records, legal requests, pay and deduction reports, W2s, 1099s, contractor data, spend and volume analysis, KPIs, internal/external requests, projects, value capture analysis, etc. This position and will also help develop the right strategy for reporting tools for delivery and visualization of various reports that enable reusability and self-service for the requestors. They should have ERP experience in AP / Payroll areas with ability to identify the data sources, relationships and leveraging that to publish reports using SQL queries and various visualization tools like Tableau, Power BI, Looker, etc. 

This position will frequently work on multiple reporting needs and will need to possess and apply strong understanding of a requirements gathering, data analysis and visualization of reports that fulfill the stakeholder’s needs. 

Accountabilities:       

• Keep abreast of the full cycle business processes for Financial Services with focus on analytics and reporting for AP and Payroll using various tools for data gathering, report creation and visualization
• Enable self-service and reusability of reports by parameterization, appropriate filters and leveraging various visualization platforms
• Manage creation and maintenance of dashboards for AP and Payroll to showcase metrics like regulatory, compliance, audits, time records, legal requests, pay and deduction reports, W2s, 1099s, contractor data, spend and volume analysis, KPIs, internal/external requests, projects, value capture analysis, etc.
• Design business analysis and data recording systems for use throughout the department
• Regularly examine data reports to locate and resolve any issues throughout the flow
• Accurately analyze and collect data for various types of business reports
• Create business reports that provide insight into key data points
• Communicate the results of data analysis in written and verbal form to managers
• Work with stakeholders to understand and document reporting requirements. The focus will be to improve the usability and profitability of current system architecture while identifying additional process improvement and automation opportunities.
• Develop implementation plan that aligns with business operations and IT priorities and bandwidth. Ensures that the work is done properly and within the time limit.
• Test and review the solution that was developed to ensure it meets initial requirements and issues are identified immediately. Coordinate appropriate remediation with project team and stakeholders prior to implementation.
• Work with department managers to research new functionality, identify potential process improvements, identify potential solutions, and define expected results
• Facilitate training of end users on deployed solutions
• Assist with all department goals and initiatives relative to service management process improvements

Minimum Requirements:

5 years’ experience in analytics and reporting using various tools like SQL, Crystal Reporting, Power BI, Tableau, Looker, Qlikview and other tools  
Experience in ERP environment in either AP / Payroll or both, preferably in Lawson ERP 
One to three years of experience as a financial or business analyst
Analytical skills that allow for the development of data-driven reports
Demonstrated ability to manage time and prioritize projects to meet deadlines
Ability to use SQL and Microsoft Excel to create pivot tables, graphs and charts
Excellent critical thinking skills to help solve business problems and make decisions
Tendency to pay close attention to small details that could impact results
General knowledge of business operations, objectives, strategies, process and information flow
Demonstrated high level analytical and quantitative skills
. 
Preferred/Desired:

Experience in a multi-facility large healthcare organization.
Experience with various reporting tools 
Experience with high level advance reporting and advanced excel functions for data analysis 

Education

Bachelor’s Degree in Business Administration, Finance, or related field.
Certification/degree in information or technical systems

Special Knowledge, Skills, Abilities

Strong organizational skills and ability to follow up with the internal and external customers.
Detail-oriented and ability to solve problems in a fast paced environment.
Ability to multi-task and handle multiple issues simultaneously.
Ability to prioritize competing priorities with multiple deadlines
Ability to work independently and under tight deadlines.
Strong computer skills, especially advanced Microsoft Excel skills including, Add Ins and Ad Hoc query analysis.
Ability to see the bigger picture and think through the entire process before making recommendations or decisions.