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 customersWorks 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 75,592.7054-113,389.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
Bachelor's 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 toolsData 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
Bachelor's 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 toolsData 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.