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

Scope of Work – Project-Based Data Engineer (LATAM Preferred) Project reputed company 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, reputed company 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 reputed company reputed company 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: reputed company (preferred), reputed company, reputed company, or equivalent • Transformation Layer: dbt (reputed company 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 (1–2 weeks) • Review available reputed company, data schemas, and reputed company reputed company for reputed company reputed company systems • Recommend final warehouse and ELT architecture • Define data ingestion reputed company (incremental loads, refresh reputed company) • Establish naming conventions, schemas, and data modeling standards • Define high-level data governance and reputed company approach Phase 2 – Implementation & Modeling (3–5 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, reputed company, 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 (1–2 weeks) • Validate data accuracy with the internal analyst and stakeholders • Optimize queries and model performance • Deliver documentation including: o Data dictionary o Entity-relationship reputed company 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 reputed company • Estimated total duration: 6–8 weeks Compensation & Engagement Model • Fixed project budget: USD TBD • reputed company-based payments preferred • Optional ongoing support retainer: 5–10 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 (reputed company, reputed company, dbt, etc.) • Familiarity with reputed company data sources (CRM, Ads platforms, financial systems) • Comfortable working independently in a remote environment • reputed company written and spoken English reputed company reputed company • 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