Senior Consultant Finance - Mercy

We’re a Little Different

Our mission is clear. We bring to life a healing ministry through our compassionate care and exceptional service.

At Mercy, we believe in careers that match the unique gifts of unique individuals – careers that not only make the most of your skills and talents, but also your heart. Join us and discover why Modern Healthcare Magazine named us in its “Top 100 Places to Work.”

Overview:

The Senior Consultant Finance (Report Developer) is an emerging IT professional who analyzes, provides specifications for, and develops reports and dashboards that support the data initiatives for various departments across the Mercy healthcare system. The ideal candidate has experience with business intelligence and analytic tools such as ACL (Diligent), Oracle SQL Developer, SQL Server, SAP Business Objects, Microsoft PowerBI, and/or Workday custom reports. They should have experience with programming in SQL, R, Python, ACL or equivalent programming languages. The ideal candidate has proven experience with business and technical requirements analysis, elicitation, modeling, verification, and methodology development.  The developer will design, and plan automated analytical solutions, as well as debug, monitor, and troubleshoot those solutions. They will write relational database queries and has experience with data warehousing and data modeling. Forms productive relationships with end users by listening, clarifying, and responding effectively. Participates on project teams as well as working independently. Responsible for relationship with vendors and opening and coordinating issues with vendors. Responsible for writing fundamental documentation in a clear, concise manner, adhering to standards.

Qualifications:

• Education: Bachelor's Degree in Business Administration, Computer Science, Computer Information Systems or related field from an accredited college or university.
• Experience:Position requires a minimum 5 years financial analysis experience that MUST include at least 4 years of report or BI development experience.
• Other:
  • Advanced knowledge of scripting in ACL, SQL, Python, or R preferred
  • Previous experience using Workday custom report development tools preferred
  • Previous experience developing visualizations using Microsoft PowerBI preferred
  • Previous Clarity/Epic reporting is a plus
  • Demonstrated ability to work with leadership teams
  • Ability to frame analytical questions, perform analyses and communicate related results.
  • Computer literacy with intermediate skills in Microsoft Excel and PowerPoint.
  • Ability to work independently to meet project deadlines
  • Ability to work with and preserve confidential information
  • Healthcare experience preferred
  • Previous Workday payroll experience is a plus
  • Strong written and oral communication skills, including presentation skills
  • Proven ability to meet goals and work at a high-performance level
  • Ability to work within a team environment and interacting with management
  • Superior skills in the extraction, merging and transformation of large data sets across systems and databases environments

Responsibilities and Expectations

Successful candidates will perform a combination of the functions shown below, plus other duties as assigned.

• Develop data extracts, data models, stories, and reports using Power BI and/or ACL Data Analytics software from the Epic/Clarity EMR, Lawson ERP, Workday HCM, and UKG Dimensions Timekeeping databases.
• Create and interpret SQL queries using Oracle SQL Developer and/or Toad
• Collect and analyze business requirements and implement solutions
• Provide production and development support, monitoring and maintenance of schedule analytic jobs
• Create and execute project work plans, revising as necessary to meet changing needs and requirements
• Testing of analytic performance and accuracy before data source or application upgrades
• Evaluate and recommend new database and BI technologies
• Write clear and concise documentation for each analytic or report developed
• The ability to multitask in a fast-paced environment, especially the ability to meet tight deadlines
• Leads meetings to communicate necessary information and deliverables to process owners
• Individual will assist in mentoring and providing training related to business processes, tools and techniques used
• Assist co-workers in applying business analytic needs and concepts with the use of approved software

We Offer Great Benefits:

Day-one comprehensive health, vision and dental coverage, PTO, tuition reimbursement and employer-matched retirement funds are just a few of the great benefits offered to eligible co-workers, including those working 32 hours or more per pay period!

We’re bringing to life a healing ministry through compassionate care.

At Mercy, our supportive community will be behind you every step of your day, especially the tough ones. You will have opportunities to pioneer new models of care and transform the health care experience through advanced technology and innovative procedures. We’re expanding to help our communities grow. Join us and be a part of it all.

What Makes You a Good Match for Mercy?

Compassion and professionalism go hand-in-hand with us. Having a positive outlook and a strong sense of advocacy is in perfect step with our mission and vision. We’re also collaborative and unafraid to do a little extra to deliver excellent care – that’s just part of our commitment. If that sounds like a good fit for you, we encourage you to apply.

EEO/AA/Minorities/Females/Disabled/Veterans