Business Intelligence Analyst
Michigan Medicine · Ann Arbor, MI · 1 mo ago
Full-time
We need to output HTML fragment with sections: headings using for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to include only sections that have real specific content. The posting includes: Job Summary (could be About the role). Responsibilities (list). Required Qualifications (list). Education (Intermediate Level Qualifications and Senior Level Qualifications). Desired Qualifications (list). Why Join Michigan Medicine? (maybe About the role? but it's more about organization). Benefits: "What Benefits can you Look Forward to?" includes bullet points: Excellent medical, dental and vision coverage effective on your very first day; 2:1 Match on retirement savings; Modes of Work Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department... That's benefits info. Also there is Underfill Statement, Background Screening, Application Deadline, U-M EEO Statement - these are boilerplate to remove. Also "How to Apply" includes cover letter requirement - that's application instructions, should be removed. Also "Job Summary" is content.
We need to preserve all substantive information, not invent or summarize away detail. Remove boilerplate, duplicated lines, application instructions, EEO, etc.
We need to decide sections: About the role (Job Summary). Responsibilities. Requirements (maybe combine Required Qualifications and Education?). Qualifications (maybe Desired Qualifications). Skills? Could be part of qualifications. Benefits (What Benefits can you Look Forward to?). Pay? Not present. Schedule? Not present (though Modes of Work mentions hybrid/remote but that's more work arrangement, could be considered Schedule? But it's not explicit schedule like full-time/part-time. The instruction: never create Pay/Schedule/Benefits sections unless posting actually states them. Benefits is stated, so we include Benefits. Schedule not stated explicitly, so omit. Pay not stated, omit.
We need to use
for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to include only sections that have real specific content. The posting includes: Job Summary (could be About the role). Responsibilities (list). Required Qualifications (list). Education (Intermediate Level Qualifications and Senior Level Qualifications). Desired Qualifications (list). Why Join Michigan Medicine? (maybe About the role? but it's more about organization). Benefits: "What Benefits can you Look Forward to?" includes bullet points: Excellent medical, dental and vision coverage effective on your very first day; 2:1 Match on retirement savings; Modes of Work Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department... That's benefits info. Also there is Underfill Statement, Background Screening, Application Deadline, U-M EEO Statement - these are boilerplate to remove. Also "How to Apply" includes cover letter requirement - that's application instructions, should be removed. Also "Job Summary" is content.
We need to preserve all substantive information, not invent or summarize away detail. Remove boilerplate, duplicated lines, application instructions, EEO, etc.
We need to decide sections: About the role (Job Summary). Responsibilities. Requirements (maybe combine Required Qualifications and Education?). Qualifications (maybe Desired Qualifications). Skills? Could be part of qualifications. Benefits (What Benefits can you Look Forward to?). Pay? Not present. Schedule? Not present (though Modes of Work mentions hybrid/remote but that's more work arrangement, could be considered Schedule? But it's not explicit schedule like full-time/part-time. The instruction: never create Pay/Schedule/Benefits sections unless posting actually states them. Benefits is stated, so we include Benefits. Schedule not stated explicitly, so omit. Pay not stated, omit.
We need to use for section headings. Use - for any list of duties/requirements/benefits, and
for prose.
We need to preserve all substantive information: So we need to include the text from Job Summary, Responsibilities bullet points, Required Qualifications bullet points, Education bullet points (Intermediate Level Qualifications and Senior Level Qualifications), Desired Qualifications bullet points, Why Join Michigan Medicine? (maybe as About the role? but we already have Job Summary; maybe we can include a section "About Michigan Medicine" but not required headings list includes About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. "Why Join Michigan Medicine?" could be considered About the role? Actually About the role is job summary. The "Why Join Michigan Medicine?" is more about the organization; could be considered part of About the role or maybe we could treat as a separate section like "About the organization" but not in allowed headings. The instruction: Use
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It says e.g., meaning those are examples, not exclusive list? It says use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Likely they expect us to use those headings where appropriate. So we can use About the role for job summary and maybe also include Why Join Michigan Medicine? as part of About the role? Could add a paragraph after job summary about why join. But we must not invent or summarize away detail; we can include that content as a paragraph under About the role.
Thus About the role section will contain two paragraphs: Job Summary paragraph and Why Join Michigan Medicine? paragraph.
Responsibilities: list items from Responsibilities* bullet points.
Requirements: Could combine Required Qualifications and Education? The instruction: Use headings for Requirements, Qualifications, Skills. We need to decide what goes where. Typically Requirements = Required Qualifications + Education. Qualifications = Desired Qualifications. Skills maybe not separate; we could omit Skills if no specific skills list beyond those already covered. But we could put skills under Qualifications? However we have both Required Qualifications and Desired Qualifications; we could map Required Qualifications to Requirements, Desired Qualifications to Qualifications. Education could be part of Requirements as well.
Thus:
About the role
Job Summary paragraph
Why Join Michigan Medicine? paragraph
Responsibilities
- ... each bullet
Requirements
- Required Qualifications bullet points
- Education bullet points (Intermediate Level Qualifications and Senior Level Qualifications)
Qualifications
- Desired Qualifications bullet points
We should not include Skills section if no specific skills list beyond those already covered. Could we extract skills from Required Qualifications? But they are already there. Better to omit Skills.
Benefits section: Benefits
with list items: Excellent medical, dental and vision coverage effective on your very first day; 2:1 Match on retirement savings; Modes of Work Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes. (That last sentence is maybe boilerplate but it's part of benefits description; we keep it.)
We need to preserve all substantive information: The benefits bullet includes two items: medical/dental/vision coverage; 2:1 match on retirement savings; Modes of Work... The "Learn more about the work modes." is maybe a link but we keep as text.
We need to remove boilerplate: Underfill Statement, Background Screening, Application Deadline, U-M EEO Statement, also "How to Apply" and cover letter instruction.
Also remove duplicated lines: none.
Now we need to ensure we don't include any headings with empty content.
Let's extract the exact text.
Job Summary: "The University of Michigan Medical group is seeking a highly motivated professional to build and provide ongoing maintenance of a decision support platform. This individual will be responsible for end-to-end BI solutions, including data mart design and development, creation of reports and visualizations using appropriate Business Intelligence tools (e.g. Tableau), and data analysis. This individual will serve a key role in developing business intelligence tools to drive decision making, ultimately maximizing value of care delivery at UMHS. Ideal candidates should have a blend of operational and technical experience, with demonstrated ability to function with a high degree of autonomy. The position provides the opportunity for development and growth within Michigan Medicine."
Why Join Michigan Medicine? paragraph: "Michigan Medicine is one of the largest health care complexes in the world and has been the site of many groundbreaking medical and technological advancements since the opening of the U-M Medical School in 1850. Michigan Medicine is comprised of over 30,000 employees and our vision is to attract, inspire, and develop outstanding people in medicine, sciences, and healthcare to become one of the world?s most distinguished academic health systems. In some way, great or small, every person here helps to advance this world-class institution. Work at Michigan Medicine and become a victor for the greater good."
Responsibilities bullet points (under Responsibilities*): list:
- Technical Serve as a technical expert including but not limited to report writing via SQL, design of dashboards utilization visualization tools, conduct validation and user acceptance testing of developed solutions
- Master understanding of BI architecture, functions, features, to be able to customize tool to specific user needs
- Interview end users to determine requirements for data, reports, analytics, metadata, training, service, data quality, and performance
- Work with data warehousing team and data architects to translate business requirements into technical specifications, and ensure that architecture is optimized for data needs
- Analytics Partner with customers to collect and coordinate business requirements to deliver meaningful and reliable performance analytics
- Lead development of data analytics and business intelligence capabilities to support and fulfill business use cases
- Mine large complex data sets from various sources of data
- Translate abstract business questions into analytic use cases and visual reports/dashboards in Tableau
- Audit and reconcile operational data, patient data, financial data and other statistics and metrics
- Provide data analytics support to clinical programs, performance improvement initiatives, operational leadership, and levels of executive leadership
Note: Some bullets have two parts separated by line break? We'll keep as is.
Required Qualifications bullet points (under Required Qualifications*):
- Proficient use of SQL or alternative relational database querying software to support business needs
- Advanced knowledge with data analysis & visualization tools (e.g. Tableau, R, etc.)
- Proficiency in Excel
- Demonstrated proficiency in technical, problem solving, and analytical skills
- Has working knowledge in BI architecture, functions, and features
- Ability to translate abstract concepts and business requirements into technical solutions
- Ability to understand complex clinical and business processes and identify relevant data sets
- Have innovative and creative approach to reporting, analytics and data visualization
- Strong interpersonal and communication skills, a proactive service-oriented team player
- Ability to effectively communicate with technical data architects and operational leadership
- Adaptability and flexibility to adjust to fluctuating changes in project needs
- Comfort in navigating ambiguity with a can-do attitude, adaptable and quick learner, willingness to acquire and develop new skills as needed
Education bullet points (under Education Intermediate Level Qualifications: and Senior Level Qualifications):
- Intermediate Level Qualifications: Bachelor's degree in Business, Health Administration, Accounting, Finance or a related field. Computer Science and Information Systems coursework a plus.
- Senior Level Qualifications: BA or BS in quantitative field with 5+ years of experience.
Desired Qualifications bullet points (under Desired Qualifications*):
- Epic Clarity Proficiency or Certification
- Previous work experience with an academic medical center or in healthcare desired
- Quantitative experience or coursework in healthcare finance
- Background in Computer Science or Health Information Systems a plus
Benefits: "What Benefits can you Look Forward to?" bullet points:
- Excellent medical, dental and vision coverage effective on your very first day
- 2:1 Match on retirement savings
- Modes of Work Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.
We need to ensure we don't include any extra fluff like "Learn more about the work modes." It's part of the benefits description; we keep.
Now produce HTML.
We must not include or . Just fragment.
Let's craft:
About the role
The University of Michigan Medical group is seeking a highly motivated professional to build and provide ongoing maintenance of a decision support platform. This individual will be responsible for end-to-end BI solutions, including data mart design and development, creation of reports and visualizations using appropriate Business Intelligence tools (e.g. Tableau), and data analysis. This individual will serve a key role in developing business intelligence tools to drive decision making, ultimately maximizing value of care delivery at UMHS. Ideal candidates should have a blend of operational and technical experience, with demonstrated ability to function with a high degree of autonomy. The position provides the opportunity for development and growth within Michigan Medicine.
Michigan Medicine is one of the largest health care complexes in the world and has been the site of many groundbreaking medical and technological advancements since the opening of the U-M Medical School in 1850. Michigan Medicine is comprised of over 30,000 employees and our vision is to attract, inspire, and develop outstanding people in medicine, sciences, and healthcare to become one of the world?s most distinguished academic health systems. In some way, great or small, every person here helps to advance this world-class institution. Work at Michigan Medicine and become a victor for the greater good.
- for any list of duties/requirements/benefits, and
for prose. We need to preserve all substantive information: So we need to include the text from Job Summary, Responsibilities bullet points, Required Qualifications bullet points, Education bullet points (Intermediate Level Qualifications and Senior Level Qualifications), Desired Qualifications bullet points, Why Join Michigan Medicine? (maybe as About the role? but we already have Job Summary; maybe we can include a section "About Michigan Medicine" but not required headings list includes About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. "Why Join Michigan Medicine?" could be considered About the role? Actually About the role is job summary. The "Why Join Michigan Medicine?" is more about the organization; could be considered part of About the role or maybe we could treat as a separate section like "About the organization" but not in allowed headings. The instruction: Use
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It says e.g., meaning those are examples, not exclusive list? It says use
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Likely they expect us to use those headings where appropriate. So we can use About the role for job summary and maybe also include Why Join Michigan Medicine? as part of About the role? Could add a paragraph after job summary about why join. But we must not invent or summarize away detail; we can include that content as a paragraph under About the role. Thus About the role section will contain two paragraphs: Job Summary paragraph and Why Join Michigan Medicine? paragraph. Responsibilities: list items from Responsibilities* bullet points. Requirements: Could combine Required Qualifications and Education? The instruction: Use headings for Requirements, Qualifications, Skills. We need to decide what goes where. Typically Requirements = Required Qualifications + Education. Qualifications = Desired Qualifications. Skills maybe not separate; we could omit Skills if no specific skills list beyond those already covered. But we could put skills under Qualifications? However we have both Required Qualifications and Desired Qualifications; we could map Required Qualifications to Requirements, Desired Qualifications to Qualifications. Education could be part of Requirements as well. Thus:
About the role
Job Summary paragraph
Why Join Michigan Medicine? paragraph
Responsibilities
- ... each bullet
Requirements
- Required Qualifications bullet points
- Education bullet points (Intermediate Level Qualifications and Senior Level Qualifications)
Qualifications
- Desired Qualifications bullet points
Benefits
with list items: Excellent medical, dental and vision coverage effective on your very first day; 2:1 Match on retirement savings; Modes of Work Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes. (That last sentence is maybe boilerplate but it's part of benefits description; we keep it.) We need to preserve all substantive information: The benefits bullet includes two items: medical/dental/vision coverage; 2:1 match on retirement savings; Modes of Work... The "Learn more about the work modes." is maybe a link but we keep as text. We need to remove boilerplate: Underfill Statement, Background Screening, Application Deadline, U-M EEO Statement, also "How to Apply" and cover letter instruction. Also remove duplicated lines: none. Now we need to ensure we don't include any headings with empty content. Let's extract the exact text. Job Summary: "The University of Michigan Medical group is seeking a highly motivated professional to build and provide ongoing maintenance of a decision support platform. This individual will be responsible for end-to-end BI solutions, including data mart design and development, creation of reports and visualizations using appropriate Business Intelligence tools (e.g. Tableau), and data analysis. This individual will serve a key role in developing business intelligence tools to drive decision making, ultimately maximizing value of care delivery at UMHS. Ideal candidates should have a blend of operational and technical experience, with demonstrated ability to function with a high degree of autonomy. The position provides the opportunity for development and growth within Michigan Medicine." Why Join Michigan Medicine? paragraph: "Michigan Medicine is one of the largest health care complexes in the world and has been the site of many groundbreaking medical and technological advancements since the opening of the U-M Medical School in 1850. Michigan Medicine is comprised of over 30,000 employees and our vision is to attract, inspire, and develop outstanding people in medicine, sciences, and healthcare to become one of the world?s most distinguished academic health systems. In some way, great or small, every person here helps to advance this world-class institution. Work at Michigan Medicine and become a victor for the greater good." Responsibilities bullet points (under Responsibilities*): list: - Technical Serve as a technical expert including but not limited to report writing via SQL, design of dashboards utilization visualization tools, conduct validation and user acceptance testing of developed solutions - Master understanding of BI architecture, functions, features, to be able to customize tool to specific user needs - Interview end users to determine requirements for data, reports, analytics, metadata, training, service, data quality, and performance - Work with data warehousing team and data architects to translate business requirements into technical specifications, and ensure that architecture is optimized for data needs - Analytics Partner with customers to collect and coordinate business requirements to deliver meaningful and reliable performance analytics - Lead development of data analytics and business intelligence capabilities to support and fulfill business use cases - Mine large complex data sets from various sources of data - Translate abstract business questions into analytic use cases and visual reports/dashboards in Tableau - Audit and reconcile operational data, patient data, financial data and other statistics and metrics - Provide data analytics support to clinical programs, performance improvement initiatives, operational leadership, and levels of executive leadership Note: Some bullets have two parts separated by line break? We'll keep as is. Required Qualifications bullet points (under Required Qualifications*): - Proficient use of SQL or alternative relational database querying software to support business needs - Advanced knowledge with data analysis & visualization tools (e.g. Tableau, R, etc.) - Proficiency in Excel - Demonstrated proficiency in technical, problem solving, and analytical skills - Has working knowledge in BI architecture, functions, and features - Ability to translate abstract concepts and business requirements into technical solutions - Ability to understand complex clinical and business processes and identify relevant data sets - Have innovative and creative approach to reporting, analytics and data visualization - Strong interpersonal and communication skills, a proactive service-oriented team player - Ability to effectively communicate with technical data architects and operational leadership - Adaptability and flexibility to adjust to fluctuating changes in project needs - Comfort in navigating ambiguity with a can-do attitude, adaptable and quick learner, willingness to acquire and develop new skills as needed Education bullet points (under Education Intermediate Level Qualifications: and Senior Level Qualifications): - Intermediate Level Qualifications: Bachelor's degree in Business, Health Administration, Accounting, Finance or a related field. Computer Science and Information Systems coursework a plus. - Senior Level Qualifications: BA or BS in quantitative field with 5+ years of experience. Desired Qualifications bullet points (under Desired Qualifications*): - Epic Clarity Proficiency or Certification - Previous work experience with an academic medical center or in healthcare desired - Quantitative experience or coursework in healthcare finance - Background in Computer Science or Health Information Systems a plus Benefits: "What Benefits can you Look Forward to?" bullet points: - Excellent medical, dental and vision coverage effective on your very first day - 2:1 Match on retirement savings - Modes of Work Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes. We need to ensure we don't include any extra fluff like "Learn more about the work modes." It's part of the benefits description; we keep. Now produce HTML. We must not include or . Just fragment. Let's craft:About the role
The University of Michigan Medical group is seeking a highly motivated professional to build and provide ongoing maintenance of a decision support platform. This individual will be responsible for end-to-end BI solutions, including data mart design and development, creation of reports and visualizations using appropriate Business Intelligence tools (e.g. Tableau), and data analysis. This individual will serve a key role in developing business intelligence tools to drive decision making, ultimately maximizing value of care delivery at UMHS. Ideal candidates should have a blend of operational and technical experience, with demonstrated ability to function with a high degree of autonomy. The position provides the opportunity for development and growth within Michigan Medicine.
Michigan Medicine is one of the largest health care complexes in the world and has been the site of many groundbreaking medical and technological advancements since the opening of the U-M Medical School in 1850. Michigan Medicine is comprised of over 30,000 employees and our vision is to attract, inspire, and develop outstanding people in medicine, sciences, and healthcare to become one of the world?s most distinguished academic health systems. In some way, great or small, every person here helps to advance this world-class institution. Work at Michigan Medicine and become a victor for the greater good.