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

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 scalable, 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 (1–2 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 (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, 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 (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 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: 6–8 weeks

Compensation & Engagement Model

• Fixed project budget: USD TBD
• Milestone-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 (Airbyte, reputed company, dbt, etc.)
• Familiarity with SaaS data sources (CRM, Ads platforms, financial systems)
• Comfortable working independently in a remote environment
• Clear 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