Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Sourcepass

BI Engineer

Posted Updated

Description

POSITION SUMMARY

The BI Engineer builds and maintains the data foundation underneath every dashboard, KPI, and analytics product Sourcepass runs on, along with the back-end systems our automation and AI solutions depend on. This role owns the hands-on engineering of the BI stack (the data lake, the pipelines that feed it from source systems, and the SQL layer that powers front-end dashboards) and plays a lead role in modernizing the Sourcepass BI platform. Working alongside the BI Manager, AI Engineer, and RPA Developers in the ROC, the BI Engineer also builds the integrations and data services that let our automations and AI agents work from the same trusted source of operational truth.


RESPONSIBILITIES

- Designs, builds, and maintains the pipelines and data models that move data from source systems (ConnectWise PSA, NetSuite, HubSpot, and others) into the data lake and SQL layer.

- Leads the technical work to modernize the Sourcepass BI platform, including evaluating architecture options, planning the migration, and retiring legacy pipelines.

- Partners with the BI Manager and business leaders to translate reporting and analytics needs into data models, freshness targets, and quality checks.

- Monitors pipeline health and data quality, resolves data issues, and keeps the SQL layer the authoritative source for front-end dashboards.

- Builds and supports back-end integrations, APIs, and data services used by the team's automation workflows and AI agents.

- Supports data migration and system integration for acquired companies, mapping legacy systems and data into Sourcepass platforms.

- Documents data sources, models, and pipelines so the platform stays supportable and auditable by the wider team.


SUCCESS METRICS / EXPERIENCE

What does success look like in this role? (KPIs, outcomes, behaviors)

- Front-end dashboards and downstream analytics run on data the BI team and business leaders trust; stale, missing, or incorrect data is rare and resolved quickly.

- The BI platform modernization delivers against its committed milestones, with legacy pipelines retired as replacements go live.

- Pipeline health and SQL-layer SLAs (freshness, completeness, uptime) consistently meet the standards committed to downstream consumers.

- Data platform coverage grows over time: more source systems integrated and more automation and AI use cases powered by shared data services.

- Pipelines, models, and integrations are documented well enough that teammates can support them without a single point of failure.

Skills

Apply

See also