Data Analyst

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.

Requirements

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