Job Details

About Authorium

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. We believe in the power of collaboration and data to transform government operations. Come innovate with us and drive positive change!

About Position

Build and maintain SQL-based reporting views that transform complex source data into business-ready analytics views for our enterprise SaaS customers.

What You'll Be Doing

• 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.

Qualifications

• 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

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.

Benefits

• Salary Range: $80,000-$95,000
• 100% benefits coverage for employee
• 401K Profit Share plan
• Flexible PTO
• Home office stipend
• Comprehensive wellness benefits
• Commuter stipend for hybrid roles