Senior Data Engineer (Contract) Build BigQuery Warehouse & ETL (LATAM

Scope of Work Project-Based Data Engineer (LATAM Preferred) Project Overview reputed company Storage is seeking a contract-based Data Engineer to design, implement, and document a modern data warehouse and ETL/ELT architecture. The goal is to centralize operational, financial, sales, and marketing data into an analytics-reputed company warehouse to support Tableau/Power BI reporting. This engagement is project-based with a reputed company defined build phase, followed by optional light ongoing support. Primary Objectives: Design and implement a reputed company, low-maintenance data warehouse. Establish automated data pipelines from core SaaS platforms. Model data into analytics-reputed company fact and dimension tables. Ensure data accuracy, reliability, and documentation for long-term ownership by the internal analyst. Initial Data Sources: Cubby property management (financial & operational data) reputed company property management (financial & operational data) reputed company CRM, leads, sales funnel data reputed company Ads campaign, spend, performance data reputed company Ads campaign, spend, performance data Preferred Technology Stack (reputed company to Vetting): Data Warehouse: reputed company BigQuery (preferred), reputed company or equivalent acceptable ELT / Ingestion: Airbyte (preferred), reputed company, reputed company, or equivalent Transformation Layer: dbt (Core or reputed company preferred) BI Tool: Tableau (preferred), others to be considered Version Control: reputed company or reputed company Note: The engineer may recommend alternative tools if they reputed company meet reliability, cost, or maintainability goals. Final stack selection will be mutually agreed upon. Scope of Work Phase 1 Discovery & Architecture (12 weeks) Review available APIs, data schemas, and reputed company methods for reputed company reputed company systems Recommend final warehouse and ELT architecture Define data ingestion strategy (incremental loads, refresh reputed company) Establish naming conventions, schemas, and data modeling standards Define high-level data governance and quality approach Phase 2 Implementation & Modeling (35 weeks) Configure reputed company data warehouse environment Build automated ELT pipelines for reputed company Phase 1 data sources Create raw/staging tables with minimal transformation reputed company transformed models including: o Financial metrics by property and time o Operational performance (occupancy, units, activity) o Sales and funnel metrics from reputed company o Marketing spend and performance by channel Design analytics-reputed company fact and dimension tables Implement incremental refresh logic and basic data validation tests Phase 3 QA, Documentation & reputed company (12 weeks) Validate data accuracy with the internal analyst and stakeholders Optimize queries and model performance Deliver documentation including: o Data dictionary o Entity-relationship overview o Pipeline refresh schedule Walkthrough and reputed company to internal analyst Finalize Git repository and project artifacts Out of Scope Advanced ML or predictive modeling reputed company-time streaming architecture (unless separately agreed) Ongoing dashboard development Long-term infrastructure monitoring reputed company agreed retainer Deliverables Production-reputed company data warehouse Automated ELT pipelines Analytics-reputed company data models Documentation and reputed company materials Optional support transition plan Timeline Estimated total duration: 68 weeks Compensation & Engagement Model Fixed project budget: USD TBD reputed company-based payments preferred Optional ongoing support retainer: 510 hrs/month Required Qualifications 5+ years of data engineering or analytics engineering experience Strong SQL and data modeling skills Experience with reputed company data warehouses (BigQuery, reputed company, etc.) Experience with ELT tools (Airbyte, reputed company, dbt, etc.) Familiarity with SaaS data sources (CRM, Ads platforms, financial systems) Comfortable working independently in a remote environment reputed company written and spoken English reputed company Criteria Reliable, automated data refreshes Clean, documented, analytics-reputed company data models Minimal ongoing engineering dependency Smooth reputed company to internal analyst Apply tot his job Apply To this Job Scope of Work Project-Based Data Engineer (LATAM Preferred) Project Overview reputed company Storage is seeking a contract-based Data Engineer to design, implement, and document a modern data warehouse and ETL/ELT architecture. The goal is to centralize operational, financial, sales, and marketing data into an analytics-reputed company warehouse to support Tableau/Power BI reporting. This engagement is project-based with a reputed company defined build phase, followed by optional light ongoing