IT Software Developer Analyst-Level 2 - Experienced (6 - 10 Years) / Database Analyst / Data Quality & Requirements Specialist
IT Software Developer Analyst – Level 2 / Database Analyst / Data Quality & Requirements Specialist – Juno Beach, FL (On-site)
About the Role
Our client is seeking a database-focused analyst with strong SQL (PostgreSQL) skills and a sharp eye for detail. This person is naturally curious, asks "why?" before "how?", and isn't afraid to challenge assumptions to protect data integrity and improve processes. You will manage, update, and audit databases, partner with stakeholders to gather requirements, and help ensure our data is accurate, reliable, and usable.
This is a great fit for someone who blends hands-on database skills with a business analyst mindset—someone who can independently clarify needs, translate them into data logic, and validate results end-to-end. The role is a 7-month contract assignment based on-site in Juno Beach, FL.
Key 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 (pivots, lookups, Power Query as applicable) for reporting and verification.
- Partner with internal users to gather requirements, challenge unclear requests, and translate business needs into data definitions and logic.
- Create and maintain documentation: table definitions, field mappings, audit results, and change logs.
- Support process improvements and controls around data updates, permissions, and governance.
Required Qualifications
- Strong SQL experience, including PostgreSQL (or equivalent with ability to ramp quickly).
- Solid understanding of relational database fundamentals (keys, constraints, normalization concepts, data integrity).
- Demonstrated experience managing, updating, and auditing datasets or databases.
- Advanced Excel skills (filters, pivot tables, XLOOKUP/VLOOKUP, data validation; Power Query is a plus).
- Demonstrated experience performing data audits and documenting findings, remediation steps, and outcomes in a repeatable and traceable manner.
- Comfortable owning ambiguous requests and independently questioning stakeholders to gather requirements and confirm data definitions before building.
- Ability to explain logic and assumptions clearly to both technical and non-technical stakeholders.
- Critical thinking mindset: asks "why," identifies risks and edge cases, and proposes better approaches rather than executing blindly.
- Proven ability to investigate inconsistencies, ask probing questions, and validate assumptions.
- Strong written and verbal communication skills; comfortable working directly with stakeholders.
Preferred Skills
- Mechanical or engineering background, or experience supporting engineering/asset-heavy environments.
- Familiarity with AVEVA PI (PI System / PI Data Archive / PI Vision) or time-series data concepts.
- Familiarity with IBM Maximo (asset management / work orders / equipment hierarchies).
- Familiarity with AWS (RDS, S3, Athena/Glue, IAM concepts, basic cloud data patterns).
- Experience acting as a BA: independently gathering requirements, defining acceptance criteria, and mapping data sources to outputs.
- Familiarity with tools like Quest (e.g., Toad) or other data access/auditing tools.
Why Join Us
This contract assignment offers a standard 8-hour shift, Monday through Friday, with weekly timesheet processing. You will work within a structured contingent workforce program that values data integrity and process excellence. The role provides an opportunity to make a tangible impact on data quality and governance while collaborating with engaged stakeholders in a professional environment.
Apply Today
If you are a detail-oriented database analyst who thrives on asking the right questions and delivering reliable data solutions, we encourage you to apply. Take the next step in your career and join a team where your curiosity and expertise will be valued.