Job Description

Role Overview:
The role will design, implement, and manage the company's data infrastructure and analytics framework. It includes building a centralized data warehouse, creating scalable data structures, and producing actionable insights across SCALE PMS, ERP, HubSpot, Google Ads, Meta Ads, and Finance systems.
Key Responsibilities:
Design and build the company's data warehouse architecture to consolidate data from multiple systems.
Develop data models, transformations, and pipelines to ensure data consistency and accuracy.
Implement data quality validation, governance, and automated data refresh processes.
Create interactive dashboards and reports for management and departments (Operations, Marketing, Finance).
Define and maintain the organization-wide KPI and metrics structure.
Conduct deep-dive analyses to identify trends, performance gaps, and optimization opportunities.
Manage marketing data attribution (Google Ads, Meta Ads, HubSpot ? PMS).
Support leadership with strategic, data-driven recommendations.
Qualifications:
Bachelor's or Master's degree in Data Analytics, Computer Science, or related field.
Minimum 5 years of experience in analytics, data engineering, or BI roles.
Expertise in SQL, dbt, Python, and data warehouse design (BigQuery, Postgres, or similar).
Strong experience in dashboard tools (Looker Studio, Metabase, or Power BI).
Proven ability to integrate marketing, CRM, and operational systems.
Excellent problem-solving and cross-functional communication skills.
Preferred Skills:
Experience in the hospitality or property management industry.
Familiarity with Airbyte, Prefect, or similar ETL orchestration tools.
Knowledge of forecasting, anomaly detection, and cost optimization techniques.
Compensation:
Competitive salary package with performance-based incentives.

Skills Required