BizTek People is in search of an experienced Data Analytics Consultant professional for our client in NY, NY!

Job Title: Data Analytics Consultant

This role demands a combination of business and technical expertise, a keen eye for data accuracy, and collaboration across cross-functional teams during a significant transformation phase.

Key Responsibilities:

• 
  Collaborate with finance, IT, and a third-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 user acceptance testing (UAT) using scripts provided by the 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 provide actionable insights on revenue, expenses, and balance sheet data.
• 
  Train end-users on Power BI dashboards and OneStream reporting features to support adoption and maximize usability.

Basic Qualifications:

• 
  Bachelor’s degree in Finance, Engineering, or a related field
• 
  3+ years of experience in business intelligence, data analysis, or a similar role within the financial services industry
• 
  Investment banking industry experience
• 
  Proficiency in BI tools, particularly Power BI and SQL, including writing DAX code for complex calculations and ETL processes
• 
  Strong background in data validation
• 
  Strong understanding of databases and OLAP cubes, and experience integrating data into Power BI semantic layers
• 
  Excellent problem-solving abilities and attention to detail
• 
  Effective storytelling and presentation skills to communicate insights to both technical and non-technical stakeholders

Preferred Qualifications:

• 
  Master’s degree in Data Analytics or a related discipline
• 
  Familiarity with General Ledger concepts such as profit/cost centers, trade books, variable vs. allocated expenses, etc., within an investment banking context
• 
  Hands-on experience with EPM tools like Hyperion and OneStream, and ERP platforms such as SAP