Business Intelligence Analyst III

5 months ago

Ann Arbor, United States Trinity Health Full time
POSITION DESCRIPTION:

The Business Intelligence (BI) Analyst III works on a fast-paced, innovative team within the Business Intelligence department to enable the use of actionable data by IHA business units. This is a highly versatile role at the intersection of people and technology, requiring the ability to explain and translate business requirements into technical specifications. BI Analysts collaborate with all areas of IHA medical group including administrative departments, specialty divisions, and executive leaders to understand goals to deliver vital information to support data-informed decision-making. The BI Analyst's role in data projects includes gathering requirements, working with developers to integrate and transform data, and working with customers to validate data. A large part of the role focuses on creating interactive visualizations in the form of dashboards and reports and explaining data trends and findings. Strong communication and interpersonal skills are crucial to this role in order to present meaningful data findings in an impactful, easy-to-understand manner. The BI Analyst team promotes a culture of data use throughout the organization by facilitating a community of analysts and providing end-user training, consultation, and office hours in support of self-service tools. May use statistics, machine learning and other data analysis techniques to provide relevant and useful data solutions.

ESSENTIAL JOB FUNCTIONS:
  1. Participates in strategic planning and roadmap design.
  2. Manages projects, including writing plans with tasks, resource requirements, accurate time estimates and deliverable timeline, and completion goals.
  3. Designs and enhances the logical and physical model for data sets through all phases, design to production support. Understands business use to retire obsolete data sets. Troubleshoots performance issues.
  4. Works with customers across IHA to gather requirements and translate business needs into solutions for complex data projects. Guides team members through the process.
  5. Helps to define and implement a shared support model for organizational data and analysis. Explains data governance roles and responsibilities for data. Suggests improvements based on observations and evaluating processes.
  6. Strives to improve and perform lead-level work on stretch assignments. Helps less-senior members with stretch goals and skill development.
  7. Mentors less-experienced members on the team and offers guidance and recommendations in team and customer discussions.
  8. Mentors and trains team members in a positive way to learn and improve. Actively seeks feedback and strives to increase work performance and skills.
  9. Trains team members on practical applications of data warehousing concepts, BI tools, ERP systems and medical group/physician practice operations and business processes.
  10. Designs training curriculum for end-user in-person and training videos. Supports and educates end-users on advanced use of tools, data sets, and complex reports.
  11. Helps team advance on plans for use of artificial intelligence, including Natural Language Processing, ChatGPT, predictive analytics, and leveraging machine learning to find hidden insights in data.
  12. Initiates self-guided learning to acquire new skills and identify software features or new technology to support the business. Implements new features and functionality to improve service and ensures team members can support.
  13. Creates and presents increasingly complex, interactive data visualizations and reports showcasing data insights that can easily be interpreted by non-technical staff.
  14. Creates and supports complex interactive visualizations, automated reports and ad hoc analyses using tools such as PowerBI, Tableau and SSRS to meet customer needs. Maintains large library of reports across multiple business areas.
  15. Creates, maintains and updates self-service data marts for end-users using SSAS Tabular model. Supports and educates end-users on use of data in SSAS Tabular models.
  16. Researches and implements improvements and new functionality. Seeks more efficient processes, including automation, and the use of artificial intelligence.
  17. Leads data validation and ensures customer sign off when reports are designed to customer specifications.
  18. Provides essential and timely information to BI and executive leadership through reporting tools and presentations.
  19. Creates clear documentation including specifications, data dictionaries and end-user training materials. Leverages business-defined data definitions to populate and update a central data catalog.
  20. Performs other duties as assigned.
ORGANIZATIONAL EXPECTATIONS:
  1. Creates a positive, professional, service-oriented work environment for staff, patients and family members by supporting the mission and values of both IHA and Trinity Health.
  2. Must be able to work effectively as a member of the Business Intelligence team.
  3. Assumes responsibility for performance of job duties in the safest possible manner, to assure personal safety and that of coworkers, and to report all preventable hazards and unsafe practices immediately to management.
  4. Successfully completes IHA's "The Customer" training and adheres to IHA's standard of promptly providing a high level of service and respect to internal or external customers.
  5. Maintains knowledge of and complies with IHA standards, policies and procedures.
  6. Maintains strict patient and employee confidentiality in compliance with IHA and HIPAA guidelines.
  7. Maintains complete knowledge of office services and in the use of all relevant office equipment, computer and manual systems.
  8. Serves as a role model by demonstrating exceptional ability to take on new and additional responsibilities. Embraces new ideas and respects cultural differences.
  9. Uses resources efficiently.
  10. Responsible for ongoing professional development - maintains appropriate licensure/certification and continuing education credentials, participates in available learning opportunities.
