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 seeks a Senior/Lead Market Settlement Analyst to join our team in Indiana. You will analyze market settlements, reconcile shadow systems with financial statements, and support regulatory reporting and new requirements.

Candidates should have a 4-year degree in business and 4–6 years in Finance/Regulatory, with strong Excel and Power BI skills. This on-site role emphasizes accuracy, collaboration and process improvement.

Qualifications

• Requires a 4 year degree in business or related field.
• 4-6 years experience in Finance, Accounting, Regulatory or related field.
• Proficient in PC applications and finance principles including balance sheet, income statement and cash flow.
• Aquainted with MISO charge types and settlement statements relations.
• Experience operating third-party shadow settlement systems for MISO reporting.

Responsibilities

• Identify issues, analyze data from multiple sources and propose actions.
• Compile, organize and format data for internal and external reporting.
• Research reporting issues, provide recommendations and assist with new requirements.
• Support regulatory initiatives with data gathering and schedules or pro-forma calculations; review regulatory docs.
• Understand MISO market settlements; reconcile shadow settlement system with financials; design test scripts for internal controls (SOX).
• Know and apply market settlement concepts; collaborate with ES&O and Accounting; prepare cash settlement documentation.
• Document work thoroughly to reflect quality, and seek process improvements to enhance efficiency.

Skills

Professional Judgement

Regulatory knowledge

Financial statements

Data analysis

MISO knowledge

SOX testing

Time management

Presentation skills

Copilot prompts writing

Education

Bachelor's degree in business

Tools

Excel Pivot Tables

Excel Macros

Power BI

Job description

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

• 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

• MBA
• Prefer multiple functional experience

Employment Information

As a public utility, NiSource provides essential services to customers 24/7. Emergency needs can arise at various times throughout the year, including during storm season. Employees may be required to support emergency response efforts, which could include working outside normal hours or assisting with tasks outside of typical responsibilities.

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

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.

Posting Start Date: 2026-10-16 Posting End Date (if applicable): 2026-10-30 Please note that the job posting will close on the day before the posting end date.

Company Culture

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. By applying, you may also be considered for other roles that match your skills and experience.

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)

About the Company

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. If you're interested in joining an inclusive, innovative company that fosters opportunity for growth, NiSource might be the place for you.