Authorium is transforming the way agencies manage complex, document-centric workflows. Our unified platform integrates essential administrative functions, from Budgeting to Procurement to Contracting, streamlining government operations. By consolidating data from documents, emails, and spreadsheets into a unified data layer, we drive insights and visibility.
Requirements
- 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
Responsibilities
- 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
Other
- Employees located within 30 miles of our hub cities—San Francisco, Sacramento, and Washington, D.C. —are required to work onsite from Tuesday to Thursday. Remote work is available on other days.
- Excellent communication skills for technical documentation and stakeholder collaboration
