About the role

  • Database-focused analyst with SQL experience for IT software development, maintaining and auditing PostgreSQL databases while collaborating with internal teams for data accuracy.

Responsibilities

  • Maintain, update, and audit relational databases (PostgreSQL), ensuring accuracy, consistency, and traceability.
  • Write and improve SQL queries, including multi-table joins, aggregations, and validation checks.
  • Perform data quality checks, reconcile discrepancies, and document causes and fixes.
  • Build 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 our needs into data definitions and logic.
  • Create documentation: table definitions, field mappings, audit results, and change logs.
  • Support process improvements and controls around data updates, permissions, and governance.

Requirements

  • SQL experience, including PostgreSQL (or equivalent with an ability to ramp quickly).
  • Experience with relational database fundamentals (keys, constraints, normalization concepts, data integrity).
  • Demonstrated experience updating, and auditing datasets/databases.
  • Advanced Excel skills (filters, pivot tables, XLOOKUP/VLOOKUP, data validation; Power Query).
  • Demonstrated experience performing data audits and documenting findings, remediation steps, and outcomes (repeatable and traceable work).
  • Comfortable managing ambiguous requests and independently questioning partners to gather requirements and confirm data definitions before building.
  • Can explain logic and assumptions to all kinds of partners.
  • Show experience approaching a problem from different angles, analyzing pros and cons of different solutions, asking “why,” identifying risks and edge cases, and proposing better approaches rather than implementing blindly.
  • Experience investigating inconsistencies, asking probing questions, and validating assumptions.

Benefits

  • Comprehensive Health and Income Protection Benefits
  • 401(k) Savings Plan
  • Paid Vacations for Qualifying Positions

Job title

IT Software Engineer – Analyst

Job type

Experience level

Mid levelSenior

Salary

$45 - $50 per hour

Degree requirement

High School Diploma

Tech skills

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job