Data Analyst

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title:

Data Analyst

Job Location:

White Plains, NY

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 Power

BI 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.

• The qualified candidate will be able to expertly assist in providing direction and/or developing Power
  
  BI and/or Tableau dashboards and foundational data models and transformations in collaboration with the MFS team.
• Converting Legacy Excel models into Tableau and/or Power
  
  BI models.
• Provide subject matter expertise and assistance in developing Power
  
  BI/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/Power
  
  BI to create custom dashboards.
• Provide the team with advanced analytics by defining and refining slicers, filters, and Legends across Dashboard reports.

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

4 years of experience needed.

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.