Sr. Data Analyst

Job Title

Job Description

Utilizes Head End System in daily work efforts to extract data for analysis, track ongoing system issues, and conduct searches for emerging AMI network performance trends. Combine data from available sources to identify system performance, issues and patterns for use in operational decision making. Create communications and reports on these activities. Create and refine reports for developed management metrics for project status communications. Examine relationships between AMI network devices and individual meters for mesh network performance. Develop populations to be visited by various field organizations based on customer type, duration of issue and evolving business and technical rules. Develop custom products that portray performance and conditions within critical customer segments. Develop customer products that portray performance and conditions within project program roll-outs. Develop customer products that portray performance and conditions within seasonal and unexpected occurrences such as energy curtailment and storms. Perform ad hoc analysis as needed in response to a 24/7 operating unit. Monitor work orders generated for timeliness and completion of intended remediation across organizations and vendors. Identify and escalate issues that arise in links in the chain, regions, etc. Track, monitor and analyze data from various AMI and legacy systems for system reporting and performance purposes. Perform system synchronization monitoring, issue identification and troubleshooting for AMI Transaction correction. Identify data patterns and issues with AMI Business System synchronization. Establish clear failure patterns in data records and determine their generation point (system or manual record entry). Refine data queries for optimization and reduced operating duration. Perform data validation activities for system acceptance testing. Document products for inclusion into the companies’ enterprise analytic platform for wider and automated use including machine learning capabilities. Reconcile project close-out records across inventory, installation records and system provisioning and billing. Track meter shipments across locations, employees and customer premises. Highlight instances of prolonged employee handling on an asset and inventory inconsistencies across locations and vendors.

Skills & Requirements

Candidate must be an agile, self-started that engages issues seeking resolution. Candidate must be able to work as an individual with a high quality of work that is checked frequently. Candidate must be able to communicate and engage in a team environment. Candidate must be able to interpret technical and business requirement documents. Candidate must have strong verbal skills with the ability to clearly communicate technical issues and solutions with business users and technical support teams. Candidate must have strong writing skills with the ability to develop and refine procedural and process flow documents. Candidate must have the ability to learn AMI and Legacy applications with proper training. Candidate must have the ability to interpret individual meter device data through multiple business systems to identify design failure points. Candidate must have experience investigating exceptions and pursue resolution through technical or operational routes as necessary. Candidate must have experience in resolving issues and applying lessons learning to new situations. Candidate must have the ability to develop database queries for data analysis and reporting. Candidate must have experience with data collection and reporting analytic and issue resolution purposes. Candidate must have ability to collect and analyze data in order to produce performance summaries, exceptions, gaps, trends and opportunities. Candidate must have experience with large data set management, discrepancy investigation and data cleanup. Candidate must have experience with data presentment and analysis from multiple databases. Candidate must have experience with utility data associated with metering and account activity. Candidate must have experience performing data quality review and report refinement to meet operational business reporting needs. Candidate must have familiarity with commodity and service requirements associated with Utility Metering Operations. Candidate must have experience in troubleshooting synchronization issues between multiple databases.

The following are not required for this position but would be considered as a valuable asset in a potential candidate.

Experience working on repetitive tasks. Experience publishing daily performance and detail reports. Experience with defect management and reporting tools (i.e. Rational) for issue identification, work assignment, communication and resolution. Experience with executing business system test scripts, documenting and reporting testing results. Experience with data analysis and interpretation and account/field/record correction. Experience with utility energy management systems or billing systems. Demonstrated experience with data retrieval from databases, and running comparison scripts to identify discrepant information. Experience with data visualization through Tableau and Power BI. Experience with the creation of automated data reporting.