SQL Database Administrator

Synergy Business Consulting, Inc.; Town of Florida (NY); On-site; USD 70,000 - 90,000; Full time

Job summary

Synergy Business Consulting, Inc. is looking for a Database Analyst / Data Quality & Requirements Specialist located in New York. This role entails working with PostgreSQL databases and conducting deep data audits while collaborating with stakeholders.

The ideal candidate has strong SQL skills, an analytical mindset, and excels in data quality checks and reporting tools development. If you are passionate about data integrity and problem-solving, we'd love to hear from you!

Qualifications

• Detail-oriented with a focus on data integrity.
• Strong technical skills in SQL and relational databases.
• Experience performing data quality checks.

Responsibilities

• Maintain, update, and audit PostgreSQL databases.
• Write and optimize SQL queries for data auditing.
• Collaborate with stakeholders to gather business requirements.

Skills

SQL

Data auditing

Analytical mindset

PostgreSQL

Excel

Tools

PostgreSQL

AWS

Excel (Pivot Tables, XLOOKUP/VLOOKUP, Power Query)

Job description

NOW HIRING | Database Analyst / Data Quality & Requirements Specialist

Are you passionate about data integrity, SQL, and solving complex business problems? We’re looking for a detail‑oriented Database Analyst who combines strong technical skills with a business analyst mindset.

In this role, you’ll work hands‑on with PostgreSQL databases, perform deep data audits, collaborate with stakeholders, and ensure data accuracy across critical business operations. We want someone curious, analytical, and confident enough to ask “why?” before “how?”.

Responsibilities

• Maintain, update, and audit relational databases (PostgreSQL)
• Write and optimize SQL queries, joins, aggregations, and validations
• Perform data quality checks and resolve inconsistencies
• Build Excel‑based audit/reporting tools (Pivot Tables, XLOOKUP/VLOOKUP, Power Query)
• Gather and clarify business requirements with stakeholders
• Document data mappings, audit results, and change logs
• Support governance, permissions, and process improvements
• Experience managing and auditing datasets/databases
• Advanced Excel knowledge
• Strong analytical and critical‑thinking mindset
• Investigate issues, validate assumptions, and communicate clearly
• Experience working directly with technical and non‑technical stakeholders

Nice to Have

• Experience with AWS (RDS, S3, Athena, Glue)
• Familiarity with AVEVA PI/PI Vision
• Mechanical or engineering industry exposure
• Experience acting as a Business Analyst
• Familiarity with Quest/Toad or auditing tools

You’ll be part of a collaborative environment where your insights directly impact data quality, operational efficiency, and decision‑making. This is an excellent opportunity for someone who enjoys digging into data, solving problems, and driving meaningful improvements.