Database Analyst

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

Job summary

Doist is seeking a Database Analyst / Data Quality & Requirements Specialist to manage PostgreSQL databases, run SQL queries, and audit data to ensure accuracy, reliability, and usability.

You will translate business needs into data definitions, build Excel audit tools, and collaborate with stakeholders to improve data governance and processes, ensuring data integrity across systems.

Qualifications

• Strong SQL experience with PostgreSQL or equivalent.
• Relational database fundamentals and data integrity.
• Advanced Excel with Pivot Tables, XLOOKUP/VLOOKUP.
• Experience auditing datasets and documenting findings.
• Clarify ambiguous requests and define data definitions.
• Excellent communication with stakeholders.

Responsibilities

• Maintain, update, and audit PostgreSQL databases for accuracy and traceability.
• Write and optimize SQL queries with multi-table joins and validations.
• Perform data quality checks and document root causes and fixes.
• Create and maintain Excel-based audit tools for reporting and verification.
• Gather requirements from internal users and translate into data definitions.
• Document table definitions, field mappings, audit results, and change logs.
• Support data governance and controls around updates and permissions.

Skills

SQL (PostgreSQL)

Excel advanced

Data quality & validation

Requirements gathering

Stakeholder communication

Documentation

Auditing datasets

Tools

Power Query

PI System

Maximo

AWS (RDS/S3)

Job description

Database Analyst / Data Quality & Requirements Specialist (SQL + Excel)

We’re looking for a database-focused analyst with strong SQL (PostgreSQL) skills and a sharp eye for detail. This person is naturally curious, asks “why?” before “how?”, and isn’t afraid to challenge assumptions to protect data integrity and improve processes. You’ll manage, update, and audit databases, partner with stakeholders to gather requirements, and help ensure our data is accurate, reliable, and usable.

This is a great fit for someone who blends hands‑on database skills with a business analyst mindset—someone who can independently clarify needs, translate them into data logic, and validate results end‑to‑end.

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

Required Qualifications

• Strong SQL experience, including PostgreSQL (or equivalent with ability to ramp quickly).
• Solid understanding of relational database fundamentals (keys, constraints, normalization concepts, data integrity).
• Demonstrated experience managing, updating, and auditing datasets/databases.
• Advanced Excel skills (filters, pivot tables, XLOOKUP/VLOOKUP, data validation; Power Query is a plus).
• Demonstrated experience performing data audits and documenting findings, remediation steps, and outcomes (repeatable + traceable work).
• Comfortable owning ambiguous requests and independently questioning stakeholders to gather requirements and confirms data definitions before building.
• Can explain logic and assumptions clearly to both technical and non-technical stakeholders.
• Shows critical thinking, asks “why,” identifies risks and edge cases, and proposes better approaches rather than executing blindly.
• Proven ability to investigate inconsistencies, ask probing questions, and validate assumptions.
• Strong written and verbal communication; comfortable working directly with stakeholders.

Nice-to-Have Qualifications

• Mechanical or engineering background/familiarity (or experience supporting engineering/asset-heavy environments).
• Familiarity with AVEVA PI (PI System / PI Data Archive / PI Vision) or time-series data concepts.
• Familiarity with IBM Maximo (asset management / work orders / equipment hierarchies).
• Familiarity with AWS (RDS, S3, Athena/Glue, IAM concepts, basic cloud data patterns).
• Experience acting as a BA: independently gathering requirements, defining acceptance criteria, mapping data sources to outputs.
• Familiarity with tools like Quest (e.g., Toad) or data access/auditing tools.