PowerBI Finance Data Analyst

BRAINS WORKGROUP, INC.; New York (NY); Hybrid; Full time

Job summary

A leading financial institution in New York is seeking a Finance Data Analytics Consultant with expertise in Power BI and SQL. This hybrid role involves supporting the implementation of an EPM tool and requires strong analytical skills. Candidates should have a business and technical background to enhance financial data reporting accuracy. A competitive rate is offered for this 6-month contract position with potential for extension.

Qualifications

• 3+ years of experience in business intelligence, data analysis, or similar role in financial services.
• Proficiency in BI tools, especially PowerBI and SQL.
• Good understanding of databases and OLAP Cubes.

Responsibilities

• Partner with finance and IT to validate data integrity during data migration.
• Design and maintain Power BI dashboards for automated reporting.
• Train end-users on Power BI functionalities.

Skills

PowerBI

SQL

Data Validation

Problem Solving

Story-telling

Education

Bachelor’s degree in Finance, engineering or a related field

Masters in Data Analytics or a related field

Tools

DAX

OLAP

EPM tools (Hyperion, OneStream)

ERP tools (SAP)

Job description

Our client, a major bank in New York City, is looking for Finance Data Analytics Consultant with strong PowerBI and SQL skills.
This is hybrid commute to NYC Office, midtown location.

6 months initial contract with possible extensions or option to hire.

** Must be authorized to work for ANY employer in US - NO H1 Visa support for this role

Rate: $63-67 on W2, possible C2C as well.

Financial Data Analytics Consultant.

Job Description:
Data Analytics Consultant to support Finance in a critical implementation of a EPM tool called OneStream and decommissioning existing Oracle-based Hyperion Financial Management (HFM). There is already a System Integrator (SI) and a project roadmap in place.
The ideal candidate has experience in investment banking industry, is skilled in data validation and designing Power BI dashboards.

This role requires both business and technical expertise, a meticulous approach to data accuracy, and the ability to collaborate with cross-functional teams during a transformative phase.

Key Responsibilities:

• Partner with finance, IT and 3^rd party system integrator (SI) to validate data integrity during the one-time data migration, ensuring accuracy in financial records, hierarchies, and reporting structures.
• Execute data validation and UAT test scripts provided by SI, reconciling discrepancies between legacy Hyperion data and OneStream outputs.
• Design, build, and maintain interactive Power BI dashboards using data extracted from OneStream, to automate reporting and deliver actionable insights on revenue, expense, and balance sheet datasets.
• Train end-users on Power BI dashboards and OneStream reporting functionalities to support adoption.

Basic Qualifications:

• Bachelor’s degree in Finance, engineering or a related field
• 3+ years of experience in business intelligence, data analysis, or a related role in financial services industry
• Proficiency in BI tools especially PowerBI and SQL, and writing DAX code for complex measures or ETL
• Good understanding of databases and OLAP Cubes, to ingest required data into PowerBI semantic layers
• Excellent problem-solving skills and attention to detail
• Story-telling and presentation skills to engage both technical and non-technical audiences.

Preferred Qualifications:

• Masters in Data Analytics or a related field
• Knowledge of General Ledger concepts (profit/cost center, trade books, variable, allocated, direct expenses etc) at an investment bank
• Experience with EPM tools such as Hyperion and OneStream and ERP tools such as SAP

Please email your resume or use this link to apply directly:

https://brainsworkgroup.catsone.com/careers/index.php?m=portal&a=details&jobOrderID=16652091
Or email: [e-mail]
Check ALL our Jobs:http://brainsworkgroup.catsone.com/careers




Keywords: Power BI powerbi sql cubes DAX ETL investment banking financial dashboards reporting OLAP