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 u se this link to apply directly:

Or email: igork@brainsworkgroup.com
Check ALL our Jobs:

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

Job Tags

Contract work, Visa sponsorship,

Similar Jobs