Senior Fabric Data Engineer modernizing enterprise data for Canadian IT consulting clients. Building Microsoft Fabric pipelines, curated datasets, security controls, and analytics - ready models.
About the role
- Senior Data Engineer building scalable analytics infrastructure at CreatorIQ for enterprise partners. Focused on data architecture and real-time insights for influencer marketing.
Responsibilities
- 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
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Staff Data Engineer building scalable pipelines and lakehouse architecture for Sonatype, a software supply chain security company. Driving trusted analytics, ML, and business intelligence data with Databricks, Spark, and modern cloud technologies.
Senior Fabric Data Engineer modernizing learning - platform data for Cornerstone Galaxy. Building Microsoft Fabric pipelines, curated datasets, governance, and analytics - ready integrations.
GCP Data Platform Engineer maintaining and optimizing production data platforms for Innodata, a global data engineering and AI services company. Supporting Airflow pipelines, GCP infrastructure, reliability, and troubleshooting.
Senior Data Engineer building finance data pipelines and models for Instacart’s grocery delivery platform. Owning financial data infrastructure supporting accounting, billing, invoicing, and reporting.
Senior Data Architect modernizing Alberta justice data marts into an integrated enterprise data warehouse. Designing ETL, Power BI testing, data models, governance, and reporting architecture.
Senior Data Architect integrating Alberta court data marts into an enterprise data warehouse. Designing ETL, data models, governance practices, and Power BI validation reports.
LP
Senior Data Engineer
LinkedIn Recruiter Post
Senior Data Engineer contract role: design/build ETL/ELT pipelines using Azure stack, primarily remote in Canada, occasional onsite in Edmonton.
Data & Analytics Engineer building scalable data platforms for Ledgebrook, an insurance company. Designing pipelines, governance, and cloud data systems while partnering with technical and insurance teams.
Data Engineer building scalable pipelines for SumerSports’ football intelligence platform. Supporting deep learning, video, LLM, analytics, and AI - driven products across sports.