Senior Data Engineer, Reporting

🕒 February 26

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

CreatorIQ

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 2014

📱 Media

☁️ SaaS

Marketing • Media • SaaS

CreatorIQ is a leading influencer marketing software platform that assists brands across various industries in growing, managing, scaling, and measuring their creator programs. It provides tools for discovering creators, executing campaigns, and optimizing performance with advanced analytics. CreatorIQ is designed to enhance brand engagement by leveraging the power of content and connections with trusted creators and communities. The platform is used by global enterprises, media and sports organizations, and direct-to-consumer brands to track, manage, and maximize their influencer marketing efforts.

📋 Description

• 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

🎯 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

🏖️ Benefits

• Health insurance • Retirement plans • Paid time off • Flexible work arrangements • Professional development • Surprise meal stipends • Whole Health Package • Work from home stipend