Database Analyst
Indexed description
- 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
- 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/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 (repeatable + traceable work)
- Comfortable owning ambiguous requests and independently questioning stakeholders to gather requirements and confirms data definitions before building
- Can explain logic and assumptions clearly to both technical and non-technical stakeholders
- Shows critical thinking, 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; comfortable working directly with stakeholders
- Mechanical or engineering background/familiarity (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, mapping data sources to outputs
- Familiarity with tools like Quest (e.g., Toad) or data access/auditing tools
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking “Apply Today” you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search