Job description

Date: 12-May-2022

Location: Pittsburgh, Pennsylvania

Company: LTTS

  • Using third party database to retrieve data and prepare for analysis using PostgreSQL
  • Generally know how to make efficient queries when dealing with several tables and know what's involved in optimizing queries
  • Details:
o Multiple joins (joining several tables)
o Subqueries and CTE Tables
o Window Functions (RANK, ROW_NUMBER, etc.)
o Regular Expressions
o Grouping and aggregation
o Set functions: UNION ALL, etc.
o JSON(b) functions

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.