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 work spaces (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.