Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
Provide excellent customer service to end users of endpoint IRT systems.
Triage and respond to incoming queries (phone/email), ensuring that all requests are addressed in an appropriate timeframe.
Troubleshoot technical and non-technical issues using documentation, system configuration, and other resources
Experience
2–4 years
Must-have skills
SQL
Work mode
Hybrid
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Hyderabad, India Department: Services
About Us:
Endpoint is an interactive response technology (IRT®) systems and solutions provider that supports the life sciences industry. Since 2009, we have been working with a single vision in mind, to help sponsors and pharmaceutical companies achieve clinical trial success. Our solutions, realized through the proprietary PULSE® platform, have proven to maximize the supply chain, minimize operational costs, and ensure timely and accurate patient dosing. Endpoint is headquartered in Raleigh-Durham, North Carolina with offices across the United States, Europe, and Asia.
The Production Support Analyst (PSA) is the primary contact for end users of endpoint Interactive Response Technology (IRT) systems. In addition, the PSA will provide support to the Client Services and Data Management teams as needed.
Responsibilities:
Provide excellent customer service to end users of endpoint IRT systems.
Triage and respond to incoming queries (phone/email), ensuring that all requests are addressed in an appropriate timeframe.
Troubleshoot technical and non-technical issues using documentation, system configuration, and other resources
Document all incoming queries in endpoint’s ticketing system.
Escalate to internal teams when issues cannot be resolved within the support team.
Review data change requests for clarity, completeness and impact.
Collaborate with Client Services and Customers as needed to ensure database updates are made in the spirit of the original request.
Make minor modifications and execute existing SQL Data Scripts for viewing project data and system configuration
Participates in conference calls and/or meetings with internal and external teams as needed.
Organize own workspace and deadlines to ensure timely completion of tasks.
Provide guidance and mentoring to associate PSAs.
Create and submit training and knowledgebase for review by senior or lead PSA.
Demonstrate appropriate decision-making and strong IRT trouble-shooting skills
Verify data changes by using SQL scripts and ensure database updates are made in the spirit of the original request.
This position requires weekend and holiday coverage.
Perform other duties as required.
Experience:
2-4+ years’ experience in a user-facing role, with an emphasis on providing troubleshooting assistance and technical support via the phone & email.
Ideal candidates should be adept communicators, able to provide guidance to non-technical users and ask questions that accurately and efficiently determine the customer’s need.
A proven ability to understand technical concepts and learn very quickly, including experience with SQL databases.
Some experience in the life science industry preferred.
High-level of attention to detail with excellent organizational skills and ability to multi-task.
Strong interpersonal skills with the ability to work effectively with a wide variety of professionals.
Previous experience working in a fast-paced, support-oriented environment.
Prior experience working with voice (IVR) web (IWR) and mobile (IMR) platforms is ideal.
Ability to troubleshoot to determine the source of a customer issue using provided reference sources, data and other tools.
Skills:
Strong attention to detail
Excellent organizational and time management skills
Excellent verbal and written communication skills
Technical aptitude
Adaptability/flexibility in a changeable, fast-paced environment
Ability to learn and apply new skills quickly
Critical thinking
Education:
BA/BS Degree and/or appropriate experience
#LI-MT #LI-Remote
Key skills
Required
SQL
Soft skills
Attention to DetailCommunicationCritical ThinkingTime Management
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?