Database Analyst - PostgreSQL (AWS)

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

Database Analyst
PostgreSQL
AWS
AWS QuickSight
ETL
data warehousing
Glue
Lambda
S3
Athena
Redshift

Job Details

Job: Database Analyst - PostgreSQL (AWS) Hybrid 3 days on-site Duration: 6-12 months Location: Trenton NJ NEED AWS- MUST HAVE-PostgreSQL and AWS QuickSight experience Onsite interview

Job Description
We are looking for a Database Analyst to implement and maintain data architecture solutions supporting research and enforcement initiatives. This position will be contract and hybrid (3 days onsite, 2 days remote).

What You ll Do
Develop ETL routines within the silver layer of the research data lake
Collaborate with research scientists to align business use cases in the gold layer
Ensure data hygiene across all layers and document data flows
Integrate new data sources and maintain transparency in data transformations
Support business compliance tools and strategic enforcement initiatives
Create pipelines for tracking wage theft violations and WALL implementation
Implement validation protocols for data accuracy
Develop predictive models and BI tools
Standardize data flows and enforce data quality controls

What You'll Need

Required:
5+ years of experience with SQL and relational DBMS
Strong experience in ETL and data warehousing
Proficiency in Python for data manipulation and automation
Experience with AWS database ecosystem (Glue, Lambda, S3, Athena, Redshift)
Working knowledge of BI tools and dashboard creation
Ability to communicate technical concepts to non-technical stakeholders
Strong documentation and collaboration skills
Experience with data dictionary systems and electronic data processing platforms

Preferred:
PostgreSQL and AWS QuickSight experience
Experience in government or regulatory environments
Familiarity with Git and vendor-built database solutions
Experience building or improving data pipelines

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.