Senior Data Engineer

Stack

Responsibilities

• ▹Design and implement ETL pipelines migrating from transactional databases to analytical data warehouses
• ▹Create real-time data ingestion systems for campaign data and business intelligence
• ▹Build multi-tenant data models with partitioning strategies for enterprise-scale clients
• ▹Develop data quality frameworks with validation, monitoring, and alerting
• ▹Implement Row-Level Security (RLS) and Role-Based Access Control (RBAC)
• ▹Design dynamic permission models supporting organization-level data access
• ▹Build session-based context management for secure multi-tenant queries
• ▹Create 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
• ▹Build dashboard data sources with optimized SQL transformations

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 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

Nice to have

• ▹Experience with columnar databases: ClickHouse, BigQuery, Redshift, Snowflake
• ▹Knowledge of streaming data platforms: Apache Kafka, Pulsar, Kinesis
• ▹Understanding of distributed systems and database replication
• ▹Experience with embedded analytics platforms and dashboard frameworks

About the company

A company building a multi-tenant influencer marketing analytics platform that processes millions of social media posts, creator metrics, and campaign performance data for enterprise clients.