MEASURED BY:

Performance that meets or exceeds IHA CARES Values expectation as outlined in IHA Performance Review document, relative to position.

ESSENTIAL QUALIFICATIONS:

EDUCATION: Bachelor's degree or equivalent combination of education and relevant experience. Preferred field of study in data science, computer science, healthcare administration, public health, or finance. Master's degree preferred.

CREDENTIALS/LICENSURE: N/A

MINIMUM EXPERIENCE: 5 years' data analysis experience required. Healthcare or financial data analysis experience strongly preferred.

POSITION REQUIREMENTS (ABILITIES & SKILLS):
  1. Maintains a senior level of knowledge of data analytics technology, best practices and industry trends. Continuously seeks new data analytics knowledge.
  2. Has working knowledge of one or more of the following: healthcare codesets (ICD, CPT), performance measurement (quality, cost, and utilization metrics), financial and billing data.
  3. Demonstrated advanced level SQL coding skills. Ability to utilize stored procedures and SSIS packages.
  4. Demonstrated expertise and knowledge in data warehousing, database structures and relationships between entities. Can design, develop, and test database structures.
  5. demonstrate strong data analysis skills, learned through years of experience on a variety of complex data projects.
  6. Experience with one or more aspects of artificial intelligence such as: advanced analytics, machine learning, predictive analytics, natural language processing, ChatGPT or augmented analytics tools.
  7. Understands data governance principles, master data management, role-based security, and data quality principles. Experienced in Microsoft SQL Server Data Quality Services or Master Data Services is a plus.
  8. Advanced level knowledge of relational or dimensional databases as used in SSAS Tabular models, Power BI data models, or equivalent market products.
  9. Demonstrated contribution to all stages of BI project work (requirement gathering, design, implementation, testing and deployment).
  10. Experience with EHR - Epic Patient Care System, and the underlying data and reporting within - reports and Clarity and Caboodle as data sources.
  11. Proficient in operating a standard desktop and Windows-based computer system, including, but not limited to, MS365, Microsoft Excel, SQL Server Management Server (SSMS), database connections and troubleshooting. Experience with business intelligence products (Tableau, PowerBI, SSRS, Business Objects, or other reporting software). Ability to use other software as required while performing the essential functions of the job.
  12. Initiates self-guided learning to acquire new skills and identify new technology to support the business.
  13. Advanced knowledge and experience using analytic, reporting, and data visualization tools such SSRS, Business Objects, Power BI, or Tableau.
  14. Excellent communication skills in both written and verbal forms, including proper in-office chat and videoconferencing (MS Teams, Slack and Zoom) etiquette. Ability to speak before groups of people, either in-person or virtually.
  15. Strong communication and interpersonal skills are crucial to this role in order to present meaningful data findings in an impactful, easy-to-understand manner.
  16. Through innovation and new technology, ability to find ways to improve the end-user experience and alleviate the technical burden on patient-facing staff.
  17. This is a highly versatile role at the intersection of people and technology, requiring the ability to explain and translate business requirements into technical specifications.
  18. Ability to design project plans and working experience in all stages of BI project work (requirement gathering, design, implementation, testing and deployment). Able to make recommendations to improve project outcomes.
  19. Ability to serve as lead or project manager to implement and support major organizational business intelligence initiatives.
  20. Strong skills and experience in creative and analytical approach to complex issues. Demonstrated problem solving skills, with ability to consider and implement new ideas and solutions. Always considers and seeks to improve end-user experience in solutions.
  21. Able to facilitate a group discussion, effectively manage meetings and reconcile differing points of view to make decisions on difficult project issues.
  22. Ability to work effectively with various levels of organizational members and diverse populations including IHA staff, senior management, division heads, providers, patients, family members, outside customers, vendors, hospitals and community groups.
  23. Excellent organizational and time management skills to effectively juggle multiple priorities and meet deadlines.
  24. Works well in a fast-paced environment facing multiple priorities and quick turnaround times.
  25. Ability to handle patient and organizational information in a confidential manner.
  26. Ability to drive to other office/practice sites and meeting and training locations.
  27. Successful completion of IHA competency-based program within introductory and training period.

  • Business Intelligence Analyst III

    4 weeks ago

    Ann Arbor, Michigan, United States Trinity Health Full time

    Job Title: Business Intelligence Analyst IIIJob Summary:We are seeking a highly skilled Business Intelligence Analyst III to join our team at Trinity Health. As a key member of our Business Intelligence department, you will play a critical role in enabling the use of actionable data by our business units.Key Responsibilities:Collaborate with cross-functional...

  • Business Intelligence Analyst Lead

    4 weeks ago

    Ann Arbor, Michigan, United States Trinity Health Full time

    Job Title: Business Intelligence Analyst LeadJob Summary:The Business Intelligence Analyst Lead will play a key role in providing data and reporting to support Trinity Health's pursuit of the Quadruple Aim. This individual will lead efforts to model, build, validate, and document an enterprise data warehouse containing multiple types of healthcare data.Key...

  • Business Intelligence Analyst Lead

    4 weeks ago

    Ann Arbor, Michigan, United States Trinity Health Full time

    Job SummaryWe are seeking a highly skilled Business Intelligence Analyst Lead to join our team at Trinity Health. As a key member of our Business Intelligence Department, you will play a critical role in enabling the use of actionable data by our business units.Key ResponsibilitiesLead the implementation and support of major organizational business...

  • Business Intelligence Analyst Lead

    4 weeks ago

    Ann Arbor, Michigan, United States Trinity Health Full time

    Job SummaryAs a Business Intelligence Analyst Lead at Trinity Health, you will play a key role in enabling the use of actionable data by our business units. This is a highly versatile role that requires the ability to explain and translate business requirements into technical specifications.Key ResponsibilitiesServe as lead to implement and support major...

  • Business Intelligence Analyst Lead

    2 months ago

    Ann Arbor, United States Trinity Health Full time

    This is a hybrid role that requires some days on-site in Ann Arbor. POSITION DESCRIPTION: The Business Intelligence (BI) Analyst Lead works on a fast-paced, innovative team in the Business Intelligence Department to enable the use of actionable data by IHA business units. This is a highly versatile role at the intersection of people and technology,...

  • Senior Business Intelligence Analyst

    1 week ago

    Ann Arbor, Michigan, United States University of Michigan Full time

    Job SummaryThe Finance Analytics team at the University of Michigan seeks a highly skilled Senior Business Intelligence Analyst to support the Insurance and Claims Administration department. This role is responsible for designing, developing, and maintaining advanced data solutions that facilitate informed, data-driven decision-making.By leveraging Risk...

  • Business Intelligence Consultant

    4 weeks ago

    Ann Arbor, Michigan, United States DesignMind Full time

    Job Title: Business Intelligence ConsultantWe are seeking a highly skilled Business Intelligence Consultant to join our team at DesignMind. As a Business Intelligence Consultant, you will play a key role in delivering client engagements across various industries, utilizing your expertise in data analysis, visualization, and business intelligence.Key...

  • Intelligence Systems Engineer/Analyst

    1 week ago

    Ann Arbor, Michigan, United States MITRE Full time

    At MITRE, we're committed to tackling our nation's toughest challenges and creating a better future for all. As an Intelligence Systems Engineer/Analyst, you'll play a critical role in enhancing our sponsor's capabilities to advance and accelerate predictive, actionable, and timely decision support across their organization.This is a fast-paced, dynamic...

  • Business Systems Analyst Sr

    3 days ago

    Ann Arbor, Michigan, United States University of Michigan Full time

    Job SummaryThe University of Michigan is seeking a highly skilled Business Systems Analyst Sr to join its team. As a key member of the Financial Systems team, you will be responsible for delivering enterprise-level reporting and business intelligence systems, managing concurrent high-visibility projects, and guiding data stewardship.Key Responsibilities...

  • Data Analyst

    6 days ago

    Ann Arbor, Michigan, United States 1000 KLA Corporation Full time

    Job SummaryKLA Corporation is seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will be responsible for analyzing and interpreting complex data to inform business decisions.Key ResponsibilitiesDevelop and maintain advanced data models and algorithms to support business intelligence initiatives.Analyze large datasets to identify...

  • Business Portfolio Analyst/Manager

    6 days ago

    Ann Arbor, Michigan, United States Sartorius AG Full time

    Business Portfolio Analyst/ManagerWe are seeking a Business Portfolio Analyst/Manager to play a key role in managing our product innovation portfolio.This role is crucial in shaping and executing our innovation strategy by collaborating with Market Intelligence, Product Development, and Finance teams.You will provide insightful portfolio reviews and...

  • IT Business Analyst

    3 weeks ago

    Ann Arbor, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are looking for an IT Business Analyst to join our team in Ann Arbor, Michigan. This role involves the crucial task of identifying, refining, and validating complex business requirements alongside managing interdependencies and potential risks associated with technology projects. The position offers a long-term contract...

  • Business Systems Analyst Sr

    2 weeks ago

    Ann Arbor, Michigan, United States University of Michigan Full time

    Job SummaryMichigan Medicine is seeking a highly skilled Business Systems Analyst Sr to join our Financial Systems team. As a key member of our team, you will be responsible for delivering enterprise-level reporting and business intelligence systems, managing concurrent high-visibility projects, and guiding data stewardship.ResponsibilitiesEnsure data...

  • Business Portfolio Analyst/Manager

    3 days ago

    Ann Arbor, Michigan, United States Sartorius AG Full time

    Business Portfolio Analyst/ManagerWe are a forward-thinking life sciences company dedicated to innovation and excellence. Our company is seeking a Business Portfolio Analyst/Manager to play a key role in managing our product innovation portfolio. This role is crucial in shaping and executing our innovation strategy by collaborating with Market Intelligence,...

  • IT Business Analyst

    3 weeks ago

    Ann Arbor, United States Robert Half Full time

    Description We are looking for an IT Business Analyst to join our team in Ann Arbor, Michigan. This role involves the crucial task of identifying, refining, and validating complex business requirements alongside managing interdependencies and potential risks associated with technology projects. The position offers a long-term contract employment...

  • Senior Business Intelligence Solutions Architect

    3 weeks ago

    Ann Arbor, Michigan, United States University of Michigan Full time

    Job SummaryThe University of Michigan is seeking a highly skilled Senior Business Intelligence Solutions Architect to join our team. As a key member of our Financial Systems team, you will be responsible for designing, developing, and implementing enterprise-level reporting solutions that integrate our cloud-hosted reporting applications and data...

  • Senior IT Business Analyst

    4 weeks ago

    Ann Arbor, Michigan, United States RealTruck Full time

    Job Title: Senior IT Business AnalystAt RealTruck, we are seeking a highly skilled Senior IT Business Analyst to join our team. As a Senior IT Business Analyst, you will be responsible for analyzing business needs and recommending IT solutions to support the company's strategic goals.Key Responsibilities:Analyze business requirements and develop technical...

  • Business Systems Analyst

    3 weeks ago

    Ann Arbor, Michigan, United States KLA Full time

    Job Title: Business Systems AnalystWe are seeking a highly skilled Business Systems Analyst to join our team at KLA. As a Business Systems Analyst, you will play a critical role in collecting, analyzing, and summarizing data to support our supply chain business decisions.Key Responsibilities:Gather business requirements and resolve data and reporting...

  • Epic Business Systems Analyst

    1 month ago

    Ann Arbor, Michigan, United States ICONMA Full time

    Job Title: Epic Business Systems AnalystWe are seeking a highly skilled Epic Business Systems Analyst to join our team at ICONMA. The successful candidate will be responsible for building work to prepare for a go-live event.Key Responsibilities:Experience with Willow Ambulatory implementation is required.Experience with Epic systems is essential.Strong...

  • Senior IT Business Analyst

    1 month ago

    Ann Arbor, Michigan, United States RealTruck Full time

    Job Title: Senior IT Business AnalystWe are seeking a highly skilled Senior IT Business Analyst to join our team at RealTruck. As a key member of our organization, you will be responsible for analyzing business needs and recommending IT solutions to drive business growth and improvement.Key Responsibilities:Interface with various departments to identify and...