Skill diminta
CRMGoogle AdsGoogle SheetsJavaScriptLookerMeta AdsMicrosoft ExcelPostgreSQLPower BIPythonSQLTableau
Deskripsi
Position : Business Intelligence & Growth Analytics Specialist
Location
Remote Indonesia
Employment Type
Full-Time
Working Hours
9:30am – 6:30pm, Monday to Friday (Singapore Time)
About the Role
- RitzHelper is looking for a
- Business Intelligence & Growth Analytics Specialist
- to build and manage our internal reporting, marketing analytics, operational capacity and growth forecasting systems.
- This is a hands-on role combining
- data analytics, business intelligence, marketing attribution and automation
You will work closely with management to turn business data into clear recommendations on where we should spend more, where we should reduce spending, how much capacity we have, and how the business should expand.
- Key Responsibilities
- Build and maintain management dashboards for marketing, sales, customers, operations and growth.
- Track advertising performance across Google Ads, Meta Ads and other channels.
- Measure actual paid-customer CPA, recurring-customer CPA, CPL, ROAS and customer lifetime value.
- Analyse performance by campaign, ad set, creative, keyword and marketing source.
- Recommend which campaigns and ads should be scaled, reduced or stopped.
- Connect advertising data with CRM, booking, customer and payment data.
- Build automated data pipelines using APIs, webhooks and other integration tools.
- Track customer journeys from enquiry → qualified lead → payment → booking → recurring customer.
- Analyse workforce capacity, booked hours, vacant hours and utilisation.
- Identify which days and time slots have excess or insufficient capacity.
- Build forecasts for customer demand, workforce requirements and revenue.
- Estimate how much additional advertising budget is required when the company expands its workforce.
- Create scenario models to help management plan future growth.
- Maintain data accuracy, customer matching and deduplication.
- What You Should Be Able to Answer
Your analysis should help management answer questions such as
- Which advertising platform is performing best?
- Which campaign or advertisement generates the best paying customers?
- Which marketing source generates more recurring customers?
- How much does it cost us to acquire a new customer?
- How much available workforce capacity do we currently have?
- How many additional customers can we handle?
- When do we need to recruit more workers?
- If we increase our workforce, how much more advertising should we spend?
- Which areas of the business should we improve to support further growth?
- Required Skills
We are looking for candidates with practical experience in
* SQL
- Excel / Google Sheets
- Power BI, Looker Studio, Tableau or similar
- Data analytics and dashboard development
- REST APIs and JSON
- Webhooks and data integrations
- Data modelling and automation
- Google Ads and Meta Ads reporting
- Marketing attribution
- GA4 / UTM tracking
- Business forecasting
- Experience with
- Python, JavaScript, PostgreSQL, n8n, Make.com or similar tools
- is an advantage.
- Candidate Profile
- Ideally, you have
- 2–4+ years of relevant experience
- in Business Intelligence, Data Analytics, Marketing Analytics, Growth Analytics, Revenue Operations or Data Automation.
We are looking for someone who
- Is highly analytical and commercially minded
- Can work independently
- Understands both business and technical data
- Can identify problems and opportunities from data
- Can explain findings clearly to management
- Provides recommendations, not just reports
- Is comfortable building systems from the ground up
- Important
- This is
- not only a dashboard-design role
- You must be comfortable working with the underlying data, APIs, databases, attribution and automation.
We are looking for someone who can tell us
- What happened, why it happened, and what we should do next.
- Shortlisted candidates may be asked to complete a practical data and dashboard assessment.