Senior Settlement Analyst (hybrid)

059 Northern IN Public Serv Co LLC; Merrillville (IN); On-site; USD 82,000 - 123,000; Full time

Job summary

NiSource is seeking a Senior Settlement Analyst to join the Energy Supply and Optimization team in the United States. The role focuses on analyzing financial data, reconciling MISO settlements, and preparing regulatory schedules and pro-forma calculations.

You will build data-driven insights using Excel pivots and Power BI, document processes, and collaborate across ES&O and Accounting. Strong communication and SOX awareness are essential for accurate cash settlements.

Qualifications

• 4 year degree in business discipline.
• 4-6 years experience in Finance, Accounting, Regulatory or related field.
• Knowledge of PC applications.
• Finance and accounting principles knowledge 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.
• Experience with Excel pivot tables, macro creation, and data analytics tools (Power BI).
• Presentation skills, verbal and written communication skills
• Experience with writing prompts for use in Copilot

Responsibilities

• Identify issues, problems, and opportunities; compare data from different sources to draw conclusions; use professional judgement.
• Compile, organize and format data for internal and external reporting.
• Identify and research reporting issues, provide recommendations, assist with new reporting requirements.
• Support regulatory initiatives by gathering data and preparing regulatory schedules and/or pro-forma calculations, testimony and data requests.
• Understand MISO transmission and energy markets; reconcile shadow settlement system with financial statements; design test scripts for internal controls (SOX).
• Document work fully and accurately to ensure quality.
• Collaborate to improve processes for efficiency and effectiveness within ES&O and Accounting and Rates.

Skills

Financial analysis

Regulatory knowledge

Data analysis

Presentation skills

Copilot prompts

Education

Bachelor's degree in business

Tools

Microsoft Excel

Power BI

Job description

Senior Settlement Analyst

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

• 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

• MBA
• Prefer multiple functional experience

Work Authorization

Candidates must be legally authorized to work in the United States and must not require employer sponsorship now or in the future.

Workplace Connection

We value a workplace where everyone feels respected, included, and able to do their best work. We encourage open dialogue, value different perspectives, and work collaboratively with employees, customers, and partners. We recognize and respect the unique experiences people bring, including different backgrounds, cultures, and viewpoints. We treat others with professionalism and care, and we each play a part in creating a positive work environment.

Veteran Hiring & Inclusion

NiSource is proud to support veterans, transitioning service members, and military spouses. We value the leadership, teamwork, and mission-focused experience the military community brings, and we are committed to providing an inclusive workplace with opportunities for professional growth and development.

Equal Employment Opportunity

NiSource is committed to providing equal employment opportunities in each of its companies to all employees and applicants for employment without regard to race, color, religion, national origin or ancestry, veteran status, disability, gender, age, marital status, sexual orientation, gender identity, sex (including pregnancy, lactation, childbirth or related medical conditions), genetic information, citizenship status, or any protected group status as defined by law. Each employee is expected to abide by this principle.

ADA Accommodations

If you need a reasonable accommodation to participate in any stage of the hiring process or to perform the essential functions of the position, please contact OneHR at [e-mail] or 1-888-640-3320.

Safety Statement

Safety is a core value at NiSource. Employees are expected to follow safety requirements, report hazards, and help maintain a safe environment for themselves and their coworkers.

E‑Verify

NiSource participates in the U.S. Department of Homeland Security's E‑Verify program. Please review the following notices regarding your rights and responsibilities under U.S. law. E-Verify Poster (English and Spanish) Right to Work Poster (English and Spanish)

Salary Range

Salary Range*: $82,200.00 - $123,200.00 *The salary offered to a candidate is based on several factors including but not limited to the candidate’s skills, job-related knowledge, and relevant experience, as well as internal pay equity.

Employer Overview

At NiSource, you'll be part of the team serving nearly four million customers throughout the Midwest and Mid-Atlantic, who count on us to energize their homes and businesses. Whether speaking with customers by phone, analyzing financial data or installing new gas lines in a neighborhood, you’ll meet exciting challenges each day and make the most of your skills and talents. And you’ll be part of a company that was named by Forbes magazine as one of America’s Best Large Employers. We're looking for talent from all backgrounds. We invite candidates of all abilities to come as they are and do what they love. Through our years of successful growth, we’ve stayed true to our roots by making a difference in the lives of millions of our customers.