Cloud Data Engineer Dimensional Warehousing (Ottawa)

Cloud Data Engineer Dimensional Warehousing (Ottawa)

19 Nov
|
Kindsight
|
Ottawa

19 Nov

Kindsight

Ottawa

Cloud Data Engineer shaping dimensional warehouses, dbt transformations, and AI-ready analytics for Kindsight's fundraising intelligence products.This hands-on role builds and maintains the data platform behind customer-facing analytics products. You will transform lake data through Redshift or Snowflake using medallion architecture, incremental logic, slowly changing dimensions, and derived metrics. The work combines advanced SQL, AWS services, data quality, and multi-tenant analytics at scale.Key Responsibilities:Develop medallion architecture and dimensional models in dbtImplement incremental logic and slowly changing dimensionsWrite aggregation and validation queries against large datasetsExtend configuration-driven pipelines for customer onboardingSupport QuickSight or Tableau reporting data modelsRequirements:Three-plus years operating production data engineering pipelinesAdvanced SQL, including window functions and CTEsTwo-plus years with cloud data warehousesTwo-plus years building tested incremental transformation modelsBachelor's degree or equivalent practical experienceBuild reliable dimensional data systems with dbt, SQL, AWS, and warehouse optimization for Kindsight analytics.

📌 Cloud Data Engineer Dimensional Warehousing (Ottawa)
🏢 Kindsight
📍 Ottawa

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: cloud data engineer dimensional warehousing (ottawa) / ottawa