Database Analyst PostgreSQL

Cai • Trenton, NJ

4d • Hybrid

About The Position

We are looking for a motivated Database Analyst ready to take us to the next level! If you have strong SQL skills, Python expertise, and experience with AWS databases, apply now. We are looking for a Database Analyst to implement and maintain data architecture solutions supporting research and enforcement initiatives. This position will be full-time contract and hybrid (3 days onsite, 2 days remote).

Requirements

• 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

Nice To Haves

• 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

Responsibilities

• 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

Benefits

• Benefit packages include medical, dental, and vision insurance, as well as 401k retirement account access.
• Employees in this role may also be entitled to paid sick leave and/or other paid time off as provided by applicable law.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 101-250 employees