Managed Care Database Administ

2 weeks ago


Wethersfield, United States Hartford Healthcare Full time

Description

Job Schedule: Full Time
Standard Hours: 40
Job Shift: Shift 1
Shift Details:

Work where every moment matters.

Every day, over 38,000 Hartford HealthCare colleagues come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticuts most comprehensive healthcare network.

The creation of the HHC System Support Office recognizes the work of a large and growing group of employees whose responsibilities are continually evolving so that we and our departments now work on behalf of the system as a whole, rather than a single member organization.
With the creation of our new umbrella organization we now have our own identity with a unique payroll, benefits, performance management system, service recognition programs and other common practices across the system.

Position Summary:

The Managed Care Contracting organization is seeking a results-oriented, committed, and self-motivated individual contributor with exceptional Microsoft Structure Query Language (MSSQL) Database skills to lead/execute the development of the complex Managed Care / Payer Analytics platform. The Payer Analytics team is primarily responsible for analyzing, developing, and maintaining complex contract pricing and profitability models in support of the various business applications for Hartford Healthcare. However, the Managed Care database has wider applicability throughout Hartford HealthCare, functioning as the primary information source to respond to a myriad of initiatives, including state and federal projects.

In this role, this individual partners with the Sr Director and management team to create and maintain database designs for business and enterprise projects in accordance with HHCs best practices and standards. This individual collaborates with the IT organization to facilitate database expansion. Our enterprise work model, which reflects a mix of in-office, hybrid and fully remote roles, helps us attract, retain and develop the talent we need to achieve the companys strategic goals. This role may have a hybrid work arrangement.

Position Responsibilities:

Key Areas of Responsibility

1. Assumes ownership of current database build, becoming Managed Care subject matter expert, implementing efficiencies and improvements as identified.

2. Partners with Sr Director to complete initiatives to identify and collect additional data to fulfill Managed Care business objectives identified for the database.

3. Continues to evolve the database, collaborating with stakeholders to identify gaps in information and potential solutions for future enhancements.

4. Champions the database through Hartford HealthCare, looking for opportunities to gain or to share functionalities that would benefit Managed Care, or the organization at large.

5. Explores and implements best practices for standard reports, as well as potentially develop an inventory system for ad-hoc requests.

6. Maintains and furthers develop database documentation including data dictionary, data lineage, operating and update procedures, security, etc.

7. Monitors database to maintain/improve stability and performance, addressing issues as identified such as data corruption, performance degradation, user access, etc.

8. Provides technical assistance and mentoring to the departments junior or inexperienced members.

Working Relationships

Job Title of Individual(s) Reports To: Sr Director of Managed Care Payer Relations

# Workers Responsible For

o In-Direct Reports: 1

Nature of Supervision:

o Business Analyst supporting database who completes refreshes and scheduled/adhoc reporting

Internal: Will engage various levels of leadership, particularly in Finance, Integrated Care Partners, and Information Technology.

External: Will be determined as position evolves.

Qualifications

Education

Minimum: BA/BS degree. Extensive experience (below) may be considered in lieu of formal degree.

Preferred: Preference to degree in Mathematics, Computer Science, Healthcare.

Experience

Minimum:

o SQL experience with advanced to Expert skills, including and proficiency in writing complex queries and stored procedures.

o Experience in Healthcare industry and/or Health Insurance specific to utilization and related code sets, with a strong preference to contract modeling

Preferred:

o 5 Years SQL experience.

o 5 Years Healthcare/Health insurance experience.

Licensure, Certification, Registration

Preferred: Epic Reporting

Language Skills

English

Knowledge, Skills and Ability Requirements:

SQL expert experience with complex datasets and procedures

Strong experience working with large data sets

Advanced Excel ability and Tableau experience a plus

Epic reporting certification /database experience desired

Preferred knowledge regarding current and evolving provider payment methodologies with a focus on hospital and physician

Preferred experience on billing and coding is required as well as broad knowledge of health care finance and accounting issues

Preferred knowledge of governmental (Medicare) payment structures

