Employment Type:

Shift:

Description:

POSITION PURPOSE

Works closely with our business partners and development resources to design and develop Business Intelligence (BI) solutions and analytics strategies. Utilizes basic business knowledge to assist with developing the analytic requirements and recommendations for solving business needs with BI reporting tools including but not limited to SAP Business Objects Tableau and other analytic platforms. Builds a consultative partnership between the business areas and the Analytics and Data Warehouse organization and will act as an experienced consultant to business customers. Possesses domain specific business knowledge needed to provide moderate to complex ad-hoc reporting and analysis services and identifies areas for reporting consolidation and self-service opportunities. Ensures technical requirements necessary to fulfill data acquisition and reporting requests are identified documented and communicated to the appropriate development groups. Responsible for resolving support issues that have been escalated by the Business Intelligence Analyst I by other staff in Data Warehouse and Analytics or by business customers.

ESSENTIAL FUNCTIONS

• Provides advanced support for existing reports dashboards or other tools.
• Monitors issue tracking system (HEAT Clarity Quickbase others) acknowledges tickets and works towards resolution with customers vendors and developers.
• Provides data analysis and application support to internal customers
• Works with vendors to resolve complex issues.
• Maintains or updates business intelligence tools databases dashboards systems or methods.
• Works with end-users to develop skills in the areas of reporting querying and analytics.
• Provides communication to end-users regarding training opportunities availability of reporting tools roll-out of new capabilities enhancements etc.
• Serves as an escalation point for issues that cannot be resolved by first level support analysts.
• Assists and mentors BI Analyst I.
• Leads discussions with business owners to define business/functional requirements for development of new or improved capabilities and with developers to translate business requirements into technical requirements.
• Documents specifications for business intelligence or information technology reports dashboards or other outputs.
• Creates technical design documentation to ensure the accurate development of reporting solutions and participates in peer reviews of reporting solutions developed by other members of the Data Warehouse and Analytics team.
• Generates moderate to complex standard or custom reports summarizing business clinical or financial data for review by executives managers clients and other stakeholders.
• Works with power users to enable ad-hoc reporting with provided tools and analytical environment. Works with end-users to develop skills in the areas of reporting querying and analytics.
• Executes moderate to complex ad-hoc reporting.
• Understands SQL and writes simple SQL queries.
• Creates comprehensive test plans and test scripts. Executes and documents testing results for issues enhancements and new development.
• Provides input into user tool development to identify areas for improvement and enhanced self-service.
• Develops subject area knowledge specific to business functions such as Finance Revenue Clinical Supply Chain Marketing HR etc.
• Facilitates the creation of Service Level Agreements (SLAs) between Data Warehouse and Analytics and business customers. Follows all Service Management best practices including Change Management.
• Actively reinforces the vision and direction of the Data Warehouse and Analytics organization.
• Initiates opportunities to learn and grow. Handles multiple demands shifting priorities crises and rapid change.
• Cultivates working relationships within the Data Warehouse and Analytics organization and with the business units that are positive professional and collaborative.
• Knows understands incorporates and demonstrates the Trinity Health Mission Vision and Values in leadership behaviors practices and decisions.
• Maintains a working knowledge of applicable Federal State and local laws/regulations; the Trinity Health Integrity and Compliance Program and Code of Conduct; as well as other policies and procedures in order to ensure adherence in a manner that reflects honest ethical and professional behavior.
• Performs other duties as assigned.
• pay grade 13 range 75592..0581 Actual compensation will fall within the range but may vary based on factors such as experience qualifications education location licensure certification requirements and comparisons to colleagues in similar roles.

MINIMUM QUALIFICATIONS

Non-Clinical

• Bachelors degree in healthcare or information technology and a minimum of three (3) to five (5) years experience in information technology or an equivalent combination of education and experience.
• Minimum of three (3) years experience or equivalent training/education in ad-hoc reporting and analysis including:

• Experience with ad-hoc analysis and reporting tools (SAP Business Objects Tableau Qlikview etc.)
• Support or creation of reports scorecards dashboards using these tools
• Data warehouse concepts and querying including the ability to understand SQL and write simple SQL queries.
• Ability to crunch data taking complex sets of data and managing them via filters calculations etc.
• Minimum of one (1) to three (3) years experience using source system/transactional data from systems such as Cerner NextGen HealthQuest PeopleSoft Lawson Epic etc. as gained through the use or support of the application(s).
• Excellent organization analytical interpersonal written and verbal communication skills. Experience with project management is a plus.
• Must possess the ability to work in teams.
• Must be comfortable operating in a collaborative shared leadership environment.
• A personal presence which is characterized by a sense of honesty integrity and caring with the ability to inspire and motivate others to promote the philosophy mission vision goals and values of Trinity Health.

MINIMUM QUALIFICATIONS

Clinical

• Bachelors degree in healthcare or information technology and a minimum of three (3) to five (5) years experience in information technology health information management or clinical or an equivalent combination of education and/or experience.
• Minimum of three (3) years experience or equivalent training/education in ad-hoc reporting and analysis including:
• Experience with ad-hoc analysis and reporting tools (SAP Business Objects Tableau Qlikview etc.)
• Support or creation of reports scorecards dashboards using these tools
• Data warehouse concepts and querying including the ability to understand SQL and write simple SQL queries.
• Ability to crunch data taking complex sets of data and managing them via filters calculations etc.
• Minimum of one to three (3) years experience using source system/transactional data from systems such as Cerner NextGen HealthQuest PeopleSoft Lawson Epic etc. as gained through the use or support of the application(s).
• Experience with clinical coding measures or regulatory requirements in the healthcare arena.
• Excellent organization analytical interpersonal written and verbal communication skills. Experience with project management is a plus.
• Must possess the ability to work in teams.
• Must be comfortable operating in a collaborative shared leadership environment.
• A personal presence which is characterized by a sense of honesty integrity and caring with the ability to inspire and motivate others to promote the philosophy mission vision goals and values of Trinity Health.

PHYSICAL AND MENTAL REQUIREMENTS AND WORKING CONDITIONS

• This position operates in a typical office environment. The area is well-lit temperature-controlled and free from hazards.
• Incumbent communicates frequently in person and over the telephone with people in a number of different locations on technical issues.
• Manual dexterity is needed in order to operate a keyboard. Hearing is needed for extensive telephone and in person communications.
• The environment in which the incumbent will work requires the ability to concentrate meet deadlines work on several projects at the same period and adapt to interruptions.
• The incumbent must be capable of traveling in the course of completing project assignments.

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of duties so assigned.

Our Commitment

Rooted in our Mission and Core Values we honor the dignity of every person and recognize the unique perspectives experiences and talents each colleague brings. By finding common ground and embracing our differences we grow stronger together and deliver more compassionate person-centered care. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin disability veteran status or any other status protected by federal state or local law.