Data Analyst: SQL Mastery for Trusted Data and Insights

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

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.