Senior Settlement Analyst (hybrid)

Senior Settlement Analyst We are open to hire at either the Senior or Lead Market Settlement Analyst level, depending on experience (salary band and job requirements listed are for senior level) Essential Functions Identifies and understands issues, problems, and opportunities; compares data from different sources to draw conclusions; uses effective approaches for choosing course of action or developing appropriate solutions; takes action that is consistent with available facts, constraints, and probable consequences. (Professional Judgement) Compiles, organizes and formats data, including qualitative analysis required for internal and external reporting. Identifies and researches reporting issues, provides recommendation, assists with adoption of new reporting requirements. (Reporting) Recognizes situations where the regulatory framework and rate case outcomes drive our business; supports regulatory initiatives by gathering data and preparing regulatory schedules and/or preparing pro-forma calculations, testimony and data requests; assists with review and analysis of regulatory documents; appreciates the application of the regulatory construct to our business. (Regulatory) Understands terminology and developments related to the MISO and the market settlement process; knows how to reconcile the third-party shadow settlement system and financial statements; able to design test scripts and to perform testing of internal controls for Sarbanes-Oxley purposes; knows when to and can apply technical knowledge to processes, procedures, and tasks. (Technical/Professional Knowledge and Skills) Demonstrates a working knowledge of financial statements, metrics and measures, and key strategic business initiatives; understands and utilizes economic and industry data as it relates to job responsibilities. (Business Acumen) Demonstrates a working knowledge of the MISO transmission and energy markets. Has a general knowledge of other departments within the electric part of Energy Supply and Optimization (ES&O) organization. Collaboratively develops solutions between and within ES&O and Accounting and Rates; Verify and prepare documentation related to the cash settlement process for MISO. (Understanding Market Settlements) Demonstrates our commitment to quality by documenting work fully and accurately. (Documentation of Work Performed) Takes action to identify, analyze and improve existing processes within our organization to maximize opportunities for efficiency and effectiveness and meet new goals and objectives. (Continuous Process Improvements) Required Qualifications For Position Requires 4 year degree in business discipline 4-6 years experience in Finance, Accounting, Regulatory or a related field Requires knowledge of PC applications Knowledge proficiency of Finance and Accounting principles, including the relationships between segments of the financial statements (e.g. balance sheet, income statement, and cash flow) Knowledge proficiency of MISO charge type, including the relationship between segments of the settlement statements (e.g. MISO markets, NIPSCO resources, NIPSCO load) Operation of third-party shadow settlement system to understand, report and verify charges and credits submitted by MISO Analyze information from a variety of sources to detect trends, associations, cause-effect relationships and other anomalies and make recommendations. Effectively manages time to ensure deadlines are met and quality is achieved. Possess an in-depth knowledge of Microsoft Excel pivot tables, macro creation, and statistical analysis, as well as, data scrubbing and creation of Power BI dashboards or other Data Analytics tools. Presentation skills, verbal and written communication skills Experience with writing prompts for use in Copilot Preferred Additional Qualifications for Position MBA Prefer multiple functional experience As a public utility, NiSource provides essential services to customers 24/7. Emergency needs can arise at various times