Data Quality & SQL Analyst: Database Integrity Specialist

Delan Associates, Inc; Florida; Presencial; USD 65 000 - 95 000; Tempo integral

Resumo da oferta

Delan Associates, Inc. in Palm Beach Gardens, FL is seeking a Database Analyst / Data Quality & Requirements Specialist (SQL + Excel) for a full-time, on-site role. You will manage PostgreSQL databases, write efficient queries, and build Excel-based audit tools to ensure data accuracy and reliability.

The ideal candidate combines hands-on database skills with a business analyst mindset, translating needs into data logic and validating results end-to-end with stakeholders.

Qualificações

• Strong SQL experience, including PostgreSQL.
• Relational database fundamentals: keys, constraints, normalization.
• Experience managing, updating, and auditing datasets.
• Advanced Excel skills: pivots, filters, lookups, data validation.
• Experience performing data audits with documented findings.

Responsabilidades

• Maintain, update, and audit relational databases (PostgreSQL), ensuring accuracy, consistency, and traceability.
• Write and optimize SQL queries, including multi-table joins, aggregations, and validation checks.
• Perform data quality checks, reconcile discrepancies, and document root causes and fixes.
• Build and maintain Excel-based audit tools (pivots, lookups, Power Query as applicable) for reporting and verification.
• Partner with internal users to gather requirements, challenge unclear requests, and translate business needs into data definitions and logic.
• Create and maintain documentation: table definitions, field mappings, audit results, and change logs.
• Support process improvements and controls around data updates, permissions, and governance.

Conhecimentos

SQL

PostgreSQL

Data quality

Requirements gathering

Stakeholder communication

Attention to detail

Business analyst mindset

Data governance

Problem solving

Ferramentas

Power Query

XLOOKUP

VLOOKUP

Descrição da oferta de emprego

Delan Associates, Inc. in Palm Beach Gardens, FL is seeking a Database Analyst / Data Quality & Requirements Specialist (SQL + Excel) for a full-time, on-site role. You will manage PostgreSQL databases, write efficient queries, and build Excel-based audit tools to ensure data accuracy and reliability.

The ideal candidate combines hands-on database skills with a business analyst mindset, translating needs into data logic and validating results end-to-end with stakeholders.