Data & SQL Developer (onsite)

Vitaver & Associates•Palm Beach Gardens, FL

21h•Onsite

About The Position

14577 - Data & SQL Developer (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 (SQL Server, Oracle, or MySQL acceptable); Experience with relational database fundamentals: keys, constraints, cardinality, and data integrity; Experience debugging data issues (join row explosions, mismatched totals, missing records) and proving correctness with validation checks; Experience building repeatable data audits/reconciliations and documenting findings and fixes; Experience with Excel for data validation and reporting (pivots, lookups). Preferred: Experience with PostgreSQL; Experience with Power Query; Experience scripting for data work (Python preferred; other languages acceptable) to automate checks or repeatable reporting; Experience with data visualization / BI tools (Power BI, Tableau, Grafana, or similar); Experience with AWS services (RDS Postgres, S3, Athena/Glue, IAM) or general cloud data patterns; Experience with engineering/asset-heavy or mechanical/industrial domain context; Experience with time-series data concepts and tools (AVEVA PI / PI Vision); Experience with asset management systems (IBM Maximo); Experience with database tools (Databricks, MongoDB, DBeaver) and query performance tuning. Responsibilities include but are not limited to the following: Develop and maintain SQL queries, views, and datasets to support reporting and operational use cases; Write and optimize SQL in PostgreSQL including multi-table joins, aggregations, window functions, and validation queries; Build repeatable data quality checks (duplicates, missing keys, invalid values, stale data) and document root cause and remediation; Support database updates and controlled data fixes with traceability including change logs, validation steps, and rollback awareness; Create reporting outputs and lightweight visualizations using Excel and/or Power BI, ensuring results are explainable and verifiable; Translate vague stakeholder requests into clear definitions, requirements, and acceptance criteria before building; Maintain documentation: data definitions, mappings, refresh logic, audit results, and data trustworthiness notes; 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.

Requirements

Availability to work 100% of the time at the Client's site in Palm Beach Gardens, FL (required)
Experience with SQL (SQL Server, Oracle, or MySQL acceptable)
Experience with relational database fundamentals: keys, constraints, cardinality, and data integrity
Experience debugging data issues (join row explosions, mismatched totals, missing records) and proving correctness with validation checks
Experience building repeatable data audits/reconciliations and documenting findings and fixes
Experience with Excel for data validation and reporting (pivots, lookups)

Nice To Haves

Experience with PostgreSQL
Experience with Power Query
Experience scripting for data work (Python preferred; other languages acceptable) to automate checks or repeatable reporting
Experience with data visualization / BI tools (Power BI, Tableau, Grafana, or similar)
Experience with AWS services (RDS Postgres, S3, Athena/Glue, IAM) or general cloud data patterns
Experience with engineering/asset-heavy or mechanical/industrial domain context
Experience with time-series data concepts and tools (AVEVA PI / PI Vision)
Experience with asset management systems (IBM Maximo)
Experience with database tools (Databricks, MongoDB, DBeaver) and query performance tuning

Responsibilities

Develop and maintain SQL queries, views, and datasets to support reporting and operational use cases
Write and optimize SQL in PostgreSQL including multi-table joins, aggregations, window functions, and validation queries
Build repeatable data quality checks (duplicates, missing keys, invalid values, stale data) and document root cause and remediation
Support database updates and controlled data fixes with traceability including change logs, validation steps, and rollback awareness
Create reporting outputs and lightweight visualizations using Excel and/or Power BI, ensuring results are explainable and verifiable
Translate vague stakeholder requests into clear definitions, requirements, and acceptance criteria before building
Maintain documentation: data definitions, mappings, refresh logic, audit results, and data trustworthiness notes

Benefits

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

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume