Data Analyst

Ampcus Inc; City of White Plains (NY); On-site; USD 70,000 - 90,000; Full time

Job summary

Ampcus Inc is seeking a Data Analyst in White Plains, NY to support a team in analytics for Market Forecasting Services. The role involves developing PowerBI and Tableau dashboards, converting Legacy Excel models, and connecting multiple data sources. Candidates should have excellent communication skills, extensive Microsoft Power Platform experience, and a keen understanding of SQL databases. This position requires 4 years of relevant experience. Ampcus is an Equal Opportunity Employer.

Qualifications

• 4 years of experience needed.

Responsibilities

• Assist in developing PowerBI and Tableau dashboards.
• Convert Legacy Excel models into Tableau/PowerBI models.
• Provide expertise in developing visualization solutions.
• Assess requirements and make recommendations.
• Incorporate Microsoft Power Platform components.
• Connect to multiple source data systems.
• Create databases for legacy information.

Skills

Excellent communication skills

Experience in Microsoft Power Platform

Visualization software PowerBI

Building SQL Databases

PowerApps development methods

Implementing solutions with multiple data sources

Job description

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

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