Product Support Specialist II (Product Support Engineer)

Advarra provides integrated solutions that safeguard trial participants, empower clinical sites, ensure compliance, and optimize research performance. Connecting the clinical research ecosystem, Advarra delivers solutions through a site-centric approach that unifies and accelerates the drug development lifecycle, making clinical trials safer, smarter, and faster.

Advarra promotes individual and team success by encouraging and supporting team autonomy. We believe work-life balance is important for individuals and fundamental in writing high quality software.

Competitive PTO plan with float holiday and an additional week off between Christmas and New Year's.

Principal Duties & Responsibilities

• Continual development of knowledge base around the use of Advarra products
• Compliant with industry and customer security, privacy and confidentiality policies
• Conduct technical root cause analysis on application and integration issues including but not limited to:
  • Writing and executing queries within the application database
  • Analyzing application codes
  • Recreating customer issues within internal environments
  • Creating and investigating SQL trace files
  • Using performance monitoring tools
• Provide solutions or escalate issues to appropriate development team
• Develop SQL scripts to add/modify/delete data as necessary
• Develop custom reports according to customers' requirements
• Develop stored procedures and scripts for data migrations
• Deploy and update customers' Data Warehouse/Business Intelligence using database views and SQL Server Integration Services (SSIS)
• Perform data exports.
• Create and maintain internal process documents.
• Ability to work closely with cross functional teams as well as customers to solve non-trivial problems.
• Participate in retrospective analysis to identify improvements in process, application functionality and/or tools and utilities.
• Perform other job-related duties as assigned.

Education:

• Bachelor's Degree in computer science, preferred, or equivalent work experience.

Experience:

• Understand the architecture and operational flow of web-based applications
• Comprehension of relational databases and structured data sets
• Understand data warehouse concepts
• Solid and deep knowledge of SQL including:
  • Understanding/writing complex queries, DML and DDL in an ad hoc manner
  • SQL performance tuning
• Proficient with SQL Server extensions: T-SQL, SSMS, SSIS, SQL Server Profiler
• Experience with object-oriented programming language (C#, VB.NET)
• Experience with .NET Framework
• Comfortable using command line tools for Windows
• Demonstrated strong analytical and problem-solving skills including ability to make self-directed progress towards a solution
• Exceptional interpersonal skills and proven ability to communicate and work issues across functional teams

Knowledge, Skills, Abilities:

• Mentor other team members in a variety of operational tasks
• Actively seeks and initiates improvements in processes, knowledge base and tools
• Ability to understand, tune/optimize and/or refactor large, complex queries
• Create, modify, test and document SQL scripts used to add/modify/delete data
• Self-sufficient in pulling source code, configuring, running and debugging applications
• Knowledgeable about how and when to escalate high impact or severe issues.

Physical and Mental Requirements:

• Sit or stand for extended periods of time at stationary workstation.
• Regularly carry, raise, and lower objects of up to 25 Lbs.
• Learn and comprehend basic instructions.
• Focus and attention to tasks and responsibilities.
• Verbal communication; listening and understanding, responding, and speaking.

#mogul

EEO Statement:

Advarra provides equal employment opportunity to all individuals regardless of their race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, or domestic partner status, citizenship, genetic information or any other status or characteristic covered by federal, state, or local law. Further, the company takes affirmative action to ensure that applicants are employed, and employees are treated during employment without regard to any of these characteristics. Discrimination of any type will not be tolerated.

EEO/M/F/Disabled/Vets

Advarra employees must be fully vaccinated for COVID-19 as a condition of employment unless a medical or religious exemption is approved as a reasonable accommodation. Being fully vaccinated means that an individual is at least two weeks past their final dose of an authorized COVID-19 vaccine regimen. New hires must be fully vaccinated or have received approval of an exemption as a reasonable accommodation as of their first day of employment.

#LI-HK1

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)