Cloud Data Engineer Dimensional Warehousing
Summary
Cloud Data Engineer at Kindsight builds and maintains the data platform behind its fundraising intelligence analytics products: dimensional modeling and medallion architecture in dbt on Redshift/Snowflake, incremental logic, slowly changing dimensions, data validation, and BI support with QuickSight/Tableau on AWS.
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 dbt
- Implement incremental logic and slowly changing dimensions
- Write aggregation and validation queries against large datasets
- Extend configuration-driven pipelines for customer onboarding
- Support QuickSight or Tableau reporting data models
Requirements:
- Three-plus years operating production data engineering pipelines
- Advanced SQL, including window functions and CTEs
- Two-plus years with cloud data warehouses
- Two-plus years building tested incremental transformation models
- Bachelor’s degree or equivalent practical experience
Build reliable dimensional data systems with dbt, SQL, AWS, and warehouse optimization for Kindsight analytics.
Skills
Sign in to read and join the discussion.