{"@context":"https://schema.org","@type":"JobPosting","title":"Data Engineer (PostgreSQL & Analytics Infrastructure)","description":"\n

Architect the data infrastructure that underpins a multi-tenant SaaS platform. You'll design PostgreSQL schemas with airtight security policies, build zero-downtime migration strategies, ensure data integrity across complex relational models, and create the analytics pipelines that transform raw event data into actionable intelligence. This role demands expertise in data security, schema evolution, and building systems that scale without compromising consistency.

\n \n

Responsibilities:

Design and maintain normalised PostgreSQL schemas with proper indexing strategies and foreign key relationships
Implement Row Level Security (RLS) policies for multi-tenant data isolation
Build and optimise complex SQL queries, CTEs, window functions, and materialised views
Architect ETL/ELT pipelines for ingesting exhibitor, attendee, and transaction data
Configure Supabase Realtime subscriptions and database triggers for event-driven workflows
Design denormalisation strategies and caching layers for high-read analytics workloads
Implement pgvector extensions for semantic search and embedding storage
Build data validation schemas, constraints, and audit logging systems
Create database migration strategies and version-controlled schema changes
Optimise query performance through EXPLAIN ANALYZE, index tuning, and connection pooling

\n \n

Qualifications:

Expert-level PostgreSQL knowledge: query optimisation, indexing (B-tree, GIN, GiST), partitioning, and replication
Deep understanding of relational database design, normalisation (3NF+), and schema evolution
Proficiency with SQL window functions, recursive CTEs, JSON/JSONB operators, and full-text search
Experience with Supabase or similar PostgreSQL-as-a-service platforms
Knowledge of Row Level Security, database roles, and multi-tenant architecture patterns
Familiarity with ETL/ELT tools (dbt, Airbyte, Fivetran) or custom pipeline development
Understanding of data warehousing concepts: star schemas, slowly changing dimensions, fact tables
Experience with database monitoring, query profiling, and performance tuning

\n \n \n

Nice to Have:

Experience with pgvector, PostGIS, or other PostgreSQL extensions
Knowledge of TimescaleDB for time-series analytics
Familiarity with dbt (data build tool) for transformation workflows
Background in building analytics dashboards and BI integrations
Experience with change data capture (CDC) and event sourcing patterns
Understanding of GDPR data handling, anonymisation, and retention policies
Certifications in PostgreSQL or cloud database platforms

\n \n \n

Benefits:

Fully remote position
Competitive salary with equity
Health, dental, and vision insurance
Annual learning budget for certifications and conferences
Latest development hardware
Flexible working hours
Generous PTO and holidays
Database tools and cloud credits budget

\n ","datePosted":"2026-02-04","validThrough":"2026-05-04","employmentType":"FULL_TIME","hiringOrganization":{"@type":"Organization","name":"Wiktis","sameAs":"https://www.wiktis.com","logo":"https://www.wiktis.com/brand/logos/Wiktis-Symbol.webp"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Remote","addressCountry":"US"}},"baseSalary":{"@type":"MonetaryAmount","currency":"USD","value":{"@type":"QuantitativeValue","minValue":100000,"maxValue":145000,"unitText":"YEAR"}},"jobLocationType":"TELECOMMUTE","applicantLocationRequirements":{"@type":"Country","name":"US"}}