Job Summary
This role focuses on configuring health care benefit administration solutions within a hybrid work model for a global organization using strong expertise in MS Excel and Excel services on Sharepoint while supporting pharmacy benefit management operations during night shifts to ensure accurate benefit data smooth plan execution and reliable reporting for clients and members.
Responsibilities
- Configure health care benefit plans using MS Excel to support accurate pharmacy benefit configurations that ensure consistent and compliant benefit administration for clients and members during night shifts.
- Develop and maintain detailed configuration templates in MS Excel that align with pharmacy benefit management rules and business policies ensuring that all benefit attributes are clearly documented and easy to audit.
- Validate complex benefit data sets using advanced MS Excel functions to identify discrepancies outliers and missing information so that downstream processing and reporting remain reliable and error free.
- Utilize Excel services on Sharepoint to publish and manage configuration workbooks enabling controlled access centralized storage and version integrity for cross functional benefit operations teams.
- Coordinate with benefit analysts and operations specialists to interpret benefit administration requirements in the pharmacy benefit management domain and translate them into precise configuration logic within Excel based tools.
- Execute configuration test cases using MS Excel and related utilities to confirm that pharmacy benefit scenarios calculate correctly documenting outcomes and coordinating remediation activities when defects are detected.
- Create and maintain configuration run books in a structured format using Sharepoint based repositories so that configuration steps dependencies and validation checkpoints are clearly described and reusable across client implementations.
- Monitor nightly or scheduled processing events that rely on configuration files investigating data errors or processing failures using Excel driven analysis and escalating issues to appropriate stakeholders with well documented findings.
- Collaborate with quality and compliance teams to ensure that benefit configuration activities support regulatory expectations for pharmacy benefit management and internal control standards established by the organization.
- Support service teams by producing custom Excel reports from configured benefit data enabling timely insights on claim impacts member outcomes and financial performance for clients in the pharmacy benefit management space.
- Contribute to continuous improvement efforts by proposing optimization ideas for configuration templates Excel macros and Sharepoint workflows that reduce manual effort and improve consistency of benefit administration.
- Document configuration decisions and rationales in Sharepoint based knowledge repositories so that future team members can understand context reuse prior work and maintain continuity when requirements evolve.
- Engage in cross training with peers on benefit administration concepts PBM terminology and advanced Excel practices to broaden configuration coverage and strengthen overall team resilience in a hybrid and night shift environment.
Qualifications
- Possess professional experience ranging from two to four years in application configuration or operations within health care or pharmacy benefit management with direct exposure to benefit administration workflows.
- Demonstrate strong proficiency in MS Excel including formulas pivot tables data validation and basic automation techniques that support complex benefit calculations and configuration quality checks.
- Bring practical knowledge of Excel services on Sharepoint to manage shared workbooks control permissions and maintain a single source of truth for benefit configuration artifacts across distributed teams.
- Show hands on domain experience in benefit administration for pharmacy benefit management with familiarity in plan design formulary structures copay rules and network considerations that influence configuration logic.
- Exhibit experience working in hybrid and night shift models with disciplined time management and communication habits that ensure seamless collaboration with global colleagues and business stakeholders.
- Display analytical thinking problem solving skills and attention to detail that enable accurate interpretation of benefit requirements and precise construction of Excel based configuration solutions.
What we offer
- The chance to work with impact. Here, you’re empowered to bring your biggest thinking to help our company and clients improve everyday life.
- Ownership over your career. Stay at the top of your game through our award-winning learning and development ecosystem. And when your ambitions change or we offer new opportunities, we help you pivot by providing reskilling, on-the-job learning and guidance to find new roles that might be a better fit.
- The opportunity to thrive on a high caliber team with heart. We celebrate each other’s experiences and perspectives and promote a sense of belonging through our affinity groups and diversity and inclusion initiatives.
- A comprehensive total rewards package, including a competitive salary and a pension plan with matching contributions.
- Flexible health and financial benefits to support you and your eligible dependents—from day one.
- True work-life balance. Be at your best through paid time off, flexible work arrangements, volunteering opportunities, social events, and so much more.
About us
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, building the bridge between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, realize tangible returns and keep global enterprises ahead in a fast-changing world. See how at www.cognizant.com or @cognizant.
Other employment-related information
Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, provincial or local laws.
If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.
Language requirements vary depending on roles, but we ask that all candidates have basic English proficiency for company-wide communications purposes. For roles based in Quebec, professional English proficiency is required, as you’ll deliver services to and collaborate with stakeholders outside the province who may not speak French.
