SQL Developer & Data Designer - Public Trust Clearance

Overview

Remote
$80,000 - $100,000
Full Time
No Travel Required

Skills

SQL Database Design
Data Analysis
Postgres DB
Redshift

Job Details

Role Description:

The SQL Developer will design, develop, and maintain complex SQL code based on business requirements and new business processes.

The SQL Developer responsibilities include:

- Performing day to day querying and analysis using SQL queries and procedures, and script execution to enhance understanding of data within a consolidated data store.

- Considering amorphous problem sets or functional requirements to determine path forward on creating the query to support end user business needs.

- Migration of queries, including conversion of syntax, from Postgres DB to a Redshift data store.

- Developing materialized views, stored procedures and scheduled queries.

- Analyzing existing queries for performance improvement and optimize runtime against Redshift database.

Technical Skills:

Skill

Years/Level of Experience

SQL Database Design

P2 Intermediate (7 Years)

SQL Data Analysis

P2 Intermediate (7 Years)