Data Analyst : NYPA

---

Job description

Temporary Job Request Number: IT - 1067 - Data Analyst

BEST RATE ON W2

Position Title
Data Analyst

NYPA Business Unit
Customer Solutions

Experience
Level 2 (5-10 years)

Work Location
White Plains Office

Anticipated Start Date
Immediate

Duration of Assignment
12 month(s)

Project/Assignment
BAU - Commercial Operations

Work Schedule - Monday through Friday 7.5 hour work day with .5 hour unpaid lunch Paid for time worked only; there are no paid holidays, vacation, or sick days Overtime is not permitted unless authorized in advanced. Contingent Worker is required to badge in and out of the turnstiles located in the lobby for all daily entrances and exits.

CWPO Engagement Requirements

Candidates are REQUIRED to be local to Tri-State area and in W2 tax status as employee of Service Provider. Fully remote positions are prohibited. Hybrid schedules are permissible with a minimum of 2-3 days on-site depending on assignment and can be fully on-site depending on business needs. Remote work privileges can be revoked at any time. NYPA does not provide laptops. Instead, NYPA provides desktops and dedicated workstations which candidates will remote into from their personal equipment on virtual days.

If candidate does not have proper equipment, internet connection, or he/she is deemed to not work effectively from home, the hybrid privilege will be revoked.

Vendors must disclose foreign national status and all Visas at the time of candidate submission. Additionally, a Benefits Waiver and Ethics Disclosure will be required by all candidates during onboarding.

Project Overview- The details of the different data analysis that will be enabled over the duration of the project are outlined below. a) Analyze the customer data and create hierarchy for Organizations, Facilities, Accounts and meters b) Analyze the existing hierarchy and propose changes to improve the overall data quality. c) Create detailed design documents for development team use on new or existing customer integrations d) Update the DevOps tasks and assist business in prioritizing the tasks in sprints e) Develop test cases and test the data in QA environment f) Support Energy Cap, BSNY, and other data integrations

Job Functions & Responsibilities

Collect and document detailed data requirements and the data flows Identify relevant data attributes from internal data sources and document inputs, outputs and associated source-to-target data mapping Document key processes and workflows around data acquisition, integration, cleansing and monitoring Investigate and validate data from different sources, checking for completeness & accuracy as well as analyzing patterns & trends in data Identify data issues and assist in manual/automated data remediation efforts Creating appropriate documentation that allows stakeholders to understand the steps of the data analysis process and duplicate or replicate the analysis if necessary

Skills

• Experience in analyzing data from various sources and formats, and applying data insights to cleanse and transform data into a standardized format • MUST HAVE a working knowledge of SQL, writing SQL queries and proficiency in MS Excel. • Experience in identify, analyze, and interpret trends or patterns relating to key performance indicators in complex data sets • Experience in creating and maintain technical documentation for various systems, services and business processes • Experience in assessing data quality on various data sources and coordinates with Business & IT in the correction of source data or creation of translation sources, where applicable • Experience in authenticating and interpreting data based on results using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining • Excellent communication skills • Ability to work independently and a member of a multi-function team • Experience in implementing Energy Management solutions (Preferred)

Education & Certifications

Bachelor's degree in CS, MIS, Math, Statistics or related field or equivalent with around 6+ years experience in data analysis and interpretation Experience on any BI tool.

<!– job description page –>