Senior Settlement & Billing Analytics Analyst

PacifiCorp; Salt Lake City (UT); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

Life insurance

Generous PTO

Disability insurance (short-term &

Employee Assistance Program

Job summary

PacifiCorp, based in Salt Lake City, seeks a Senior Financial Accounting Analyst to validate transmission settlement and customer billing, research discrepancies, and support financial reporting. The role sits at the intersection of accounting, data analysis, and contract administration, requiring strong analytical skills and the ability to work with internal partners and customers.

Responsibilities include settlement validation, billing analysis, and journal entries, with a focus on accuracy,

Qualifications

• Bachelor's degree in Accounting or related field and 5+ years of experience in accounting/finance.
• Experience investigating discrepancies and reconciling financial results.
• Experience supporting customers, stakeholders, or cross-functional teams.
• Experience validating calculations, reports and financial results.
• Ability to explain data lineage from source transactions to reporting outputs.
• Advanced Excel and analytical tool proficiency (Power BI, Tableau, SQL).
• Experience with SAP and financial systems preferred.

Responsibilities

• Settlement Validation & Analysis: Validate transmission settlement and billing outcomes for accuracy and completeness.
• Investigate discrepancies, trace transactions, research data, and perform trend and variance analyses.
• Prepare and review customer invoices; interpret contracts and tariff provisions for accurate billing.
• Prepare journal entries, reconciliations, and supporting documentation; support regulatory reporting.
• Identify process improvements; document procedures and collaborate with cross-functional teams.

Skills

Advanced Excel

Pivot Tables

XLOOKUP

Power Query

Power BI

Tableau

SQL

Data analysis

Financial analysis

Discrepancy investigation

Education

Bachelor's degree in Accounting, Finance, Business Analytics, Engineering, Information Systems, or a related field

Tools

SAP

Financial systems

Job description

PacifiCorp, based in Salt Lake City, seeks a Senior Financial Accounting Analyst to validate transmission settlement and customer billing, research discrepancies, and support financial reporting. The role sits at the intersection of accounting, data analysis, and contract administration, requiring strong analytical skills and the ability to work with internal partners and customers.

Responsibilities include settlement validation, billing analysis, and journal entries, with a focus on accuracy,