Revenue Data Analyst: BI, SQL & Pipelines

Facilityos; Toronto; Hybrid; CAD 65,000 - 95,000; Full time

Benefits offered by this job

Comprehensive health coverage

Hybrid work environment

Career advancement

Catered events and snacks

Birthday and life celebrations

Two annual parties

Job summary

FacilityOS seeks a Data Analyst to own semantic models and Power BI reporting, driving reliable pipeline insights and accurate metrics across bookings, pipeline and health. You’ll build data pipelines in Microsoft Fabric, integrating Salesforce and GTM data into a lakehouse and maintaining data quality.

You’ll work with CRO and GTM leaders to transform ambiguous questions into actionable analysis, delivering recommendations rather than just charts, while ensuring data integrity and scalable

Qualifications

• 2–4 years in an analytics, BI, or data analyst role, ideally supporting a B2B SaaS revenue or GTM function
• Strong SQL — joins, window functions, CTEs, query tuning
• Hands‑on Power BI: data modelling, DAX, star schema design, performance optimization
• Experience building or maintaining data pipelines in a cloud platform. Microsoft Fabric is what we run; Synapse, Databricks, Snowflake, or BigQuery experience translates
• Python for data work — transformation, API pulls, automation
• Working knowledge of the Salesforce data model (objects, relationships, reporting quirks)
• Able to take an ambiguous business question, decide what analysis actually answers it, and present the result to leaders without hand-holding
• dbt or an equivalent transformation framework
• Experience with Gainsight, Gong, SalesLoft, Clay, ZoomInfo, or HubSpot
• Exposure to SaaS revenue metrics — ARR, NRR, pipeline coverage, CAC payback
• Git and a habit of version‑controlling analytical work

Responsibilities

• Semantic models and reporting. Build and maintain Power BI semantic models and reports covering pipeline, bookings, forecast accuracy, conversion, retention, and customer health. Own the definitions, not just the visuals.
• Data pipelines in Microsoft Fabric. Build and maintain pipelines and notebooks bringing Salesforce and GTM system data into the lakehouse. Own transformation logic, refresh schedules, and data quality checks.
• Analysis that changes decisions. Quarterly pipeline and coverage analysis, segmentation and territory work, win/loss and cohort analysis, and ad hoc investigation into why a metric moved. Bring a recommendation, not just a chart.
• Data integrity across the GTM stack. Reconcile Salesforce against downstream systems, find and fix the breaks, and flag the process problems causing them.
• Documentation. Metric definitions, model lineage, and runbooks that let someone else pick up your work.

Skills

SQL

Power BI

Python

Salesforce data model

Tools

Microsoft Fabric

Synapse

Databricks

Snowflake

BigQuery

Job description

FacilityOS seeks a Data Analyst to own semantic models and Power BI reporting, driving reliable pipeline insights and accurate metrics across bookings, pipeline and health. You’ll build data pipelines in Microsoft Fabric, integrating Salesforce and GTM data into a lakehouse and maintaining data quality.

You’ll work with CRO and GTM leaders to transform ambiguous questions into actionable analysis, delivering recommendations rather than just charts, while ensuring data integrity and scalable