Senior Data Engineer, Reporting

CreatorIQ is the operating system for creator-led growth trusted by more than 1300 global brands and agencies.

Were 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. Its been named a Fastest-Growing Company in North America on the Deloitte Technology Fast 500 for four years was named a leader in IDC MarketScape: Worldwide Influencer Marketing Platforms for Large Enterprises in 2025 was named a Leader by The Forrester New Wave: Influencer Marketing Solutions and has been consistently recognized by G2 as a Leader and is 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.

Were seeking passionate innovative minds to join our journey. Be a part of our dynamic team and lets 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 this role youll play a key part in shaping scalable reliable data infrastructure that empowers our enterprise partners with accessible meaningful analytics. Youll 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 youll develop systems that gracefully process millions of social media posts creator metrics and campaign performance datawhile 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.

In this role youll 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 youll 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 databases: ClickHouse BigQuery Redshift Snowflake

• Knowledge of streaming data platforms: Apache Kafka Pulsar Kinesis

• Understanding of distributed systems and database replication

Analytics & BI Experience

• Experience with embedded analytics platforms and dashboard frameworks

• Knowledge of semantic modeling and metrics layers

• Familiarity with data visualization and self-service analytics

Advanced Technical Skills

• 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

Confidence can sometimes hold us back from applying for a job. But well let you in on a secret: theres no such thing as a perfect candidate. Have 50% of the criteria Excited about this opportunity Passionate about what we do at CreatorIQ Please apply! CreatorIQ is a place where everyone can grow.

What you will get from us:

• 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 youll need to become successful here from your first day with us.

• Surprise meal stipends: work from home cant 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!).

Who we are:

CreatorIQ is the operating system for creator-led growth. Trusted by more than 1300 global brands and agenciesincluding Burson Delta Air Lines Google LVMH Nestlé and SephoraCreatorIQ unifies creator marketing across paid owned earned commerce and community into one seamless enterprise-grade ecosystem. With industry-leading intelligence infrastructure rigorous compliance and security standards and integrations with Meta Snapchat TikTok YouTube and more CreatorIQ empowers brands and agencies to harness the creator economy as a strategic growth engine. CreatorIQ is a global company headquartered in Los Angeles with offices in Austin New York San Francisco London Manila and Warsaw. Learn more at and follow us on LinkedIn and Instagram.

At CreatorIQ we believe that diversity is the key to unlocking our full potential. We are committed to fostering an inclusive equitable and empowering work environment where everyone can thrive regardless of race ethnicity gender sexual orientation age religion disability or any other characteristic that makes us unique. By embracing our core values of being intentional pursuing excellence every day embracing the journey together being a good human and staying focused on whats important we create an atmosphere that promotes collaboration and growth. Join us to celebrate differences innovate together and be a part of a business that is disrupting the marketing industry.

Compensation benefits and beyond:

We understand that a comprehensive benefits package plays a significant role in your overall compensation. To gain more insight into the various components of our total compensation we invite you to review our benefits and perks.

AI Transparency Notice

We may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications and note taking during interviews. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please refer to our Global Candidate Privacy Notice.

Required Experience:

Senior IC