This position is responsible for the monthly processing of CMIS data in the Eclipsys/TSI Decision Support System. CMIS database encompasses 17 million encounters annually & 17 Service Areas.
Essential Functions:
- Must ensure that the general ledger & patient data files are loaded properly each month through monthly validation & reconciliation
- Audits the calculation & application of unit costs
- Provides quality control by reviewing a complex M204, mainframe, & TSI database to check for unacceptable variances & errors
- Coordinates the correction of any & all identified errors
- Provides a complete & reconciled database to users on a timely basis each month
- Conducts the monthly processing to populate the CMIS regional database w/ financial, clinical, demographic, utilization, & cost data
- Conducts database batch processing & coordination
- Coordinates the team's correction of any data rejects
- Audits & reconciles expenses & utilization as they travel through the Eclipsys/TSI modules
- Maintains the Indirect Cost Allocation structure for the entire region
- Understands the complexities of the ICA structure
- Audits the success of the demographic & clinical data loads
- Audits final costing & identifies any data quality issues
- Corrects the problem or brings the issue to the appropriate level for correction
- Resolves intricate data issues
- Serves as a CMIS liaison to & maintains regular contact w/ Partners providing source system data
- Meets w/ source system owners to resolve any data feed issues & discuss data feed improvements
- Meets w/ IT representatives to resolve any technological issues & discuss technological improvements
- Takes direction from Consultants for database improvement
- Communicates database status to Service Area consultants
- Works w/ CMIS team members to improve CMIS database continually
Qualifications:
Basic Qualifications:
- Previous (usually two (2) to three (3) years) relevant work experience
- Experience w/ relational databases
- Experience in working in a multi-disciplinary team
- Project coordination experience preferred
- Mainframe experience preferred
- Bachelor's degree, or equivalent experience in information management, finance, accounting or related field
- Written & oral communication skills
- Good project management & consulting skills
- Excellent verbal & written communication skills
- Proficient in PC databases, decision support tools, spreadsheets, & word processing
- Strong analytic skills
- Ability to work independently
- Ability to meet deadlines
- Attention to detail required
- Strong problem solving ability
- Ability to multi-task
- Ability to determine key business issues & develop effective action plans from multi-disciplinary perspectives
- Ability to conduct & interpret quantitative & qualitative analyses
Preferred Qualifications:
- Master's degree
External hires must pass a background check/drug screen.
We are proud to be an equal opportunity/affirmative action employer.