Data Analyst

Mindlance; Town of Florida (NY); On-site; USD 65,000 - 90,000; Full time

Job summary

Mindlance is seeking a Data Analyst to advance data integrity and reporting capabilities for our clients. The role emphasizes SQL development, data quality controls, and collaboration with business stakeholders to define data requirements.

Strong experience with PostgreSQL and Excel-based tooling is expected, with a focus on creating reliable data processes and auditable results. This position offers opportunity for career growth within a dynamic IT staffing environment.

Qualifications

• Strong SQL experience including relational databases and data validation checks.
• Experience with relational databases and data auditing to ensure data integrity.
• Ability to translate business requirements into data definitions and logic.
• Advanced Excel skills including Pivot Tables and VLOOKUP/XLOOKUP; Power Query is a plus.

Responsibilities

• Maintain, update, and audit relational databases (PostgreSQL).
• Write and optimize SQL queries with multi-table joins and aggregations.
• Perform data quality checks and document root causes and fixes.
• Build and maintain Excel-based audit tools for reporting and verification.
• Collaborate with internal users to gather requirements and translate needs into data definitions.

Skills

SQL

Data quality

Analytical thinking

Communication

Problem solving

Tools

PostgreSQL

Excel

Power Query

Job description

Advance your career with Mindlance! We have been connecting talented IT professionals with world-class companies since 1999. Mindlance is here to help you to find the perfect fit with just the right company. Currently, we are seeking an Data Analyst For an exciting career growth Opportunity.

Make your next big career move with the kind of position that will allow you to be genuinely passionate about the work you do! Our recruiters will work closely with you to help you get the edge over the competition. Let Mindlance advocate for you –

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.

Professional Experience

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

“Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”