Financial Data Analyst

PROVEN is hiring a Financial Data Analyst on behalf of our client. This role is a C2C or 1099 contract staff augmentation position with a company.This role is the connective tissue between them-owning SQL development,semantic modeling, Fabric workspace governance, and stakeholder alignment to turn requirements into accurate, trusted finance insights.

Responsibilities:

Model & Transform: Build clean, well-documented SQL in Snowflake (views,

CTEs, window functions) to power Finance reporting (project performance,

revenue, product usage).

Shape the Semantic Layer: Design star-schema models and measures (DAX)

in Power BI / Fabric semantic models; maintain metric definitions/KPIs and

prevent drift.

Own Refresh & Access: Administer Fabric workspaces (capacity, permissions,

deployment pipelines, data source credentials/refresh, gateway/personal-cloud-

connection policy) and uphold RLS where needed.

Salesforce → Snowflake: Translate Salesforce object relationships (Accounts,

Opportunities/Orders, Products/Line items, custom project objects) into reliable

reporting tables.

Quality & Reconciliation: Investigate data anomalies, reconcile to source-of-

truth (CRM/Finance systems), and publish runbooks/tests so issues don't repeat.

Stakeholder Delivery: Drive requirements to delivered dashboards-facilitate

reviews, UAT, and change control; produce exec-ready views (exploratory +

leadership snapshots).

Must-haves

Strong proficiency in SQL and data modeling in Snowflake (joins, windowing,

performance basics).

Hands-on Power BI: data modeling, DAX for measures, page/report design for

exec and exploratory use.

Working knowledge of Fabric administration: capacities, workspace roles,

semantic models, refresh, gateways.

Familiarity with Salesforce objects relevant to project performance and revenue

reporting.

Proven experience driving stakeholder requirements → delivered solutions; crisp

documentation and communication.