What are the responsibilities and job description for the Database Analyst position at Synergy Business Consulting, Inc.?
About the Role
We are 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’ll manage, update, and audit databases, partner with stakeholders to gather requirements, and help ensure our data is accurate, reliable, and usable.
This is a good fit for someone who blends hands-on database skills with a business analyst mindse, someone who can independently clarify needs, translate them into data logic, and validate results end-to-end.
Key Responsibilities
- Database Management: Maintain, update, and audit relational databases (PostgreSQL), ensuring accuracy, consistency, and traceability.
- Query Optimization: Write and optimize SQL queries, including multi-table joins, aggregations, and validation checks.
- Data Quality & Auditing: Perform data quality checks, reconcile discrepancies, and document root causes and fixes. Build and maintain Excel-based audit tools (pivots, lookups, Power Query) for reporting and verification.
- Stakeholder Collaboration: Partner with internal users to gather requirements, challenge unclear requests, and translate business needs into data definitions and logic.
- Documentation: Create and maintain table definitions, field mappings, audit results, and change logs.
- Data Governance: Support process improvements and controls around data updates, permissions, and governance.
Required Qualifications
- SQL Expertise: Strong SQL experience, including PostgreSQL (or equivalent with the ability to ramp up quickly).
- Database Fundamentals: Solid understanding of relational database fundamentals (keys, constraints, normalization concepts, data integrity).
- Data Auditing: Demonstrated experience managing, updating, auditing datasets, and documenting findings/remediation steps for repeatable, traceable work.
- Advanced Excel: Deep knowledge of filters, pivot tables, XLOOKUP/VLOOKUP, and data validation (Power Query is a major plus).
- Analytical Mindset: Comfortable owning ambiguous requests, independently questioning stakeholders to gather requirements, and confirming data definitions before building.
- Communication: Proven ability to investigate inconsistencies, ask probing questions, validate assumptions, and explain complex logic clearly to both technical and non-technical stakeholders.
Nice-to-Have Qualifications
- Mechanical or engineering background/familiarity (or experience supporting engineering/asset-heavy environments).
- Familiarity with asset management and time-series concepts (IBM Maximo, AVEVA PI System, PI Data Archive, PI Vision).
- Familiarity with AWS cloud data patterns (RDS, S3, Athena/Glue, IAM).
- Experience acting as a Business Analyst (defining acceptance criteria, mapping data sources to outputs).
- Familiarity with data access/auditing tools like Quest (e.g., Toad).