CorroHealth · 2 hours ago
Sr Product Support Consultant
United States
Full-time
Onsite
Senior LevelCorroHealth is dedicated to helping clients achieve their financial health goals through scalable solutions and clinical expertise. The Sr. Product Support Consultant will manage data, ensure optimal database configuration, and support internal reporting efforts while monitoring campaign and system performance.
AnalyticsFinanceFinancial ServicesFinTechHealth Care
Responsibilities
Data Warehouse File processing
Maintain all SSIS process flows
PRISM to DW01
DW01 to Navient then updating to DW01 to AWS Sql
All AWS Sql processing
Validation of daily processing contact lists
Updating contact lists with new columns for filters to be used on the dialer
Updating for new clients to flow through all processes
Removing old clients
Verifying data is loaded for all supplemental application sites
Data ensures page functionality
All Export files from daily use back to systems of record(FACS/PRISM/RevSpring)
Texting
Validation of daily processing Data load for texting
Updating jobs to adjust text account criteria
Scheduling campaigns
Various Reporting needs
Assisting reporting with pulling dialer data down from AWS to DW01
Daily Dialer management
Simple IVR Updates
Campaign Scheduling/Strategy updates
Filter Updates
Agent updates
Queue updates
DNC/ANI requests
Call History export to FACS/PRISM(future)
SSIS updates for additional processing on Dialer SQL server
Update Xtend Staging to Xtend Cust data transformation to include new fields
Add new field to corresponding Contact List, Staging, and Backup
Update corresponding contact list build SQL to populate new field
Add field to LCME_config_customTableAttributes if it needs to be seen by agents (not just a filter build item)
FACS/PRISM(future) Dialer file updates
Example of update process to add 1 column to 1 contact list for client use on the dialer
SQL Updates in SQLPROD95 in USAGNT environment:
Added column for new field to the SLM_ETL_P10.dbo.Xtend_Mercy_Staging table
Added column for new field to the SLM_ETL_P10.dbo.Xtend_Staging table
SQL Updates in PRODSQLDW01 in HENDERSONVILLE environment:
Added column for new field to the Navient_Reporting.Staging.DWINV5 table
Added column for new field to the Navient_Reporting.Staging.DWINV_COMBINED table
Updated stored procedure Staging.SP_FACS_INVENTORY_CREATE to include new field. (For the client BILH only in this case.)
Updated stored procedure FACS.SP_UPDATE_INVENTORY to include new field. (For the client BILH only in this case.)
Updated view Dialer.vw_curr_load to include new field. (For the client BILH only in this case.)
Updated view FACS.vw_curr_inventory to include new field. (For the client BILH only in this case.)
SSIS Updates to Package FACS_Inventory_Load-PARALLEL:
Updated connection DWINV5 to include new field
Updated data flow Load DWINV Files to include new field in Staging.DWINV5 table
Updated data flow DWINV COMBINED Table Load to include new field in Staging.DWINV5 table
Updated data flow Push to SQLPROD95 to include new field. (For the client BILH only in this case.)
Qualification
Required
Experience with data warehouse file processing
Proficiency in maintaining SSIS process flows
Experience with AWS SQL processing
Ability to validate daily processing contact lists
Experience updating contact lists with new columns for filters to be used on the dialer
Experience verifying data is loaded for all supplemental application sites
Ability to ensure page functionality for data
Experience with exporting files from daily use back to systems of record (FACS/PRISM/RevSpring)
Experience with texting data load validation
Ability to update jobs to adjust text account criteria
Experience scheduling campaigns
Ability to assist with various reporting needs
Experience pulling dialer data down from AWS to DW01
Experience with daily dialer management
Ability to perform simple IVR updates
Experience with campaign scheduling/strategy updates
Ability to perform filter updates
Experience with agent updates
Ability to manage queue updates
Experience with DNC/ANI requests
Ability to export call history to FACS/PRISM
Experience with SSIS updates for additional processing on Dialer SQL server
Ability to update Xtend Staging to Xtend Cust data transformation to include new fields
Experience adding new fields to corresponding contact lists, staging, and backup
Ability to update corresponding contact list build SQL to populate new fields
Experience adding fields to LCME_config_customTableAttributes
Experience with SQL updates in SQLPROD95 and PRODSQLDW01 environments
Ability to update stored procedures to include new fields
Experience updating views to include new fields
Experience with SSIS updates to packages
Company
CorroHealth
CorroHealth is a provider of revenue cycle management solutions for healthcare organizations, including health systems, and health plans.
Founded in 2019
10001+ employees
H1B Sponsorship
CorroHealth has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (1)
2022 (1)
Funding
Current Stage
Late StageTotal Funding
$376.27MKey Investors
Patient Square Capital
2024-10-24Private Equity
2023-10-05Private Equity· $50M
2022-05-17Series Unknown· $16.6M
Leadership Team
Patrick Leonard
Chief Executive Officer
Becky Blake
Chief People Officer
Recent News
Company data provided by crunchbase