Design and implement ETL pipelines migrating from transactional databases to analytical data warehouses
Create real-time data ingestion systems processing campaign data, user metrics, and business intelligence
Build multi-tenant data models with proper partitioning strategies for enterprise-scale clients
Develop data quality frameworks with comprehensive validation, monitoring, and alerting
Implement Row-Level Security (RLS) and Role-Based Access Control (RBAC) in analytical databases
Design dynamic permission models supporting organization-level and division-level data access
Build session-based context management for secure multi-tenant queries
Create comprehensive audit trails and access logging for compliance requirements
Design database schemas with advanced partitioning and indexing strategies
Build materialized views and aggregated tables for real-time analytics
Implement query optimization, data skipping, and compression techniques
Handle high-concurrency embedded dashboard usage with sub-second query performance
Build dashboard data sources with optimized SQL transformations
Handle complex data structures and parsing requirements
Create flat, denormalized tables optimized for embedded analytics consumption
Implement custom field handling for tenant-specific metadata requirements

5+ years of data engineering experience with production-scale systems
Expert-level SQL skills with analytical databases (columnar databases preferred)
Strong Python programming with data libraries: pandas, numpy, pyarrow
Experience with ETL orchestration tools: Apache Airflow, Prefect, dbt, or similar
Deep understanding of analytical databases, partitioning strategies, and OLAP optimization
Experience building SaaS data platforms with tenant isolation requirements
Knowledge of Row-Level Security (RLS) implementation in analytical databases
Understanding of RBAC patterns and session-based access control
Experience with authentication flows in data systems
Familiarity with compliance requirements (SOC2, GDPR) for multi-tenant data

Senior Data Engineer, Reporting

Key skills