Company Name: CreatorIQ

Job Details: 2,Locations,Remote,or,Hybrid,289K-325K,Senior,level

Job Url: https://builtin.com/job/senior-data-engineer-reporting/7090179

Job Description: CreatorIQ has earned the title of best companies to work for in multiple programs including BuiltIn Austin, LA and NY, was named a 2024 Deloitte 2024 Technology Fast 500 winner, Leader by The Forrester New Wave™: Influencer Marketing Solutions, 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.Be a Part of Our Dynamic Team and Transform the Industry Together!Senior Data Engineer, ReportingCIQ is seeking a Senior Data Engineer to architect and build the backbone of our next-generation multi-tenant influencer marketing analytics platform. You'll be responsible for designing scalable data infrastructure that serves enterprise partners through scalable analytics, working with modern analytical databases and BI platforms to deliver real-time insights at massive scale.This is a high-impact role where you'll build systems that process millions of social media posts, creator metrics, and campaign performance data while ensuring strict data isolation and security for our enterprise clients.The location for this role is Poland.In this role, you’ll get to:Build Scalable Data InfrastructureDesign and implement ETL pipelines migrating from transactional databases to analytical data warehousesCreate 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 SecurityImplement Row-Level Security (RLS) and Role-Based Access Control (RBAC) in analytical databasesDesign dynamic permission models supporting organization-level and division-level data accessBuild session-based context management for secure multi-tenant queriesCreate comprehensive audit trails and access logging for compliance requirementsOptimize Performance at ScaleDesign database schemas with advanced partitioning and indexing strategiesBuild materialized views and aggregated tables for real-time analyticsImplement query optimization, data skipping, and compression techniquesHandle high-concurrency embedded dashboard usage with sub-second query performanceIntegrate Analytics PlatformBuild dashboard data sources with optimized SQL transformationsHandle complex data structures and parsing requirementsCreate flat, denormalized tables optimized for embedded analytics consumptionImplement custom field handling for tenant-specific metadata requirementsWho you are and what you’ll need for this position:5+ years of data engineering experience with production-scale systemsExpert-level SQL skills with analytical databases (columnar databases preferred)Strong Python programming with data libraries: pandas, numpy, pyarrowExperience with ETL orchestration tools: Apache Airflow, Prefect, dbt, or similarDeep understanding of analytical databases, partitioning strategies, and OLAP optimizationExperience building SaaS data platforms with tenant isolation requirementsKnowledge of Row-Level Security (RLS) implementation in analytical databasesUnderstanding of RBAC patterns and session-based access controlExperience with authentication flows in data systemsFamiliarity with compliance requirements (SOC2, GDPR) for multi-tenant dataBonus PointsDatabase ExperienceExperience with columnar databases: ClickHouse, BigQuery, Redshift, SnowflakeKnowledge of streaming data platforms: Apache Kafka, Pulsar, KinesisUnderstanding of distributed systems and database replicationAnalytics & BI ExperienceExperience with embedded analytics platforms and dashboard frameworksKnowledge of semantic modeling and metrics layersFamiliarity with data visualization and self-service analyticsAdvanced Technical SkillsExperience with real-time data processing and event streamingKnowledge of data mesh or data fabric architecturesUnderstanding of machine learning pipeline integrationExperience with data lineage and data catalog toolsConfidence can sometimes hold us back from applying for a job. But we'll let you in on a secret: there's 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, Easyllama, to 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!Who we are:CreatorIQ is the leading creator marketing platform brands and agencies rely on to maximize creator marketing programs. Its enterprise-grade workflows and industry-leading intelligence deliver AI-powered creator discovery, unified program management, and standardized measurement that is safe, seamless, smart, and built for scale. Thousands of global organizations use CreatorIQ, including Nestlé, Movers+Shakers, RQ, Sephora, Unilever, and more. CreatorIQ is a global company headquartered in Los Angeles with offices in Austin, San Francisco, London, Manila, and Warsaw.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 client-focused, putting team members first, leading with empathy, ensuring a no jerks policy, and staying focused on what's 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.Compensation Range: PLN 289K - PLN 325K#BI-Remote