Data Analyst-Technical-Sr
Intermountain Healthcare
Salt Lake City, UT, US
5d ago

Details : About Us

About Us

What does it mean to be a part of Intermountain Healthcare? It means that the quest for clinical excellence is not just a goal, but a given.

It means building an environment where physicians and employees can deliver the best in healthcare. And it’s realizing each employee or volunteer is vital to the healing process, because we can only achieve theextraordinary together.

Being a part of Intermountain Healthcare means joining with a world-class team of over 36,000 employees and embarking on a career filled with opportunities, strength, innovation, and fulfillment.

Our mission is : Helping people live the healthiest lives possible.

Our patients deserve the best in healthcare, and we deliver.

Job Description

This position focuses the majority of their time producing analytical solutions (reports, dashboards, tools, etc.) for leadership and stakeholders across the organization that supports business or clinical initiatives.

This position provides consultation and support in the development, analysis, interpretation, and management of a variety of highly complex data sources to support process improvement, operations, strategy, cost reduction, and increased patient safety and satisfaction.

Essential Job Duties

This position is responsible for providing analytical support - typically at a system-wide level. May work as part of a system-

wide team or interact with stakeholders across the system. Typically this position performs analysis on highly complex projects under general supervision.

This position works with data sources serving the needs of customers in one or more business areas :

  • Institute for Healthcare Delivery Research / Clinical Programs : Provides consultative assistance to physicians and administrators from internal and external health care systems who are attending training in health care quality improvement.
  • Acts as content expert for data related to the clinical area assigned. Supports clinical development teams in reporting, research, data exploration, and care process development and tracking.

  • Population Health Management / Decision Support : Population health management analytics (PHMA) supports the development, implementation, and measurement of systems of care that assess the health needs of a target population and proactively provides and coordinates services to improve the health of that population.
  • PHMA provides support for the following functions : integration of population health data, value improvement, standard quality service and cost metrics and measurement, risk scoring and severity adjustment, attribution methods, contract analysis, and new data source insight.

    PHMA utilizes data from across the healthcare system and across the continuum, including hospital, physician, and claims data.

  • Supply Chain : Provides expertise in analytics in the following areas - Total Cost of Ownership, forecasting, benchmarking, basic statistics, supplier financial health assessment and trend analysis.
  • Analysts develop business cases, track make goods, develop reports and dashboards for KPI's and other data requirements, and develop self-

    service tools for data needs. The Supply Chain Analytics group is responsible for providing data to their stakeholders, developing savings methodologies (collaborating with finance), validating all savings projects led by supply chain teams, and allocating the savings to the various facilities.

    The Supply Chain Analyst acts as the liaison between the business unit and Information Technology's Business Application Analyst team.

  • SelectHealth : Performs analytical activities to support decision making, planning, research, and administration for SelectHealth insurance products and initiatives.
  • Works with diverse datasets including claims, enrollment, premium, provider, care management, benefit configuration, quality, regulatory, and other related datasets.

  • Human Resources : Provides expertise in analysis, forecasting, planning, and research for human capital strategy and operations including : recruiting, performance management, education, succession planning, benefits, compensation, payroll, labor market analysis, workforce planning, workforce forecasting, staffing optimization, staff productivity and other areas of Human Resource management.
  • Works with data from core HRMS systems, talent management systems, scheduling and timekeeping systems, survey data, data from external sources, and data from other functional areas throughout Intermountain Healthcare.

  • Research : Provides study design and statistical analysis for researchers (doctors, nurses, therapists, etc.) across any and all specialties in intermountain healthcare.
  • Provides sample size / power calculations, study designs, randomization, and statistical analysis ranging from simple t tests to complex mixed effects models or Bayesian predictive analyses.

    Works with databases (simple SQL), imports data into statistical software, prepares the data for analysis and does the analysis, presenting the results including tables and graphs so that the researcher can understand, use, and present the results to others.

  • Continuous Improvement : Provides expertise in data modeling, study design, and analysis to support strategic Continuous Improvement initiatives with competency to summarize the research into statistical process control charts, annotated run charts, pareto charts, and other statistical diagrams.
  • Performs operational process improvement diagnostics through process flow diagramming, tally sheet planning, Lean tools, and other financial impact analysis.

    Develops comprehensive understanding of patient throughput and process failures, and data flows such as patient charges.

    Provides external clinical outcomes reporting to subscribed disease registries and other healthcare regulatory bodies. Utilizes EDW to work with data from core EMR and ancillary medical record systems along with ERP and related financial systems.

  • RCO : Provides operational and technical support to Revenue Cycle (RCO) and PAS Management in the analysis and reporting of various Revenue Cycle data.
  • This support includes the design, development and maintenance of processes for providing key measures relevant to revenue cycle operations, including patient revenue, billing, cash collections, denials, bad debt, charity, administrative adjustments, as well as other initiatives and projects as needed.

  • Medical Group : Provides expertise in analysis, forecasting, basic statistical and graphical analysis, flow diagramming, planning, and research for Intermountain Medical Group(IMG) in areas of practice management and quality initiatives including : Accounts receivable (A / R), value recognition program (VRP) reporting, patient experience, meaningful use, various CMS and government initiatives, HEDIS, NCQA and NQF (National Quality Forum) clinical quality data analysis and performance monitoring and technical consultation for quality improvement initiatives around these measures ,panel management, third next available, telephones, wait time, new facility planning, advanced directives, ERP, operations process improvement, Lean, and financial analysis on occasion.
  • Utilizes EDW, and less often external data sources, to work with data from : core EMR systems, IMG master data management stores including facility master and provider master, imaging and lab services, DIG, and CDR.

    Key linkages are ODs, AODs, Medical directors, practice managers, physician recruiting, Select Health, Shared Accountability, credentialing, provider enrollment, Finance, Human Resources, Accounting, Strategic Planning and Research, HDD, CMS, Legal, ATP, and Compliance.

  • Planning : Serves as analytic resource to system planners and divisional operating executives to maximize the use of Intermountain strategic planning data resources.
  • Planning analysts conduct both internal system and healthcare market analysis by developing and deploying planning reports and dashboards, informational maps, tools and analyses for subject areas including hospital and clinic volume tracking and forecasting, population growth, demographic trends, population use-

    rates, payer mix, patient severity indexing, cost and efficiency studies, capital asset utilization, clinical service distribution and activity, and community physician need.

  • Physician Contracting : Analysts develop business cases; develop, validate, and support reports and dashboards for KPI's and other data requirements;
  • and develop self-service tools for data needs. The Analyst is responsible for providing data to stakeholders. Physician Contracting stakeholders include but are not limited to, senior executives, hospital and Medical Group operational leadership, operators with contract portfolios, legal counsel, compliance, accounts payable, accounts receivable, payroll, and the Physician Contracting department.

    The Analyst acts as the liaison between Physician Contracting and the Business Application Analyst team.

    Core Essentials :

  • 1. Creates reports that answer multiple related questions as well as reports with linked content, drilldown, and nested parameters.
  • The report is formatted in such a way that leads the user through the report in a well-organized, easy to understand fashion.

  • 2. Writes more advanced SQL including some query tuning and complex joins (e.g., outer joins on multiple tables). Uses sub-
  • queries and the With Statement as well as more complex functions (e.g., Substr, To Date, date calculations, etc.).

  • 3. Assists in the identification of data quality (accuracy, completeness, etc.) issues. Assists with the process of database design for assigned projects.
  • As appropriate, trains other individuals and teams in the routine use of data collection, analysis, and reporting and interpretation tools for measuring performance.

  • 4. Demonstrates an understanding of Primary / Foreign Keys, Table / Field Aliases, and Partitions / Indexes to produce high quality material.
  • 5. Provides project management / project leadership as appropriate to drive timelines and deliverables.
  • 6. Trains others on skills and competencies required for previous levels of Data Analyst.
  • Additional Essentials :

  • 1. Collaborates with corporate and region resources to design, create, test, and implement analytic tools (databases, reports, web applications, dashboards, etc.
  • that support enterprise / region needs and to improve data collection and reporting strategies (minimize duplication, redundancy, etc.).

  • 2. Demonstrates high level SQL and data extraction skills (i.e., Uses pre-defined scripts, changes parameters, GUI query (e.
  • g., MS Access, tools with drag-drop query creation capability, and Excel cubes).

  • 3. Uses standard Intermountain Reporting tools to generate reports for end users that interpret data for others to promote evidence-based decision making.
  • 4. Possesses a fundamental understanding of the domain's data and associated data models and uses it to produce high quality material.
  • 5. Compares data output to ensure data accuracy. Creates basic QA test plans and validates data for accuracy.
  • 6. Responsible to document work / projects per enterprise-wide standards (reports, project tracking, databases, etc.).
  • 7. Understands the appropriate use of indexes, partitions, ability to understand Entity Relationship Diagrams.
  • 8. Uses / analyzes Intermountain data sources (EDW, ORMIS, AS400, Essbase, Risk Management, etc.) to meet local and enterprise needs.
  • 9. Provides consultation, data analysis and project management for clinical and business stakeholders across the organization.
  • Communicates technical / analytical concepts to others.

  • 10. Shares important and relevant information with the team. Proactively offers suggestions, provides resources, volunteers for assignments, and removes barriers to help the team accomplish its goals.
  • 11. Contributes to Intermountain?s analyst community by participating in monthly analyst community events such as ASK (Analysts Seeking Knowledge) through presenting, teaching, and mentoring.
  • Posting Specifics

  • Entry Rate : $39.19 (varies depending on experience)
  • Benefits Eligible : Yes
  • Shift Details : M-F, business hours
  • Department : Decision Support
  • Unfortunately, we are not currently considering candidates for this position that require visa sponsorship. We apologize for the inconvenience.

    Minimum Requirements

  • Master's Degree and three years of analytics experience.
  • or Bachelor's Degree with five years of analytics experience. Degree must be obtained through an accredited institution.

    Education is verified.

  • Demonstrated proficiency and an advanced working knowledge of SQL (structured query language), quality improvement principles, and a solid knowledge of database design principles.
  • Demonstrated experience in developing, analyzing, interpreting, and managing a variety of complex data sets.
  • Demonstrated capabilities in planning, participating, and managing a variety of complex analytics projects.
  • Demonstrated strong proficiency using word processing, spreadsheet, database, internet and e-mail, and scheduling applications.
  • Demonstrated experience in a role requiring effective verbal, written, and interpersonal communication skills.
  • Solid experience using industry standard BI, statistical, or analytical tools and technologies.
  • Demonstrated applied understanding of data visualization design best practices.
  • Physical Requirements

  • Interact with others requiring the employee to verbally communicate information.
  • Operate computers and other IT equipment requiring the ability to move fingers and hands.
  • See and read computer monitors and documents
  • Remain sitting or standing for long periods of time to perform work on a computer, telephone, or other equipment.
  • Preferred Requirements

  • Degree in an analytics-related field such as statistics, mathematics, information systems, computer science, finance, economics, or an MBA with an emphasis in analytics.
  • If degree is not in an analytics related field seven years of analytics experience demonstrating proficiency performing the job essentials at this job level.
  • Proficiency using statistical methods and tools.
  • Proficiency using programming languages and tools.
  • Experience presenting to a variety of audiences and coaching leaders, customers and peers on data analysis best practices, trends, tools, and techniques.
  • Strong experience with SQL query tuning.
  • General experience in healthcare or subject matter expertise in the job area (such as Actuarial, Clinical Programs, Clinical Services, Compliance, Finance / Accounting, Human Resources, Management Engineering, Quality, Revenue Cycle, Select Health / Insurance, Strategic Planning, Costing, Chargemaster, Budgeting, etc.).
  • Please Note

    All positions subject to close without notice. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form