Business Solutions Analyst - Remote

Role Overview

Title: Business Solutions Analyst (Contractor) Department: Transformation & Integration Who will this person report into: SVP, Transformation & Integration

The Role:

At Wpromote, we're building the internal data infrastructure that lets our leadership team run the agency with confidence. We're looking for a Business Solutions Analyst who can bridge the gap between our business stakeholders and our data architecture: someone who speaks fluent finance, HR, and operations, and can translate that into clean semantic models, reliable dashboards, and requirements that our data engineers can actually build.

This is an internally focused role. You won't be managing client campaigns; you'll be managing the

blueprint for how we understand our own business. That means standardizing how we define and

measure things like utilization, profitability, and overhead across Finance, HR, and Operations,

then making those definitions real inside Power BI.

Success in this role looks like:

● Agency leadership trusts internal dashboards and makes decisions from them

● Corporate KPIs are defined consistently and documented across departments

● Power BI semantic models are clean, well-governed, and maintainable

● Data engineers receive clear, unambiguous requirements rather than slide decks

● Executives can self-serve on key metrics without needing a data analyst in the room

You Will Be:

Define and Govern Corporate Metrics

● Partner with business stakeholders to establish and document universal KPI definitions

● Establish a business glossary that serves as the single source of truth for internal

reporting

● Own the Power BI Semantic Layer

● Design and govern centralized Power BI semantic models ensuring consistent business

logic, clean relationships, and a single source of truth across internal management reports

● Validate star schemas that support executive-level reporting without requiring end-user

data literacy

● Create model documentation and version control practices

Prototype and Validate Dashboards

● Build high-impact Power BI mockups, operational scorecards, and executive proof-of-

concept reports to validate leadership needs before technical build-out

● Iterate quickly based on stakeholder feedback

● Ensure dashboards are intuitive enough for executives to self-serve without training

Translate Business Needs into Technical Requirements

● Serve as the product owner for internal operational data, translating financial and

resource reporting needs into clear specs for data engineers

● Document data flows from source systems (project management, time-tracking,

accounting) through to the warehouse and visualization layer

● QA delivered work against requirements and flag discrepancies before they reach

leadership

What You'll Need to Succeed

● 4+ years in a Business Intelligence, Data Strategy, or Business Solutions role with a

strong focus on internal operations, financial analytics, or professional services; agency

experience is a plus

● Hands-on Power BI proficiency: semantic modeling, star schema design, DAX, and

building clean visualizations for executive audiences

● A translator's mindset: you can sit in a room with a CFO and a data engineer and make

both of them feel heard

● Strong working knowledge of how data flows from operational systems (project

management, time-tracking, accounting tools) into a centralized warehouse

● Proven ability to drive alignment across departments with competing definitions of

success

● Clear, direct communication; you write requirements that don't leave room for

guesswork

Nice to Have

● Foundational knowledge of DAX and Power Query (M) for advanced reporting

prototypes

● Experience integrating time-tracking platforms (Harvest, Toggl) and accounting

systems (NetSuite, QuickBooks) into Power BI datasets

● Familiarity with agency financial models: utilization targets, blended billing rates, gross

margin by practice

● Prior work in a post-acquisition integration or org transformation context