Data Engineer

Company Overview

 Job Overview

Startup tech company. They offer a no‑code AI workflow platform designed to help commercial real estate professionals — including brokers, landlords, and retail operators — simplify and automate routine and time‑intensive tasks. The core idea is to reduce manual busywork that slows down deal cycles and drains time. Their platform lets users: Build custom AI workflows in minutes without writing code Automate site analysis and research (e.g., evaluating location data used in property decisions) Keep deal pipelines up to date by automatically running tasks that would normally require manual input Trigger outreach or next steps based on workflow results (e.g., follow‑ups) Integrate conversational AI with visual workflow builders so teams can interact with their data naturally while the automation runs behind the scenes 24/7.

 
Job Description

We are looking for a skilled Data Engineer to design, optimize, and maintain the data architecture that powers our BI environment. This role focuses on building scalable Big Query DataMart's, optimizing data models, and ensuring reliable data pipelines to support analytics and reporting.

The ideal candidate has strong experience in cloud data warehousing, data modelling, and building analytics-ready datasets that enable efficient BI consumption.

Key Responsibilities

• Data Architecture & Engineering
• Design, build, and maintain Big Query DataMart's and analytical tables for BI reporting
• Develop scalable data models (star schema, snowflake, or denormalized) optimized for analytics workloads
• Optimize query performance and storage efficiency within cloud data warehouses
• Collaborate with BI teams to ensure datasets align with semantic models and dashboards
• Data Pipeline & Transformation
• Build and maintain data pipelines for data ingestion, transformation, and loading into analytics environments
• Implement transformation workflows using SQL or frameworks such as dbt
• Ensure data quality, validation, and consistency across datasets
  
• Data Governance & Performance
• Maintain data standards, naming conventions, and proper documentation
• Implement governance practices, including schema management and version control
• Monitor and troubleshoot pipeline failures and data inconsistencies
• Work closely with BI specialists to ensure datasets support semantic layer requirements
• Deliver optimized datasets that minimize the need for heavy transformations within BI tools

Required Qualifications

• 3+ years of experience in Data Engineering or Analytics Engineering
• Strong SQL expertise for analytical workloads
• Experience with cloud data warehouses (Big Query, Redshift, Snowflake, or similar)
• Proven experience in designing star schema or dimensional data models
• Experience building analytics-ready Datamart's
     
• Preferred Qualifications
• Experience with dbt or similar data transformation frameworks
• Experience working with BI tools such as Looker, Tableau, or Power BI
  
• Background in retail or multi-location data environments
• Familiarity with Git-based workflows and CI/CD for data pipelines
  
  
  Skills: 
  Prompt Engineering, SQL