Indianapolis, Indiana
Chicago, Illinois
Hershey, Pennsylvania
Everett, Washington
Posted: 04-Oct-24
Location: Durham, North Carolina
Salary: Open
Categories:
Internal Number: DUHDUHUS250561EXTERNALENUS
At Duke Health, we're driven by a commitment to compassionate care that changes the lives of patients, their loved ones, and the greater community. No matter where your talents lie, join us and discover how we can advance health together.
PURPOSE: To provide support across Duke Health in the compilation, analysis, and modeling of market intelligence, health system activity, and healthcare forecasts for use in the development and implementation of strategic plans, business decisions, and ad hoc requests.
Job Responsibilities:
This position carries significant responsibilities for the analytic support needed to ensure that Duke Health makes appropriate strategic and business decisions. Responsibilities include analyzing and synthesizing data from a variety of sources, building complex models in Excel and other tools, and communicating information through executive dashboards and coherent written presentations. Analysts develop excellent quantitative and qualitative problem-solving skills while building a rich base of knowledge within the healthcare industry. Analysts will be required to understand the origin, usage, and limitations of data sets in order to appropriately develop actionable insights. Analysts gain exposure to the executive decision-making process and have the opportunity to influence the strategic direction of one of the nation's top healthcare systems. As such, this position carries high expectations for articulating the story behind the data.
Data Analysis and Data Visualization
- Oversee the analysis and collection of data to respond to information needs for Duke Health's strategic and business planning functions, understanding which data sources and components to utilize based on the given area of focus
- Assist Duke Health entities and staff in effectively analyzing, interpreting, and presenting data and information to various parties both internal and external to Duke.
- Contribute towards the development of Tableau dashboards to clearly communicate data insights through graphical visualizations and interactive controls
- Incorporate Excel graphics, PowerPoint presentations, Tableau dashboards, and maps (using ArcGIS), as appropriate, to aid in the visual representation of market information.
- Assist Duke Health staff in integrating market data with internal data generated by finance, marketing, and other relevant departments.
- Appropriately communicate parameters, assumptions, and details related to the data and analysis conducted.
- Keep the manager apprised of the progress and status of all projects. Consistently meet deliverable deadlines.
Analytical Modeling
- Develop robust data models in Excel to communicate outcomes in service utilization, growth, demand, market share, and workforce needs based on variable inputs
- Collaborate with team members to validate and document assumptions
- Incorporate functionality to stress-test model outputs using variable parameter inputs based on validated assumptions
- Ability to ensure models tie in with other tools and are easily updateable
Strategy and Business Plan Development
- Participate in planning meetings to assist in the development of Duke Health strategic plans and business cases.
- Act as primary support to Duke Health entities in accessing relevant data sources necessary to develop strategic plans and business cases.
- Identify necessary data to be collected. Effectively analyze the information to garner key insights and develop recommendations.
- Appropriately integrate internal data generated by finance, facility planning, and other relevant departments, as appropriate.
- Develop polished, written business plans and supporting analytics to advance Duke Health strategic goals, critically assessing the needs of each individual plan and providing content that is uniquely positioned to address the specific question and/or topic.
- Keep manager apprised of progress and status of all projects. Consistently meet deliverable deadlines.
- Appropriately manage repository of historical plans, data pulls, and deliverables.
Ad-Hoc Reporting
- Receive and track project requests; review and clarify with stakeholders, as needed.
- Identify necessary data to be collected and run reports for specific requests about the market and service area.
- Assist Duke Health entities and staff in developing ad-hoc reports aimed at extracting the relevant data needed by the end user.
- Effectively analyze and interpret the data/information to garner key insights and present the information in a clear, concise, and polished manner.
- Keep manager apprised of progress and status of all projects. Consistently meet deliverable deadlines.
- Appropriately manage repository of historical requests, data pulls, and deliverables.
Additional Duties
- Perform other related duties incidental to the work described herein.
- Monitor local, regional, and national trends. Support market research functions in support of planning initiatives.
- Collaborate and communicate with other members of the department to ensure effective and efficient completion of projects and for purposes of problem solving and on-the-job training.
Licensure, Training, and Policies
Must maintain compliance with all mandatory DUHS policies, training, and health/safety requirements
Knowledge, Skills and Abilities:
- Excellent verbal and written communication skills
- Exceptional attention to detail; ability to produce polished deliverables
- Problem solving skills, including the ability to work independently and systematically to analyze complex data, draw relevant conclusions, and successfully devise/implement solutions calmly and effectively
- Ability to manage multiple initiatives, shifting back and forth effectively among activities, to produce positive results in a dynamic environment
- Ability to work in a team-oriented environment
- Proactive and self-motivated; ability to perform with minimal supervision
- Intellectually curious with deep interest in the Healthcare industry
- Thirst for continuous learning, investigative analytics, and creative problem solving
Minimum Qualifications
Education
Bachelors degree in a business, healthcare, or quantitative field required. Masters degree preferred.
Experience
Work requires three years related experience. A Masters degree can substitute for two years of experience. Previous work experience in consulting, financial analysis, investment banking, strategic planning, or actuarial science is desired.
Advanced knowledge of Microsoft Excel is required, including demonstrated accomplishments in data analytics and modeling. Tableau, SQL and/or ArcGIS experience preferred, but not required. Working knowledge of Microsoft PowerPoint, including experience drafting written materials and visuals for executive leadership and/or regulatory stakeholders.
Degrees, Licensures, Certifications
N/A
Duke is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or veteran status.
Duke aspires to create a community built on collaboration, innovation, creativity, and belonging. Our collective success depends on the robust exchange of ideas-an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.
Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essentialjob functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.