Job Description

The Data Analytics Consultant II is responsible for driving strategic data-informed decisions utilizing senior-level consulting expertise with Franciscan Health Physicians (FHP), Health Leaders Network (HLN), and Ambulatory Division by creating, gathering, and interpreting highly complex data and information on targeted variables systematically, preparing data for comprehensive ambulatory and population health metrics and analytics, and interpreting data analyses. This position provides creative extensive in-depth data analytic skills to perform complex assignments leading to actionable outcomes, creates, implements, and automates business and reporting solutions, and creates analytical and/or statistical models in accordance with best practices and monitors/measures program effectiveness enabling informed business decisions

Job Function:

1. Advanced Data Analytics & Reporting
   • Executes creative, unique and highly complex data analytic approaches leading to actionable outcomes by defining and calculating metrics to be analyzed; defining, calculating, and validating algorithms; and conducting analyses of business/market trends as related to Ambulatory (FHP), Health Leaders Network (HLN), and Workforce Health Solutions in order to serve as a subject matter expert and assist/support new and existing business initiatives.
   • Works autonomously to develop customized ad hoc reports to answer a variety of business and clinical questions, such as determining the financial impact of various initiatives, identifying key medical cost drivers, report on cost and quality performance metrics, and determining value-based incentive payments.
2. Consultation & Collaboration
   • Drives strategic data-informed decisions by utilizing senior-level consulting expertise with Franciscan Health Physicians (FHP), Health Leaders Network (HLN), and Ambulatory Division to identify and clarify key business needs; developing highly complex outcomes and process measures; translating business requirements; determining data/information needs and data collection methods; developing analysis plans; measuring the impact of business decisions on clients, customers, and/or members; working with senior leadership to identify opportunities and methods to improve efficiencies and client satisfaction with analysis; training end-users; and documenting processes and deliverables.
   • Interprets highly complex data analyses by applying findings to contextual settings; and developing insights, reports, and presentations telling a compelling story to stakeholders to enable and impact decision making; and providing context related to data interpretations and/or limitations as appropriate.
   • Creates and implements, and automates unique and highly complex business and reporting solutions by working with stakeholders in their design, planning, and implementation while ensuring consistency and coherency; evaluating and summarizing complex data and results; creating summary statistics; developing data reports, visualizations, and/or interactive and/or interactive Tableau dashboards, business intelligence reports; reporting to stakeholders on key findings; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.
   • Practices self-development and promotes learning in others by proactively providing information, resources, advice, and expertise with coworkers and customers; building relationships with cross-functional stakeholders; advising others through technical explanations and examples; adapting to competing demands and new responsibilities; and providing training and occasional mentoring to team members.
   • Works with senior leadership to direct work assignments and business-specific projects by applying extensive in-depth and/or broad knowledge expertise in subject area; develops work plans to meet business priorities and deadlines; ensuring team follows all procedures and policies; coordinating resources to accomplish priorities and deadlines; collaborating cross-functionally to make effective business decisions; solving highly complex problems; escalating high priority issues or risks as appropriate; and recognizing and capitalizing on improvement opportunities related to Franciscan Health Physicians (FHP), Health Leaders Network (HLN), and Ambulatory Division
3. Data Processing
   • Drives creative, extensive in-depth analytical and/or statistical models impacting informed business decisions by determining data and analytical requirements; creating models leading to actionable insights; and testing, refining, and validating models to identify solutions that incorporate operational and strategic implications in workflow design and desired results including detail in understanding the customer deliverables.
   • Gathers data and information on targeted, highly complex variables in an established systematic fashion by validating data sources; querying, merging, and extracting data across sources; completing routine data refresh and update; developing and/or delivering tools for electronic data collection; and providing user training, support, and documentation.
   • Applies in-depth knowledge to analyze data for process improvements for analytic efforts by integrating and consolidating data; ensuring data quality and accuracy; profiling data inaccuracies and recommending process improvements or system changes to enhance overall quality of the data; and cleaning and creating final data set(s) for analysis.
   • Ensures security, integrity, and privacy of FMOLHS data in conjunction with FMOLHS policies and procedures.

Experience, Education, Training, Special Skills, and Licensure:

• Experience: 10 years of programming and analytical experience; Master's degree in relevant field can substitute for 3 years of experience
• Education: Bachelor's degree required
• Training: Attend and achieves the following Epic education course certifications within ninety days of training implementation: Clarity, Caboodle, and Data Model
• Skills: Excellent organizational and communication skills. Superior interpersonal skills. healthcare experience, Knowledge of mainframe systems, computer systems and computer languages (SQL, SAS), statistical analysis software, reporting and visualization tools (Tableau, Excel, PowerPoint, business intelligence tools)