BUSINESS INTELLIGENCE ANALYST (REVENUE FOCUS)

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Full Time

SALARY

2450

HOURS PER WEEK

40

DATE UPDATED

Mar 30, 2026

JOB OVERVIEW

*NOT ENTRY LEVEL. ALL NON-EXPERIENCED APPLICANTS WILL BE DELETED*

We are looking for a sharp, business-minded Data & Insights Analyst to help us turn raw data into clear decisions that drive revenue and profitability.

This is not a passive reporting role. You will be responsible for extracting, structuring, and analyzing our marketing, sales, and financial data to identify patterns, opportunities, and problems. This is all to help leadership make better decisions.

!! Important: Raw Data Environment !!

Our data is not clean or pre-structured. You will be working directly inside systems such as:

Pipedrive CRM (Deals, Notes, etc)
Joist (Estimates and Invoices)
Communication tools like Hatch and GoTo (calls, messages, notes)
Marketing Platforms - Meta, Google, Bing

!! There are no ready-made spreadsheets or tables.!!

You must be comfortable:

Digging into raw records
Extracting relevant data
Structuring it into usable formats
Building your own datasets from scratch

If you are only experienced with clean dashboards or pre-built datasets, this role is not a fit.

What You’ll Do:
Extract and organize data from:
Marketing Platforms
Pipedrive CRM
Estimates and invoices
Communication logs and notes
Analyze 3+ years of historical data across:
Marketing (lead sources, campaigns, cost per lead)
Sales (conversion rates, sales cycles, close rates)
Financials (revenue, margins, product performance)

Answer key business questions such as:
Which products are most profitable?
Which customers/demographics convert best?
Which lead sources close faster and at higher value?
Where are we losing deals and why?


Identify patterns and trends that impact growth
Build dashboards and reports to track:
Revenue performance
Sales funnel metrics
Marketing ROI
Operational efficiency
Create forecasting models based on historical data
Provide actionable recommendations (not just data)


What We’re Looking For
Strong experience in data analysis within messy, real-world business environments
Proven ability to extract and structure raw data from multiple systems
Advanced proficiency in:
Excel / Google Sheets (required)
Data visualization tools (Power BI, Tableau, Looker Studio)
Experience working with sales and marketing data
Ability to connect data to real business decisions
Strong English communication (you will present insights)
Self-starter who can work independently and take ownership

Bonus (Highly Preferred)
Experience with CRM systems (Pipedrive, HubSpot, etc.)
SQL or API experience (for data extraction)
Experience cleaning and structuring unorganized datasets
Experience in service-based or construction-related businesses

Metrics for YOUR success:
You successfully turn fragmented data into a structured system
You clearly explain:
What is working
What is not working
What we should do next
Leadership can make faster, better decisions based on your insights
We have ongoing reporting that keeps a real-time pulse on the business


To apply, include:

Examples of raw data you have cleaned and structured
A dashboard or report you built from that data
A short explanation of a business insight you uncovered

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0007
Controller Execution Time ( Jobseekers / Job )  0.0141
Total Execution Time  0.0154
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,507,176 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/BUSINESS-INTELLIGENCE-ANALYST-REVENUE-FOCUS-1613540
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0087 seconds)  (Hide)
0.0003   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0003   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1613540
 LIMIT 1 
0.0009   SELECT *
FROM `employers`
WHERE `employer_id` = 913733
 LIMIT 1 
0.0009   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1613540
AND `misc`.`idIS NULL 
0.0004   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-08-11',ej.date_added) duration_daysDATEDIFF('2026-08-11',e.rebill_date) duration_rebillej.*, e.deactivate FROM employers eemployer_jobs ej WHERE e.employer_id ej.employer_id AND
                                   ((
e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR 
e.employer_id '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-08-11',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1613540' 
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1613540 
0.0018   UPDATE employer_jobs SET hit_counts '***Mar-30-2026=216***Mar-31-2026=119***Apr-01-2026=49***Apr-02-2026=38***Apr-03-2026=27***Apr-04-2026=21***Apr-05-2026=22***Apr-06-2026=26***Apr-07-2026=31***Apr-08-2026=31***Apr-09-2026=37***Apr-10-2026=11***Apr-11-2026=7***Apr-12-2026=12***Apr-13-2026=27***Apr-14-2026=17***Apr-15-2026=14***Apr-16-2026=17***Apr-17-2026=13***Apr-18-2026=7***Apr-19-2026=7***Apr-20-2026=12***Apr-21-2026=11***Apr-22-2026=5***Apr-23-2026=8***Apr-24-2026=13***Apr-25-2026=3***Apr-27-2026=13***Apr-28-2026=3***Apr-29-2026=16***Apr-30-2026=7***May-01-2026=5***May-02-2026=4***May-03-2026=7***May-04-2026=4***May-05-2026=16***May-06-2026=3***May-07-2026=1***May-08-2026=3***May-09-2026=1***May-10-2026=2***May-11-2026=3***May-12-2026=3***May-13-2026=2***May-14-2026=3***May-15-2026=1***May-16-2026=4***May-17-2026=1***May-18-2026=4***May-19-2026=3***May-20-2026=2***May-21-2026=2***May-22-2026=4***May-23-2026=4***May-25-2026=1***May-26-2026=4***May-28-2026=3***May-29-2026=1***May-30-2026=3***May-31-2026=2***Jun-01-2026=4***Jun-02-2026=2***Jun-04-2026=2***Jun-06-2026=10***Jun-07-2026=3***Jun-08-2026=4***Jun-09-2026=5***Jun-10-2026=4***Jun-11-2026=3***Jun-12-2026=2***Jun-13-2026=3***Jun-14-2026=3***Jun-15-2026=2***Jun-16-2026=3***Jun-17-2026=18***Jun-18-2026=10***Jun-19-2026=7***Jun-20-2026=6***Jun-21-2026=2***Jun-22-2026=2***Jun-24-2026=4***Jun-25-2026=2***Jun-26-2026=2***Jun-27-2026=4***Jun-28-2026=3***Jun-29-2026=1***Jun-30-2026=4***Jul-01-2026=4***Jul-02-2026=2***Jul-03-2026=5***Jul-04-2026=1***Jul-06-2026=1***Jul-07-2026=2***Jul-08-2026=1***Jul-11-2026=1***Jul-12-2026=1***Jul-13-2026=1***Jul-14-2026=5***Jul-15-2026=1***Jul-18-2026=1***Jul-19-2026=1***Jul-20-2026=2***Jul-21-2026=2***Jul-22-2026=3***Jul-24-2026=2***Jul-25-2026=4***Jul-26-2026=1***Jul-27-2026=1***Jul-28-2026=2***Jul-29-2026=3***Jul-30-2026=13***Jul-31-2026=4***Aug-01-2026=3***Aug-02-2026=4***Aug-03-2026=3***Aug-05-2026=1***Aug-06-2026=3***Aug-08-2026=2***Aug-11-2026=1' WHERE job_id'1613540'  
0.0006   UPDATE employer_jobs SET monthly_hits '***Mar-2026=335***Apr-2026=505***May-2026=96***Jun-2026=115***Jul-2026=64***Aug-2026=17' WHERE job_id'1613540'  
0.0008   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1613540' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1613540 
0.0016   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '913733'
AND `date_added` >= '2022-06-08' 
0.0003   select from teasers 
0.0002   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)