3 Lookup Formulas Jobs

Who we are: Founded in 1982, Workplace Options (WPO) is the largest independent provider of holistic wellbeing solutions. Through our customized programs, and comprehensive global network of credentialed providers and professionals, we support individuals to become healthier, happier and more productive both personally and professionally. Trusted by 51% of Fortune 500 companies, we deliver high quality care digitally and in person to over 75 million individuals across 116,000 organizations in more than 200 countries and territories. At WPO, you will be joining a team that is committed to improving employee wellbeing around the world. Current Opportunity: Data Processing Specialist Location: India Remote/Hybrid/Onsite: Remote or hybrid depending on proximity to our Bangalore office. What you will do: The Data Processing Specialist is responsible for sourcing, validating, and maintaining high-quality provider databases for WPOs Locator tools across multiple regions. This includes managing complex processing operations, overseeing vendor performance, ensuring accuracy of the data, and supporting quarterly updates for a multi-type provider directory (child care, elder care, schools, and specialty services). The role requires strong data handling skills, meticulous attention to detail, and the ability to manage technically demanding processes. This position is embedded within a cross-functional team and works closely with Product, Content, Reporting, and Technology teams. It plays a key role in sustaining the accuracy, usability, and legal compliance of WPOs provider databases. Responsibilities: Data Sourcing and Vendor Oversight: Lead the sourcing of provider data via government websites, public records, and direct outreach to licensing bodies. Write structured mining and deduplication instructions for the vendor (Sasta Outsourcing Services). Ensure compliance with regional licensing and regulatory requirements. Data Management and Quality Assurance: Perform address formatting, subtype mapping, geocoding, duplicates, etc. on vendor data sets. Apply 4-layer deduplication protocols to merge vendor and in-house datasets. Use lookup tools and geocoding APIs (e.g., EXE tool, Geoapify) to fill missing fields (e.g., zip code, county, local authority). Maintain data formatting and subtype consistency per Locator taxonomy. Publishing and Reporting Support: Prepare quarterly database updates and coordinate handoffs with the Reporting team for publishing on WPO platforms. Validate that publishing metrics (record counts by region/subtype) match source files. Flag anomalies or failures in geocoding, QA, or publication output. Documentation and Process Optimization: Maintain documentation for geocoding workflows, vendor instructions, and subtype standards. Identify opportunities for automation and process improvement. Support audits, updates, and transitions related to Locator tools and content infrastructure. Qualifications/Skills: Bachelors degree in a data, technology, or information science field. 2+ years in data processing and vendor management. Experience in database content verification, public data sourcing, or regulated information processing. Strong proficiency in Excel and familiarity with lookup formulas, VLOOKUP, and batch processing. Knowledge of geocoding tools, APIs, or GIS software is an asset. Excellent organizational, written, and verbal communication skills. Self-driven, detail-oriented, and comfortable working in a cross-regional environment. What we offer: At Workplace Options, we dont just deliver wellbeing services to our clients, we champion wellbeing for our own employees as well. Examples of our benefits and commitment to employee wellbeing include: Benefits - Group Mediclaim Insurance for 6 lacs INR, Accident Insurance, Gym reimbursement, Tuition reimbursement, EAP Support Services, Mentorship program, WPO Cares, Employee exchange program, Comprehensive training provided for this position At Workplace Options, we are committed to and are accountable for building a workplace where individuals feel empowered to bring their whole selves to work, free from judgment or fear of discrimination. We understand that having a diverse organization is only the beginning and it will require nurturing and care to thrive. We will continue to take action to ensure we achieve equitable and measurable outcomes. We strive to cultivate a space where diverse voices are not only heard but actively sought out and valued for the unique insights they bring. By embracing and promoting authenticity, we aim to build a vibrant and inclusive community that fosters collaboration, innovation, belonging and personal growth. For further details about WPO please check out our website www.workplaceoptions.com and these short videos give a great overview of what we do Human-Powered Care and The WPO Global Experience Workplace Options collects and processes personal data in accordance with applicable data protection laws. If you are a European job applicant, refer to our Privacy Notice for further details (https://www.workplaceoptions.com/privacy-notice-for-recruitment/). Show more Show less

The position of an Apprentice in the Finance Department at GLG in Gurugram involves working a minimum of 3 days per week in the office and following the shift timings from 12 PM to 9 PM IST as part of the National Apprenticeship Training Scheme (NATS) for a duration of 6 months. Responsibilities for this role include assisting the team with the accurate and timely processing of vendor invoices in Avid or Workday, handling employee expense claims in Concur or Workday, participating in the monthly closing process, and supporting the audit process by providing necessary documentation and information to auditors. The ideal candidate should have a graduation degree in commerce or accounting, possess strong organizational and attention-to-detail skills, be customer-service oriented with excellent communication abilities, and have the capacity to build effective working relationships across different departments. Additionally, an intermediate level of proficiency in Excel, including working with large datasets, lookup formulas, and Pivot Tables, would be advantageous. It is important to note that this apprenticeship training opportunity falls under the Apprentices Act, 1961 and is not considered as regular employment. GLG, also known as Gerson Lehrman Group, is a global insight network that connects clients with expertise from a network of around 1 million experts in various fields. Clients ranging from Fortune 500 corporations to technology firms, professional services organizations, and financial institutions benefit from GLG's industry-leading compliance framework, which ensures structured, auditable, and transparent knowledge sharing in line with internal compliance obligations and ethical standards. For more information, please visit www.GLGinsights.com.,

The job is based in Gurugram with a minimum requirement of working from the office for at least 3 days per week for a duration of 6 months. The shift timings are from 12 PM IST to 9 PM IST. This job opportunity is part of the National Apprenticeship Training Scheme (NATS) under the Finance department. As an apprentice in this role, your responsibilities will include, but are not limited to: - Assisting the team in the timely and accurate processing of vendor invoices in Avid or Workday. - Supporting the team in the timely and accurate processing of employee expense claims in Concur or Workday. - Assisting the team in the monthly closing process. - Providing necessary documentation and information to auditors to support the audit process. The ideal candidate for this position should have a graduation degree in commerce or accounting. It is essential to be highly organized and detail-oriented. Strong customer service skills, excellent communication abilities, and the capacity to build effective working relationships across the company's operations are also required. Additionally, having an intermediate level of knowledge in using Excel, including working with and organizing large datasets, utilizing lookup formulas, and Pivot Tables, would be advantageous. It is important to note that this apprenticeship training opportunity is offered under the Apprentices Act, 1961, and should not be considered as employment. About GLG / Gerson Lehrman Group: GLG is a global insight network that connects clients with valuable insights from a network of approximately 1 million experts worldwide. Clients, ranging from Fortune 500 corporations to leading technology companies, professional services firms, and financial institutions, rely on GLG to access expert knowledge across various fields. The company's industry-leading compliance framework ensures that clients learn in a structured, auditable, and transparent manner, aligning with their internal compliance obligations and the highest professional ethical standards. Compliance standards at GLG are a significant competitive advantage and a fundamental aspect of the company's culture. For further information, please visit www.GLGinsights.com.,