Database Analyst / Data Quality & Requirements Specialist (onsite)
Palm Beach Gardens, FL
14661 - Database Analyst / Data Quality & Requirements Specialist (Onsite) – Palm Beach Gardens, FL Start Date: ASAP Type: Temporary Project Estimated Duration: 12+ months with possible extensions Work Setting: 100% of the time at the Client’s site. No telecommuting or remote work. This is a non-negotiable requirement from the client. Only candidates able to relocate as required should apply to avoid removal from future consideration.
Required:
Availability to work 100% of the time at the Client’s site in Palm Beach Gardens, FL (required);
Experience with SQL, including PostgreSQL (or equivalent relational database with ability to ramp quickly);
Experience with relational database fundamentals (keys, constraints, normalization, data integrity);
Experience managing, updating, and auditing datasets and databases;
Experience with advanced Excel (pivot tables, XLOOKUP/VLOOKUP, data validation, filters);
Experience performing data audits and documenting findings, remediation steps, and outcomes;
Preferred:
Mechanical or engineering background/familiarity (or experience supporting engineering/asset-heavy environments).
Experience with AVEVA PI (PI System / PI Data Archive / PI Vision) or time-series data concepts;
Experience with IBM Maximo (asset management, work orders, equipment hierarchies);
Experience with AWS (RDS, S3, Athena/Glue, IAM, cloud data patterns);
Experience acting as a Business Analyst: gathering requirements, defining acceptance criteria, mapping data sources to outputs;
Experience with data access or auditing tools such as Quest (e.g., Toad);
Experience with Power Query for Excel-based reporting and verification;
Background or familiarity with mechanical, engineering, or asset-heavy environments;
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 (pivot tables, lookups, Power Query) for reporting and verification;
Partner with internal stakeholders to gather requirements, challenge unclear requests, and translate business needs into data logic;
Create and maintain documentation including table definitions, field mappings, audit results, and change logs;
Support process improvements and controls around data updates, permissions, and governance;
Why apply?
Gain experience with one of the world’s largest solar and wind energy providers, which last year briefly became the most valued U.S. energy company;
Work with a great team of professionals and learn newest technologies and approaches;
Enjoy our Client’s wonderful campus with top-notch facilities for work and recreation;
Benefit from multiple projects extensions;
Receive support and advice from Vitaver consultants who are already working at our Client’s site;
Get extra cash by participating in Vitaver Successful Completion Bonus Program;