Data Analyst

Authorium

148d • $80,000 - $95,000

About The Position

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

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

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.

Benefits

• 100% benefits coverage for employee
• 401K Profit Share plan
• Flexible PTO
• Home office stipend
• Comprehensive wellness benefits
• Commuter stipend for hybrid roles

What This Job Offers

• Job Type: Full-time
• Number of Employees: 51-100 employees