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
Senior Software Developer responsible for design and development of software systems for medical devices at Terumo BCT. Collaborating with cross - functional teams to ensure compliance and quality of software solutions.
Software Developer I involved in developing software for medical devices at Terumo BCT. Collaborating with engineers and adhering to regulated software practices in a quality - driven environment.
Software Developer II focusing on design, development, and maintenance of software for regulated medical devices. Collaborating with cross - functional teams to ensure compliance and performance.
Full Stack Engineer designing and building AI - powered products transforming customer support at Forethought. Work with a collaborative team to deliver exceptional customer experiences in a hybrid role.
Cloud Software Engineer developing scalable cloud ecosystems at CrowdStrike, leveraging Golang & Python for backend solutions. Focusing on distributed systems and collaborative development practices.
Lead Software Engineer developing comprehensive technology solutions for financial services. Handling design, development, and stakeholder coordination in a hybrid work environment.
Senior Technical Lead/Architect specializing in AWS - based streaming data pipelines and event - driven capabilities. Designing and implementing robust solutions for a high - impact financial data platform.
Senior Engineer managing data products for performance marketing at TickPick. Building and optimizing pipelines and analytics for growth - focused decision - making.
Software Developer applying programming skills in business applications for a market - leading company. Engaging in professional development and cloud transformation initiatives.