Database Analyst / Data Quality & Requirements Specialist (onsite)

Vitaver & Associates

  • Florida
  • 3 days ago

    Highlights

    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; Always get paid in full and on time.

    Numbers & Facts

    LocationFlorida
    Websitehttp://www.vitaver.com

    Description

    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;
    • Always get paid in full and on time.

    Similar Jobs