Analytics Engineer / Senior Data Analyst

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.