Position Overview:

Build and maintain Customer analytics platform using BigQuery, AlloyDB, and Hasura GraphQL.

Design and optimize complex SQL queries, analyze data schemas, and deliver scalable data solutions. 

Key Responsibilities :

1. Data Architecture & Query Development -

- Design and implement advanced SQL queries in BigQuery for analytics

- Analyze BigQuery schemas to map business requirements to data models

- Build native SQL operations and rollup queries for metrics aggregation

- Create CTEs, window functions, and complex joins for hierarchical data

- Implement parameterized queries with dynamic filtering and grouping

- Data modeling for analytics and reporting - Understanding of complex data hierarchies and relationships

2. BigQuery Optimization

- Analyze query performance using BigQuery execution plans

- Optimize SQL for cost and performance (partitioning, clustering, materialization)

- Recommend schema design improvements and data modeling best practices

- Monitor and tune slow queries and resource usage

3. Domain-Specific Analytics

- Understand business domains (Sales, Finance, Marketing, CX, Churn)

- Translate business metrics into SQL queries and GraphQL APIs

- Implement drill-downs, filters, and aggregations by domain

4. Data Pipeline & Integration

- Implement data quality checks and validation queries

- Design ETL/ELT patterns for data transformation

5. Technical Documentation

- Document SQL query logic, data models, and API patterns

- Maintain data dictionary and schema documentation

- Document optimization strategies and performance improvements

Required Technical Skills

Core Technologies -

- BigQuery: Advanced SQL, schema design, query optimization, partitioning/clustering

- SQL: Complex CTEs, window functions, aggregations, joins, subqueries

- Hasura GraphQL: DDN configuration, HML metadata, models, connectors, lifecycle hooks

- PostgreSQL/AlloyDB: Schema design, query optimization, metadata management

Programming & Tools -

- Languages: SQL (BigQuery dialect), JavaScript/TypeScript

- Version Control: Git workflows, code review

- API Development: REST/GraphQL, API design patterns

- Caching: Redis, caching strategies, TTL management

Data Engineering Concepts -

- Data modeling: Dimensional modeling, star/snowflake schemas

- ETL/ELT: Data transformation pipelines

- Performance optimization: Query tuning, indexing, materialization

- Data quality: Validation, error handling, data profiling

Preferred Qualifications -

Experience - 7+ years in data engineering, backend development, or analytics engineering

- 3+ years with BigQuery in production

- 2+ years with Hasura GraphQL (DDN preferred)

- Experience building customer analytics platforms