Data Analyst

Project Overview

This Data Analyst will support and assist a team of analysts in performing analytics in the Market Forecasting Services (MFS) Group. This position supports the team's efforts in refining requirements and collaborating with NYPA staff to develop Tableau and PowerBI dashboards and recurring plug and play reports. The supporting data models would be pulling data from various sources and types; such as Legacy Excel models/data sets, SharePoint Lists, SQL Server databases, etc.

Job Functions & Responsibilities

• The qualified candidate will be able to expertly assist in providing direction and/or developing PowerBI and/or Tableau dashboards and foundational data model and transformations in collaboration with the MFS team.
• Converting Legacy Excel models into Tableau and/or PowerBI models.
• Provide subject matter expertise and assistance in developing PowerBI/Tableau visualization solutions based on requirements provided by MFS team.
• Assess requirements and analyses and make recommendations.
• Incorporate the use of M365 and Microsoft Power Platform components.
• Connect to multiple source data systems on varied platforms.
• Creating databases of legacy information and establishing links to Tableau/PowerBI to create custom dashboards.
• Provide the team with advanced analytics by defining and refining slicers, filters, and Legends across Dashboard reports.

Skills

• Excellent communication skills and ability to work in a team environment.
• Extensive experience in the Microsoft Power Platform - MS PowerApps, Excel, Access and specifically, visualization software PowerBI.
• General understanding of building SQL Databases.
• Keen understanding of PowerApps formulas and development methods.
• Understanding of how to implement solutions with multiple data sources.

Education & Certifications

4 years.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.