Senior Data Engineer, Reporting

📋 Description

• • **Shape the Future of Creator Economy Analytics:** CreatorIQ is seeking a highly skilled and motivated Senior Data Engineer to play a pivotal role in architecting and building the foundation of our next-generation, AI-native, multi-tenant influencer marketing analytics platform. This is a unique opportunity to influence the scalability, reliability, and performance of our data infrastructure, directly empowering over 1,300 global brands and agencies with accessible, meaningful, and real-time insights at an enterprise scale.
• • **Drive Innovation in Data Infrastructure:** You will be instrumental in designing and implementing robust ETL pipelines, migrating data from transactional databases to sophisticated analytical data warehouses. This involves creating efficient, real-time data ingestion systems that seamlessly process vast amounts of campaign data, intricate user metrics, and critical business intelligence information. Your expertise will be crucial in developing multi-tenant data models, employing advanced partitioning strategies to ensure data integrity and performance for our largest enterprise clients.
• • **Champion Data Security and Trust:** A core aspect of this role involves architecting and implementing multi-tenant security measures. You will design and deploy Row-Level Security (RLS) and Role-Based Access Control (RBAC) within our analytical databases, creating dynamic permission models that support granular data access at both organization and division levels. Building secure, session-based context management for multi-tenant queries and establishing comprehensive audit trails and access logging for stringent compliance requirements will be key responsibilities, ensuring the utmost data isolation, security, and trust for our enterprise partners.
• • **Optimize Performance for Demanding Workloads:** You will be tasked with optimizing data performance at an unprecedented scale. This includes designing database schemas with advanced partitioning and indexing strategies, building materialized views and aggregated tables to support real-time analytics, and implementing cutting-edge query optimization, data skipping, and compression techniques. Your efforts will ensure sub-second query performance, even under high-concurrency loads from embedded dashboard usage, providing a seamless analytical experience for our clients.
• • **Integrate and Enhance Analytics Platforms:** This role requires close collaboration with analytics and product teams to build optimized data sources for our embedded analytics platform. You will handle complex data structures, implement efficient parsing requirements, and create flat, denormalized tables specifically optimized for consumption by embedded analytics tools. Furthermore, you will develop solutions for custom field handling to accommodate tenant-specific metadata requirements, ensuring flexibility and extensibility.
• • **Collaborate and Lead:** As a Senior Data Engineer, you will work within a dynamic, collaborative environment, contributing to a supportive and dependable data ecosystem. You will partner with cross-functional teams, including product managers, software engineers, and data scientists, to deliver high-impact solutions. Your technical leadership and mentorship will be valued as we collectively pursue excellence and embrace the journey together.
• • **Contribute to a Mission-Driven Company:** CreatorIQ is on a mission to make businesses more human and humans more impactful. By joining our team, you will be part of a company recognized as a Leader by Forrester and G2, and consistently ranked among the best companies to work for. Your work will directly contribute to empowering brands and agencies to harness the creator economy as a strategic growth engine, driving significant transformation in the industry.
• • **Embrace a Flexible Work Model:** CreatorIQ operates with a flexible work model that blends in-person collaboration with remote work, fostering innovation, enhancing productivity, and adapting to diverse work styles. This role is based in Canada and offers remote work flexibility.
• • **Uphold Core Values:** You will operate daily by CreatorIQ's core values: be intentional, pursue excellence every day, embrace the journey together, and be a good human. These values are the bedrock of our culture and guide our interactions and decisions, creating an environment where everyone can grow and thrive.