The Financial Systems Analyst (FSA) helps Business Services division under Chief Financial Officer bridge gaps between technology and business processes, enabling leadership to make informed business decisions which contribute to maintaining its competitive margin and financial integrity in the ever-evolving electric utility industry.
The FSA is directly responsible for the development and maintenance of financial systems utilized within Finance, and is a strategic partner for the team, which includes Financial Planning and Analysis, Revenue Pricing and Analysis, Budgets, Accounting, and Treasury.
The FSA assists software package users in day-to-day activities, including but not limited to data loads, maintenance, data extraction, maintenance of the existing systems, and development of new reporting packages.
The FSA analyses and researches existing processes that are configured outside of the structured software platform, documents processes, proposes and assists in the implementation efforts of solutions within the financial software platforms.
Assist with design and maintenance of automated financial tools and systems to ensure quality information and reports are produced and delivered to senior management on a timely basis.
Job Functions & Responsibilities
Develop and maintain "flat file" data preparation tools to ensure seamless input data loads into SAC software platform.
Perform SAC master data maintenance and necessary updates.
Support various SAC end users in resolution of issues related to software navigation, data version updates and reporting.
Conduct research, document findings, propose and present solutions for migration of existing Excel based processes into the SAC platform.
Collaborate with IT staff and/or outside vendor(s) in effectuating configuration changes requiring advanced system knowledge.
Implement additional reports to present data in a concise and useful fashion.
Implement financial models and modeling changes to quantify the potential impacts of industry changes and changes in overall business, including net income forecasts, cash flow forecasts, and relevant financial metrics. Test calculations and ensure accuracy of the models.
Represent Business Services during additional software selection processes and subsequent implementations.
Working knowledge of one or more of the following areas required: finance, mathematics, accounting, or economics.
Familiarity with utility finance and/or the NYISO market preferred.
Strong analytical and research skills required.
Ability to organize data, conduct research, document findings and report on analyses in a logical and effective manner, and a demonstrated ability to adapt to rapidly changing environments.
Proficiency with Microsoft Excel, Word, PowerPoint, and other computer applications and file organization procedures is required.
Demonstrated ability to use Pivot Tables, Tables and Database formulas within MS Excel.
Excel test will be conducted during the interview.
Working knowledge of SAC, SAP BI and /or NYISO DSS, is preferred.
Effective communication and interpersonal skills.
Ability to work closely with others in achievement of group and cross-departmental goals.
Ability to organize and prioritize job assignments and complete tasks in a timely manner, at times, with limited supervision.
Proactive attitude toward learning and implementing change.
Education & Certifications
Bachelor's degree in Economics, Finance, Mathematics, Business, or equivalent required.
Utility experience with an understanding of corporate finance and governmental regulations and requirements preferred.