Navigant Consulting Inc Senior Database Support & Modeling Analyst - Remote Location in VERMILLION, South Dakota
With a unique blend of large firm resources and an entrepreneurial collaborative culture, Guidehouse is where your purpose, passion, and expertise transform organizations. Guidehouse is a leading global provider of consulting services to the public and commercial markets with broad capabilities in management, technology, and risk consulting. We help clients address their toughest challenges with a focus on markets and clients facing transformational change, technology-driven innovation and significant regulatory pressure. Across a range of advisory, consulting, outsourcing, and technology/analytics services, we help clients create scalable, innovative solutions that prepare them for future growth and success. Headquartered in Washington DC, the company has more than 7,000 professionals in more than 50 locations. If you’re passionately motivated to make a difference and deliver exceptional work, we invite you to learn more about your career opportunities at www.guidehouse.com
Interested in working with talented people to help develop innovative solutions to some of society’s most complex and challenging problems? We are Guidehouse, a leading consulting firm serving the public sector and commercial clients with specialized capabilities in strategy, technology, and risk management. You may not yet know our name, but we have a rich history. Guidehouse is a combination of PwC’s former public sector practice and Navigant’s deep expertise in energy, financial services and healthcare.
We offer an exciting, fast-paced environment that fosters intellectual growth and rewards individuals based on impact, not tenure. Our firm is at the forefront of an emerging model solving complex problems that stretch across government and private companies, affording our people the opportunity to be on the cutting edge of the consulting profession. By focusing on markets facing transformational change, technology-driven innovation, and significant regulatory pressure, our employees also develop and deploy world class knowledge and problem solving that leads to breakthrough solutions.
Our healthcare segment is comprised of consultants, former provider administrators, clinicians, and other experts with decades of strategy, operational/clinical consulting, managed care services, digital health, revenue cycle management, and outsourcing experience. Professionals collaborate with hospitals and health systems, physician enterprises, payers, government, and life sciences entities, providing performance improvement and business process management solutions that help them meet quality and financial goals. You will make an immediate impact from day one, working with a team to provide end-to-end solutions. We don’t simply put band-aids on our client’s issues, we are working side-by-side with them. Are up for the challenge?
Business Process Management unites the strengths of four category-leading companies to address the complexities of today’s healthcare system. We design, develop and implement integrated, patient-centered solutions for sustained improvements in performance and profitability, working collaboratively across a spectrum of customers that encompasses hospitals, health systems, physician practice groups and payers.
It is the responsibility of the Database Support and Modeling Analyst to oversee the rate modeling within the Contract Management Database which will be used for rate analysis projects. Analyst will assist with preparing account dataset that will be included in rate analysis, activate pricing of rate model and validate expected pricing results. As the rate modeling specialist of the Contract Management Database, the Analyst will be responsible for auditing contract models for all projects to ensure the integrity of pricing performance. Analyst will preserve a skillset of the logic constructed within the Contract Management Database and will assist with developing logic that improves the functionality. Analyst will contribute to the overall health of the Contract Management tool by creating and maintaining various functions within database. This position will perform any and all job-related duties as assigned.
Essential Job Functions
Function self-reliantly to model rates within Contract Management Database
Perform User Acceptance Testing (UAT) of system development and enhancements
Participate in the development and implementation of new rate methodology logic
Audit the integrity of contract models and ensure pricing performance is as expected
Create and preserve contract rate methodology loading guides
Assist with maintaining all coding tables within Contract Management Database
Contribute to creating and maintaining useful provision/contract templates
Support the implementation of new client projects and rate and pricing analysis projects
Primary liaison between Contract Modeling and Contract Loading Team
Assist in support with Clients as directed by Senior Administrator of Contract Database Support and Modeling
Duties and Responsibilities
Skillful in translating contractual terms and model relevant parameters in Contract Management Database
Model rates and activate pricing on account dataset included within rate model analysis
Extract key account details along with modeled pricing results to format for rate analysis
Organize rate model documents in standard format on shared network drive(s)
Perform testing within UAT and production environment ensuring stabilization of system functionality after upgrades and enhancements are deployed
Research and secure thorough understanding of new rate methodologies and participate in system development and implementation
Complete audits of new and existing contract models and provide feedback in set formats
Identify and report problematic rate modeling functionality and recommend improvement
Regular communication with Data Service Team to validate account datasets importing into Contract Management Database
Oversee the creation and maintenance of contract loading guides for all rate methodologies utilized within Contract Management Database
Assist with updating and maintaining all coding tables within Contract Management Database that is utilized for various functionality
Contribute to creation and maintenance of useful service category provision templates
Help with reviewing and resolving modeling inquiries from contract modeling team(s)
Maintain confidentiality of all private health information and contractual terms
Complete assigned responsibilities in a timely, accurate and thorough manner
Report conflicting terms within payer contracts subject to adverse effect on revenue
Provide support as needed by hosting or attending project meetings
Perform all responsibilities and communication in a professional manner
Minimum of 5 years’ experience in a Managed Care database environment
Sound familiarity with managed care payer contracts and product offerings
Possess effective/accurate oral and written English communication skills
Capable to identify contractual terms subject to multiple interpretations
Accustomed to an organized project structure that affords successful proactive outcomes
High school diploma required. Associates degree and/or technical training preferred
Knowledge of Microsoft Word, Access, EDI systems and strength within Excel
Familiarity with concepts of database management and obtaining data sets for analysis
General knowledge of hospital-based patient accounting and contract management systems preferred
Wide-ranging knowledge of medical coding methodologies including Rev Code, ICD-10, CPT, HCPCS, MS DRG, APR DRG, ASC, EAPG and APC
Understanding of medical billing procedures and forms including UB-04 and HCFA-1500
Comprehensive knowledge of medical reimbursement methodologies including per diem, case rates, DRG rates, ASC rates, APC rates, fee schedules, EAPG rates, APR DRG rates, Stop loss provisions and Carve-outs
Working knowledge of medical terminology
Strong conceptual, as well as quantitative and qualitative analytical skills
Work as a member of a team as well as be a self-motivator with ability to work independently
Constantly operates a computer and other office equipment to coordinate work
Regularly uses close visual acuity and operates computer equipment to prepare and analyze and transmit data
Generally works in an office environment
This position requires successful completion of a background check and employment verification.
The successful candidate must not be subject to employment restrictions from a former employer (such as a non-compete) that would prevent the candidate from performing the job responsibilities as described.
Guidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation.
Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.
If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.
Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.
Rewards and Benefits
Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.
Navigant Consulting Inc
- Navigant Consulting Inc Jobs