Data Quality & Insights Analyst (SQL + Excel)

Delan Associates, Inc; Town of Florida (NY); On-site; USD 85,000 - 120,000; Full time

Job summary

Delan Associates, Inc. is seeking a Database Analyst focused on data quality and requirements.

The role emphasizes strong SQL (PostgreSQL) skills, detailed data auditing, and collaboration with stakeholders to translate needs into actionable data definitions. You will maintain and audit PostgreSQL databases, build Excel-based audit tools, and help improve governance and data accuracy across the organization.

Qualifications

• SQL experience with PostgreSQL or equivalent.
• Strong understanding of relational databases and data integrity.
• Experience auditing datasets and documenting findings.
• Ability to translate business needs into data definitions.
• Excellent written and verbal communication with stakeholders.

Responsibilities

• 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.

Skills

SQL

PostgreSQL

Data quality

Requirements gathering

Stakeholder communication

Analytical thinking

Tools

Excel

Power Query

XLOOKUP

Job description

Delan Associates, Inc. is seeking a Database Analyst focused on data quality and requirements.

The role emphasizes strong SQL (PostgreSQL) skills, detailed data auditing, and collaboration with stakeholders to translate needs into actionable data definitions. You will maintain and audit PostgreSQL databases, build Excel-based audit tools, and help improve governance and data accuracy across the organization.