Job Closed
This listing is no longer active.
The most trusted software to unify and power advanced influencer marketing for the world’s most innovative enterprises
Senior Data Engineer, Reporting
Location
Canada
Posted
106 days ago
Salary
CA$150K - CA$171K / year
Seniority
Senior
Job Description
Senior Data Engineer, Reporting
CreatorIQ
• 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
Job 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
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Senior Platform & Data Architect – Germany
Transparent HiringTech recruiting and relocation services for German companies seeking to acquire and relocate IT talents from abroad.
• Own the architecture and delivery of a scalable internal platform (end-to-end, not just concepts) • Translate business needs into clear technical designs and working systems • Build and improve data pipelines, integrations, and automation • Establish clean foundations for data reliability, reporting, and operational tooling • Collaborate closely with stakeholders across Germany and the US
Azure Data Architect
ExavaluDigital Transformation Consulting Leader with expertise in business/ technology advisory and digital platform solutions
• Data Pipeline Engineering: Architect, build, and maintain complex, real-time, and batch data pipelines using Azure Data Factory, Python/PySpark, and Databricks. • Architecture & Modelling: Design and implement modern data warehouse solutions, data models, and data lakes, optimizing for performance and scalability. • Data Ingestion & Integration: Ingest, cleanse, and transform data from diverse sources into usable data structures for analytics. • Security & Governance: Implement security features, including role-based access control (RBAC), data encryption, and governance via Azure Purview.
Senior Data Engineer
InspirenInspiren offers the most complete and connected ecosystem in senior living. Founded by Michael Wang, a former Green Beret turned cardiothoracic nurse, Inspiren proves that compassionate care and technology can coexist - bringing peace of mind to residents, families, and staff. Our integrated solutions seamlessly fit into existing workflows, capturing everything happening within a community. Backed by nurse specialists and powerful analytics, we provide the data operators need to make informed clinical and operational decisions - driving efficiency, profitability, and better care outcomes.
• Collaborate with engineering, data science, ML, and product analytics teams to develop data models and pipelines for customer-facing applications, research, reporting and machine learning. • Develop, implement and optimize ETL processes for ingesting, processing and transforming large volumes of structured and unstructured data into our data ecosystem • Optimize data models to support efficient data storage and retrieval processes for performance and scalability. • Evaluate and implement a variety of data storage solutions, including RDS, NoSQL, data lakes and cloud storage services. • Work in close partnership with Platform Engineering to influence the direction and needs of the data platform.
Senior Data Engineer
ZigsawOn a mission to help people find the Job of their choice. Fill this: https://forms.gle/fWsXYfgAfEorQZgaA
• Implement robust data infrastructure in AWS, using Spark with Scala • Evolve our core data pipelines to efficiently scale for our massive growth • Store data in optimal engines and formats • Collaborate with our cross-functional teams to design data solutions that meet business needs • Built out fault-tolerant batch and streaming pipelines • Leverage and optimize AWS resources while designing for scale • Collaborate closely with our Data Science and Product teams
