Build and maintain SQL-based reporting views that transform complex source data into business-ready analytics views for our enterprise SaaS customers.
Develop standardized SQL logic for business calculations and reporting, including join paths and customer-specific entity relationships (Customer, Users, Projects, Forms, etc.).
Create and maintain performant reporting views, focusing on balancing data access with query optimization, particularly for complex JSONB form data structures.
Support the implementation of role-based access controls and data governance standards across customer reporting environments.
Collaborate with Solution Engineers to translate customer reporting requirements into scalable, standardized reporting solutions.
Assist in optimizing query performance and troubleshooting data model issues while minimizing custom implementations in favor of our standardized view architecture.
Document data model changes and maintain consistency across customer deployments.
4+ years of experience with strong SQL (PostgreSQL preferred)
Experience designing and optimizing database views and materialized views
Familiarity with data modeling principles and dimensional modeling
Experience with JSONB data types and semi-structured data transformation
Familiarity with enterprise SaaS multi-tenant architectures
Excellent communication skills for technical documentation and stakeholder collaboration