Senior Data Engineer, Reporting

Creator

IQ 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. Creator

IQ has earned the title of best companies to work for in multiple programs, including Built In 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 Marketing Hub. 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!

CIQ is seeking a Senior Data Engineer to thoughtfully architect and build the foundation of our next-generation multi-tenant influencer marketing analytics platform. In this role, you’ll play a key part in shaping scalable, reliable data infrastructure that empowers our enterprise partners with accessible, meaningful analytics. You’ll work with modern analytical databases and BI platforms to help deliver clear, real-time insights at a significant scale.

This is a highly impactful and collaborative position where you’ll develop systems that gracefully process millions of social media posts, creator metrics, and campaign performance data—while upholding strong standards of data isolation, security, and trust for our enterprise clients. Your work will contribute to a supportive, dependable data ecosystem that enables teams and customers to thrive.

Location
:
Canada (Remote)

In this role, you’ll get to:

Build Scalable Data Infrastructure

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

Architect Multi-Tenant Security

• 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

Optimize Performance at Scale

• 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

Integrate Analytics Platform

• 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

Who you are and what you’ll need for this position:

• 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

Bonus Points

Database Experience

• Experience with columnar…