Data Analyst

Ampcus Inc. • White Plains, NY

3d • Onsite

About The Position

Ampcus Inc. is seeking a highly motivated Data Analyst to join their team. This role will support and assist a team of analysts in performing analytics within the Market Forecasting Services (MFS) Group. The position involves refining requirements and collaborating with NYPA staff to develop Tableau and PowerBI dashboards and recurring reports. The data models will pull from various sources including Legacy Excel models/data sets, SharePoint Lists, and SQL Server databases.

Requirements

• 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.
• 4 years of experience.

Responsibilities

• Assist in providing direction and/or developing PowerBI and/or Tableau dashboards and foundational data models and transformations in collaboration with the MFS team.
• Convert 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 the 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.
• Create databases of legacy information and establish 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed