Utility Applications Analyst

SELCO•Shrewsbury, MA

5d•Onsite

About The Position

Under the general direction of the Director of Finance and Administration, serves as the functional administrator and subject matter expert for the organization’s enterprise utility software applications. Responsible for system administration, configuration, reporting, data analysis, testing, security, and ongoing support. Works across departments and with vendors to optimize system functionality, improve business processes and data quality, develop reporting solutions, troubleshoot issues, and support operational and financial decision-making.

Requirements

Strong analytical and problem-solving skills, with the ability to evaluate complex business and system issues, troubleshoot application and data problems, and develop effective solutions.
Strong knowledge of ERP and enterprise applications, including utility billing, financial, customer information, work order, purchasing, inventory, fixed asset, and related business systems and processes.
Strong knowledge of ERP reporting and data structures, including relational data, tables, fields, relationships, queries, filters, calculated fields, parameters, and reporting logic, with the ability to independently develop complex reports, dashboards, extracts, and analytical tools.
Knowledge of application administration and system configuration, including user administration, roles and permissions, workflows, business rules, system controls, interfaces, and the ability to translate business requirements into system and reporting solutions.
Ability to test, troubleshoot, and support enterprise applications, including configuration changes, reports, interfaces, data issues, upgrades, and other system modifications in a production environment.
Advanced proficiency with spreadsheet and data analysis tools and familiarity with SQL, database querying, business intelligence/reporting tools, APIs, integrations, and similar technologies.
Strong organizational and communication skills, including the ability to manage multiple priorities, communicate between technical and non-technical stakeholders, develop system documentation and training materials, exercise independent judgment, and appropriately handle confidential information.
Bachelor's degree in Information Systems, Business Administration, Accounting, Finance, Computer Science, Data Analytics, or a related field; or an equivalent combination of education, training, and experience.
Three to five years of progressively responsible experience administering, supporting, configuring, reporting from, or analyzing ERP, utility billing, financial management, customer information, or comparable enterprise software systems.
Experience creating complex reports, queries, data extracts, dashboards, or analytical solutions using enterprise application data is required.

Nice To Haves

Experience participating in a major enterprise system implementation, conversion, upgrade, or module deployment is strongly preferred.
Experience with utility software systems, municipal operations, financial systems, or ERP applications is preferred.
Experience with SQL, relational databases, business intelligence/reporting applications, or ERP report-writing tools is strongly preferred.

Responsibilities

Serves as the lead functional administrator and principal technical authority for Utility Billing, Financial Management, Metering, Work Orders, Customer Information, Plant Accounting, Inventory, Purchasing, and related systems.
Administers, configures, maintains, and supports enterprise applications, including system settings, workflows, business rules, templates, rates, account structures, user-defined fields, security roles, permissions, and other system functionality.
Develops and maintains complex reports, queries, dashboards, data extracts, and analytical tools using ERP and relational data, combining financial, operational, customer, billing, work order, purchasing, inventory, and other enterprise information to support management and organizational decision-making.
Analyzes business processes and system functionality to identify and implement opportunities for improved efficiency, automation, data quality, reporting, internal controls, and utilization of existing technology.
Coordinates with Information Technology, software vendors, and consultants to troubleshoot and resolve application, integration, database connectivity, security, performance, and other technical or functional issues, including managing vendor support cases through resolution.
Plans, coordinates, tests, and validates system changes, including software upgrades, patches, configuration changes, rates, reports, workflows, interfaces, new modules, and other modifications to ensure accurate and reliable system operation.
Participates in system implementations, conversions, upgrades, integrations, and module deployments, including data mapping, conversion, validation, reconciliation, testing, and troubleshooting of interfaces and data exchanges between systems.
Develops and maintains system documentation covering configurations, reports, workflows, business rules, procedures, interfaces, security roles, and other application functions; provides technical and functional training and guidance to system users.
Maintains knowledge of system capabilities, vendor product developments, reporting tools, upgrades, and emerging technologies and recommends enhancements that improve organizational processes and system functionality.
Provides data analysis and technical support for management initiatives and special projects, including the extraction, reconciliation, interpretation, and presentation of enterprise system data; performs other related duties as required.