The Data Analyst will develop and maintain SQL reporting views, optimize database performance, ensure data governance, and collaborate with engineers to meet reporting requirements.
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 PositionBuild 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.
- 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.
- 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
Top Skills
Jsonb
Postgres
SQL
Similar Jobs
Artificial Intelligence • Consumer Web • Edtech • HR Tech • Information Technology • Software • Conversational AI
The Principal HR Data Analyst analyzes HR data to provide insights for business decisions, develops dashboards, and tracks metrics to support HR leadership.
Top Skills:
ExcelPower BITableauWorkday
.png)
Artificial Intelligence • Blockchain • Fintech • Financial Services • Cryptocurrency • NFT • Web3
The Onchain Data Analyst & Researcher conducts investigations into illicit blockchain activity, develops analytics methods, collaborates with teams, and monitors emerging threats.
Top Skills:
AIChainbaseDune AnalyticsFlipsideSQL
Fintech • Mobile • Software • Financial Services
The Senior Fraud Data Analyst develops data-driven fraud decisioning strategies, analyzes large datasets, and collaborates with stakeholders to enhance fraud prevention and optimize detection accuracy.
Top Skills:
PythonSQL
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