Strong interpersonal and communication skills essential as well as demonstrated ability to work collaboratively across functional

Demonstrated experience managing multiple projects simultaneously, taking plans into action and leading initiatives to finish

Excellent problem-solving and analytical skills with attention to detail.

We take great care of careers.

With locations around the state, Hartford HealthCare offers exciting opportunities for career development and growth. Here, you are part of an organization on the cutting edge helping to bring new technologies, breakthrough treatments and community education to countless men, women and children. We know that a thriving organization starts with thriving employees-- we provide a competitive benefits program designed to ensure work/life balance. Every moment matters. And this is your moment.


  • Senior Payer Analyst

    2 weeks ago


    Wethersfield, United States Hartford HealthCare Full time

    Description Job Schedule: Full Time Standard Hours: 40 Job Shift: Shift 1 Shift Details: Work where every moment matters. Every day, over 38,000 Hartford HealthCare colleagues come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut's most comprehensive healthcare...


  • Wethersfield, United States GoHealth Urgent Care Full time

    At GoHealth Urgent Care, we GO above and beyond for our patients, communities and team members to ensure effortless, personal and connected experiences. That's why we partner with the most innovative and integrated health systems and staff our centers with the most knowledgeable providers. GoHealth Urgent Care has partnered with Hartford HealthCare,...


  • Wethersfield, United States GoHealth Urgent Care Full time

    At GoHealth Urgent Care, we GO above and beyond for our patients, communities and team members to ensure effortless, personal and connected experiences. That's why we partner with the most innovative and integrated health systems and staff our centers with the most knowledgeable providers.GoHealth Urgent Care has partnered with Hartford HealthCare,...

  • Project Specialist

    2 days ago


    Wethersfield, United States Hartford Healthcare Full time

    Description Job Schedule: Full Time Standard Hours: 40 Job Shift: Shift 1 Shift Details: M-F Work where every moment matters. Every day, more than 30,000 Hartford HealthCare employees come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut's most comprehensive healthcare...

  • Senior Payer Analyst

    2 weeks ago


    Wethersfield, United States Hartford HealthCare Full time

    Description Job Schedule: Full Time Standard Hours: 40 Job Shift: Shift 1 Shift Details: Work where every moment matters. Every day, over 38,000 Hartford HealthCare colleagues come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut’s most comprehensive healthcare...


  • Wethersfield, United States Hartford HealthCare Corp. Full time

    **Description** **Job Schedule**: Full Time **Standard Hours**: 40 **Job Shift**: Shift 1 **Shift Details**: Monday through Friday 8a-4:30p day shift. Hybrid position with partial remote work. Travel to PCP Practice(s) and into office required. Work where every moment matters. Every day, almost 38,000 Hartford HealthCare employees come to work with one...

  • Restaurant Manager

    5 days ago


    Wethersfield, United States Sally's Apizza Full time

    Job DescriptionJob DescriptionFIND YOUR FIRE!At Sally's Apizza we have been creating New Haven Style Apizza since 1938 and are now expanding to locations across the United States. Famous for our distinctive tomato sauce and chewy, crispy crust with an iconic oven-kissed char, Sally’s draws pizza fans from around the world. We hand-craft authentic pizza...

  • Restaurant Manager

    5 days ago


    Wethersfield, United States Sally's Apizza Full time

    Job DescriptionJob DescriptionFIND YOUR FIRE!At Sally's Apizza we have been creating New Haven Style Apizza since 1938 and are now expanding to locations across the United States. Famous for our distinctive tomato sauce and chewy, crispy crust with an iconic oven-kissed char, Sally’s draws pizza fans from around the world. We hand-craft authentic pizza...

  • Territory Manager

    1 month ago


    Wethersfield, United States High Companies Full time

    Job Details Description Territory Manager The Territory Manager has responsibility for overall leadership of all functions within the assigned territory of the parking garage/building services business with the objective of generating maximum profitability and ensuring full capacity levels. Oversees the development and implementation of new...


  • Wethersfield, Connecticut, United States GoHealth Urgent Care Full time

    At GoHealth Urgent Care, we GO above and beyond for our patients, communities and team members to ensure effortless, personal and connected experiences. That's why we partner with the most innovative and integrated health systems and staff our centers with the most knowledgeable providers.GoHealth Urgent Care has partnered with Hartford HealthCare,...


  • Wethersfield, United States Hartford Healthcare Full time

    Work where every moment matters. Every day, over 38,000 Hartford HealthCare colleagues come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut’s most comprehensive healthcare network. The creation of the HHC System Support Office recognizes the work of a large and growing...


  • Wethersfield, United States Hartford HealthCare Full time

    Description Job Schedule: Full Time Standard Hours: 40 Job Shift: Shift 1 Shift Details: Work where every moment matters. Every day, over 30,000 Hartford HealthCare colleagues come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut's most comprehensive healthcare...

  • House Manager

    6 days ago


    Wethersfield, United States Dungarvin Full time

    Job DescriptionJob DescriptionCompany DescriptionA LITTLE ABOUT US:At Dungarvin, you have the ability to make someone's life better! Embrace the opportunity to change someone's life by assisting people with disabilities. Providing personal and companion care at Dungarvin, you will have the ability to enhance the quality of life for individuals with...


  • Wethersfield, United States Wethersfield Corporate Office Full time

    : **A Great Place to Work** As a Certified Great Place to Work, we think that you are going to love it here. Your work will be meaningful to you. You will make a genuine difference in the lives of our aging guests and the families that love them. You will enjoy lasting bonds with the families you meet and with the teams you work on. And if you desire, you...

  • Regional Case Manager

    22 hours ago


    Wethersfield, United States National Healthcare Associates Full time

    - A Great Place to Work As a Certified Great Place to Work, we think that you are going to love it here. Your work will be meaningful to you. You will make a genuine difference in the lives of our aging guests and the families that love them. You will enjoy lasting bonds with the families you meet and with the teams you work on. And if you desire, you will...


  • Wethersfield, United States Hartford Healthcare | GoHealth Urgent Care Full time

    Description Position at Hartford Healthcare GoHealth Urgent Care At GoHealth Urgent Care, we GO above and beyond for our patients, communities and team members to ensure effortless, personal and connected experiences. That's why we partner with the most innovative and integrated health systems and staff our centers with the most knowledgeable providers....

  • Medical Assistant

    2 days ago


    Wethersfield, United States Hartford Healthcare | GoHealth Urgent Care Full time

    **Schedule: Every Saturday & Sunday 7:45AM-8:00PM** **EXCELLENT BONUS PROGRAM**: Quarterly target bonus of up to 5% based on the customer satisfaction scores of your locations. AND up to $450 per month for a productivity bonus if certain center metrics are met.** At GoHealth Urgent Care, we place the needs of our patients first - by providing an effortless...


  • Wethersfield, United States Hartford HealthCare Full time

    Description Job Schedule: Full Time Standard Hours: 40 Job Shift: Shift 1 Shift Details: Monday-Friday Work where every moment matters. Every day, almost 30,000 Hartford HealthCare colleagues come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut's most comprehensive...

  • Medical Assistant

    21 hours ago


    Wethersfield, United States Hartford Healthcare | GoHealth Urgent Care Full time

    Description Position at Hartford Healthcare GoHealth Urgent Care Schedule: Every Saturday & Sunday 7:45AM-8:00PM **EXCELLENT BONUS PROGRAM: Quarterly target bonus of up to 5% based on the customer satisfaction scores of your locations. AND up to $450 per month for a productivity bonus if certain center metrics are met.** At GoHealth Urgent Care, we place...

  • Clinical Evaluator

    4 weeks ago


    Wethersfield, United States National Health Care Associates Inc. Full time

     A Great Place to Work As a Certified Great Place to Work, we think that you are going to love it here. Your work will be meaningful to you. You will make a genuine difference in the lives of our aging guests and the families that love them. You will enjoy lasting bonds with the families you meet and with the teams you work on. And if you desire, you will...