Database Analyst

Database Analyst Location: Juno, FL (Onsite) Contract Length: 6 Months Pay Rate: $40-45/hr About the Role We're seeking a database-focused analyst with strong SQL (PostgreSQL) skills and a business-analysis mindset. This role is ideal for someone who enjoys digging into data, asking "why" before "how," and ensuring data accuracy, integrity, and traceability. You'll work hands-on with relational databases while partnering closely with stakeholders to clarify requirements, challenge assumptions, and translate business needs into clean, auditable data logic. This role blends technical SQL expertise with critical thinking and stakeholder collaboration. Key Responsibilities • Maintain, update, and audit PostgreSQL relational databases to ensure data accuracy, consistency, and traceability • Write and optimize complex SQL queries (multi-table joins, aggregations, validation checks) • Perform data quality audits, reconcile discrepancies, and document root causes and remediation steps • Build and maintain Excel-based audit and reporting tools (pivot tables, lookups, Power Query as applicable) • Partner with internal stakeholders to gather requirements, clarify ambiguous requests, and define data logic • Translate business requirements into clear data definitions and validation rules • Create and maintain documentation including: • Table and field definitions • Field mappings • Audit results • Change logs • Support continuous improvement of data governance, controls, and update processes Required Qualifications • Strong SQL experience, including PostgreSQL (or similar relational databases with ability to ramp quickly) • Solid understanding of relational database concepts (keys, constraints, normalization, data integrity) • Demonstrated experience managing, updating, and auditing datasets/databases • Advanced Excel skills (filters, pivot tables, XLOOKUP/VLOOKUP; Power Query a plus) • Experience performing data audits with clear, repeatable, and traceable documentation • Comfortable owning ambiguous requests and independently gathering requirements • Ability to clearly explain logic, assumptions, and findings to both technical and non-technical stakeholders • Strong analytical and critical-thinking skills; proactively identifies risks and edge cases • Excellent written and verbal communication skills Nice-to-Have Qualifications • Mechanical or engineering background, or experience supporting asset-heavy environments • Familiarity with AVEVA PI (PI System, PI Vision) or time-series data • Experience with IBM Maximo (asset management, work orders, equipment hierarchies) • Exposure to AWS data services (RDS, S3, Athena/Glue, IAM basics) • Experience functioning as a Business Analyst (requirements gathering, acceptance criteria, data mapping) • Familiarity with data access or auditing tools such as Quest / Toad ...