Project Overview
The details of the different data analysis that will be enabled over the duration of the project are outlined below. Additionally, must possess 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 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 development team use on new or existing customer integrations
- Update the DevOps tasks and assist business in prioritizing the tasks in sprints
- Develop test cases and test the data in 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 and 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 mappingDocument 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 effortsCreating appropriate documentation that allows stakeholders to understand the steps of the data analysis process and duplicate or replicate the analysis if necessarySkills
Experience in analyzing data from various sources and formats, and applying data insights to cleanse and transform data into a standardized formatMUST 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 setsExperience in creating and maintain technical documentation for various systems, services and business processesExperience 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 applicableExperience in authenticating and interpreting data based on results using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data miningExcellent communication skillsAbility to work independently and a member of a multi-function teamExperience in implementing Energy Management solutions (Preferred)Education and 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.