CreatorIQ is the AI-native operating system for creator-led growth trusted by more than 1,300 global brands and agencies.

We're on a mission to make businesses more human, and humans more impactful. We operate by our values — be intentional, pursue excellence every day, embrace the journey together, and be a good human — every day. CreatorIQ has earned the title of best companies to work for in multiple programs, including BuiltIn LA and NY, was named a Leader by The Forrester New Wave™: Influencer Marketing Solutions, and recognized by G2 as a Leader, Best Customer Relationship, G2 Top 100 Fastest-Growing Products, and rated 5 stars on Influencer MarketingHub. We operate in a flexible work model that combines both in-person and remote work to boost collaboration, enhance innovation, and adapt to individual work styles.

We're seeking passionate, innovative minds to join our journey. Be a part of our dynamic team and let's transform the industry together!

Senior Data Engineer

Reporting ciq

• 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
• 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
• Knowledge of semantic modeling and metrics layers
• Familiarity with data visualization and self-service analytics
• Experience with real-time data processing and event streaming
• Knowledge of data mesh or data fabric architectures
• Understanding of machine learning pipeline integration
• Experience with data lineage and data catalog tools
• People: work with talented, collaborative, and friendly people who love what they do.
• Guidance: utilize our learning platform to fully get the training and tools you'll need to become successful here from your first day with us.
• Surprise meal stipends: work from home can't stop the enjoyment of someone else making a meal for you!
• Work/life harmony: vacation, floating and set holidays, wellness allowance, and paid parental leave.
• Whole Health Package: medical, dental, vision, life, disability insurance, and more.
• Work from home stipend: to assist you in setting up a home office that works for you (or buy a new dog leash - your choice!).