The Data Analyst will develop and maintain SQL-based reporting views, optimize queries, and support data governance standards for enterprise SaaS customers.
About Authorium
Requirements
Benefits
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.
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
- 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
Top Skills
Jsonb
Postgres
SQL
Similar Jobs
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Lead and manage data analysis projects at Pfizer, utilizing strong communication and analytical skills to improve processes and guide operational teams.
Top Skills:
Edoc FrameworkPower BITableau
Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
The HR Data Analyst manages HR cases, utilizing data analytics to ensure case integrity, produce reports and visualizations, and drive training and process improvements.
Top Skills:
ExcelPower BI
Fintech • HR Tech • Financial Services
As a Data Analyst, you'll drive the analytics process, collaborate across teams, design dashboards, optimize data pipelines, and generate actionable insights to support executive decisions.
Top Skills:
DashboardsData ModelingData VisualizationEtl/Elt Pipelines
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
