Now Hiring


Support Engineer (Madison, WI)

Apply Now

Forte is the industry-leading provider of software and services in the critical areas of clinical trial management, clinical data management and research administration for cancer centers, academic medical centers and health systems.

Essential Job Duties (in order of priority)

  • Understand the architecture and operational flow of web-based applications
  • Comprehension of relational databases and structured data sets
  • Continual development of knowledge base around the use of Forte products
  • Compliant with industry and customer security, privacy and confidentiality policies
  • Develop queries and reports to assist with and facilitate customer inquiries
  • 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 server logs
    • Recreating customer issues within internal environments
    • Creating and investigating SQL trace files
    • Using performance monitoring tools
    • Provide detailed communication to outline corrective action for given problems
    • Determine successive action(s) in congruence with existing processes and guidelines
    • Develop, test and document scripts and procedures to rectify application data or database logic issues
    • 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

Job Qualifications & Job Evaluation

Documentation:  The requirements listed below are representative of the knowledge, skill and/or ability required.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education

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

Experience

  • Understanding of SQL:
    • Query writing
    • Executing both DML and DDL
  • Exposure to:
    • SQL-based tools (SQL Developer, TOAD, SQL Plus, etc.)
    • Visual reporting tools (Jasper Reports, Crystal Reports, etc.)
    • Java, Javascript and associated IDEs (Eclipse, IntelliJ, etc.)
  • Innate technical curiosity
  • Relentless problem-solver
  • Strong written and verbal communication skills

Knowledge, Skills & Abilities

  • Solid and deep knowledge of SQL including:
    • Understanding/writing complex queries, DML and DDL in an ad hoc manner
    • Basic SQL performance tuning
    • Oracle specific SQL extensions including:
      • Analytical functions
      • Scalar subqueries
      • In-line views
      • Common table expressions
  • Proficient with:
    • SQL-based tools (SQL Developer, TOAD, SQL Plus, etc.)
    • Visual reporting tools (Jasper Reports, Crystal Reports, etc.)
  • Ability to read and understand Java, Javascript including working knowledge of associated IDEs (Eclipse, IntelliJ, etc.)
  • Comfortable using command line tools for Linux and 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

Licenses & Certifications

  • None required

Job Requirements

  • Ability to lift 25 pounds

Forte Research Systems is an equal opportunity employer and does not discriminate on any basis prohibited by federal, state or local law.

 

Apply Today