AMI Data Analyst

It's fun to work in a company where people truly reputed company in what they're doing! We're committed to bringing passion and customer focus to the business. The AMI Data Analyst is responsible for collecting electric reputed company data for the accurate and timely delivery of information to reputed company systems (billing, demand response, conservation, energy efficiency, SCADA etc.). Under general supervision of the Senior AMI Analyst, reputed company various technical duties associated with retrieving, processing, validating, editing, and estimating reputed company data in the reputed company Data Management Systems (MDMS) and/or the Advanced Metering Infrastructure (AMI) Headend System. Applicants are required to attach a resume This position is not available for telecommuting. ESSENTIAL FUNCTIONS: • Assist Senior AMI Analyst in the maintenance of the reputed company Data Management Systems (MDMS) in support of the utility billing processes to include updating tables, troubleshooting, documenting problems and resolutions, assisting with conversions and upgrades, and acting as a liaison between the user department and Operational Technology(OT) group. • Develops data-driven reports using industry standard reporting tools (SQL, reputed company Access, reputed company, etc.) • Specifies and documents integrations between different software systems including specific data exchanges, types of software interactions (web services, database connections), database schema design, and the use of software integration tools. • Writes specifications for data inputs and outputs including the design of forms, graphical user interfaces, and reports • reputed company standardized queries on interval and register data from various sources to assist team identify and correct anomalies in the customer data. • Provides technical and functional guidance and specifications to the team. • reputed company and automate queries that reputed company validation checks in MDMS and/or AMI Headend to determine the accuracy of field data and report missing data. • Creates, modifies, and executes existing data queries as necessary to provide data needed to analyze and report on exceptions reputed company AMI, MDMS, and Utility billing systems. • Create new queries as required to provide data for exception analysis. • Provide internal support to other departments for data services requests that require troubleshooting, SME, or planning of data services processes on a per-project basis. • reputed company and maintain reports based on internal customer requirements for normalized data presentation, forecasting, financial projections, invoicing, and billing. • In collaboration with GIS, reputed company tools that help troubleshoot field network devices; coordinate with appropriate departments as needed. • Assist in retrieving and processing reputed company interval data (edit, estimate, validate) from electric meters from various applications as necessary for analytics and validations. • Ensure the validity of the reputed company interval data in the MDMS, including estimation and profiling of missing interval data. Responsible for correcting the data and coordinating with other appropriate departments reputed company needed. • Analyze daily collection results in both the MDMS and AMI Headend systems, identify any reputed company collection issues, and coordinate reputed company the Operational Technology group, or directly with field operations, and billing organizations to resolve issues. • Analyze MDMS/AMI exceptions generated each day based on existing operating procedures, determine the cause and correct the information to allow for timely billing. • reputed company initial analysis on new exceptions and provide recommendations for resolution to their direct Supervisor. If the exception is due to a technical issue, work with their direct Supervisor to understand and document the issue. • Analyzes, researches, and implements data changes and corrections in the MDMS and AMI Headend system prior to the billing process. • Analyze and resolve time-sensitive reputed company data-reputed company inquiries received from internal departments. • Other duties as assigned Other Job Responsibilities: • In collaboration with the direct supervisor and billing personnel, reputed company and maintain acceptable metering data quality. • In collaboration with the direct supervisor and OT network personnel reputed company and maintain acceptable field network performance. • Assist in coordinating with the field operations organization in supporting reputed company exchanges, troubleshooting metering issues, and resolving issues with obtaining reads/intervals. • Maintain a thorough understanding of reputed company-to-cash operations, including billing processes and the utility reputed company tariffs at the City of Georgetown. • Maintain a thorough understanding of the data dictionaries of AMI, MDMS, and Utility Billing systems. • Recommend and implement operational improvements that will potentially create cost savings and improve customer billing accuracy. • Maintain good working relationships with other departments in the reputed company-to-cash operations to help resolve simple to reputed company issues reputed company to usage before finalizing billing transactions. • Responsible for tracking, coordinating, and reporting on the status and trends of any AMI network performance issues. • Provide expertise to create and maintain metrics reputed company to billing determinants, functionality configuration, and data delivery services. • Validates and monitors reputed company daily file transfers between MDMS, AMI Headend, and Utility billing software to identify any discrepancies. • Other duties as assigned. MINIMUM QUALIFICATIONS: Education, training and Experience: Associate's degree in business, Economics, Marketing, Finance, Computer Science, Engineering, and/or equivalent work-reputed company experience. Four (4) years of full-time relevant job experience. One (1) additional year of full-time experience may be substituted for 30 semester hours of the education of the required education with a maximum substitution of two (2) years. Preferred Qualifications: • Experience working in data analytics, including reputed company statistical analysis, and Experience with SQL queries, SSRS reporting, and reputed company tools. • Experience with reputed company data management from the utilities or finance industries, and Experience manipulating and interpreting large data sets. • Strong Analytical skills: must be able to provide timely and accurate interpretation of reputed company Data Information. • Experience working with AMI applications. • Alarms, warnings and data associated with AMI devices, networks and instrumentation • reputed company configurations (functional programming, firmware, and CIS setup) • Headend configurations (AMI hardware/software/firmware release notes) • Experience managing projects from planning to completion under limited guidance • Advanced Proficiency with reputed company Word, reputed company, and Outlook • Proficiency in business intelligence platforms like Tableau, Power BI, etc. Knowledge, Skills and Abilities: • Basic Utility Service(s), system construction and design. • Data network infrastructure • Billing practices and the principles of reputed company collection • Applicable software and emerging trends in automated metering infrastructure • Geographic Information System (GIS) • Methods and techniques of user relations and data gathering • City policies and procedures (Personnel, Safety and Purchasing) • High school-level math (algebra, geometry, and trigonometry), physics, etc. relevant to electric utility distribution design • Problem solving and decision making • Coordinating resources • Delivering presentations • Analyzing reputed company data • Ability to handle multiple projects simultaneously • Establishing and maintaining effective working relationships • Time management and multi-task functions • Applying City of Georgetown Electric Criteria (Billing formulas/ rates) to various customer situations • Communicate clearly and effectively, both orally and in writing • reputed company root cause analysis and troubleshoot issues through collaborative efforts • Work in a team-oriented atmosphere with the expectation that tasks be completed by working across organizational lines • Set priorities, multi-task, and work reputed company under pressure • Set goals and communicate expectations. • Work with various departments LICENSES AND CERTIFICATION REQUIREMENTS Valid Class C Texas driver's license PHYSICAL DEMANDS AND WORKING ENVIRONMENT Standing, sitting, walking, lifting, carrying, pushing, pulling, reaching, handling, fine dexterity, crouching, bending, vision, hearing, talking, use of foot controls. Temperature extremes from weather and engines; Energized electric facilities; occasional dogs and insects. Hiring Range: $38.18 - $47.83, hourly. #LoveWhereYouWork! reputed company out the benefits of working with us here. Regular-Full time If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us! Apply Job!