Title: Data Analyst
Location: White Plains NY
Duration: 12 Months
Job Description:
- The details of the different data analysis that will be enabled over the duration of the project are outlined below. Additionally must possess a strong ability to collaborate and communicate with IT product team and operations teams and all stakeholders to identify change barriers track adoption metrics and ensure sustained platform usage.
- Analyze the customer data and create a hierarchy for Organizations Facilities Accounts and meters
- Analyze the existing hierarchy and propose changes to improve the overall data quality.
- Create detailed design documents for the development teams use on new or existing customer integrations
- Update the DevOps tasks and assist the business in prioritizing the tasks in sprints
- Develop test cases and test the data in the QA environment
- Support Energy Cap BSNY and other data integrations
- Strong Ability to collaborate and communicate with IT product team and operations teams and all stakeholders to identify change barriers track adoption metrics and ensure sustained platform usage.
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 identifying analyzing and interpreting trends or patterns relating to key performance indicators in complex data sets
- Experience in creating and maintaining technical documentation for various systems services and business processes
- Experience in assessing data quality on various data sources and coordinating 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 be a member of a multi-function team
- Experience in implementing Energy Management solutions (Preferred)
Education & Certifications: - Bachelors degree in CS MIS Math Statistics or related field or equivalent with around 6 years of experience in data analysis and interpretation. Experience with any BI tool.