South Dakota Jobs

South Dakota Department of Labor & Regulation mobile logo

Job Information

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

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)

Client Responsibility

  • 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

Additional Requirements

  • 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 . 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.