Sr Business Analyst - Business Spec.
across Meter Data Management (MDM) and settlement platforms into actionable insights and defensible financial outcomes. These capabilities apply across networked utility industries-including electric, natural gas, and water - where accurate, time-based measurement data is critical to operations and revenue.In electric markets such as CAISO's Extended Day-Ahead Market (EDAM), the role ensures settlement-quality data (SQMD) aligns with approved plans, market timelines, and submission requirements. More broadly, it supports the MDM settlement lifecycle, where field measurements are validated, estimated, and aggregated to enable downstream settlements, billing, and reporting.The successful candidate works across systems and teams to reconcile discrepancies, interpret complex configurations (e.g., resource hierarchies, aggregation rules, power flow paths), and maintain end-to-end data integrity. The role applies strong analytical and systems thinking to identify anomalies, perform root cause analysis, and implement scalable solutions that improve data quality and process reliability. Responsibilities include aligning data with evolving market rules, contracts, and regulatory requirements, while translating insights into sustainable workflows and system enhancements.The position partners closely with operations, engineering, IT, and finance to communicate data integrity findings, support audits and data requests, and drive process improvements that enhance automation, transparency, and accuracy.This position is being posted at multiple levels. Once a selection is made the team will determine which level to offer based on selected candidates education, experience and skill set.ResponsibilitiesResponsibilities of the Senior Business Analyst include the following:Perform and/or own daily validation, editing, and estimation (VEE) of Settlement Quality Meter Data (SQMD) for EDAM resources, with a focus on assigned meter populations (e.g., ELAP, third-party load, or generation resources), ensuring accuracy and completeness prior to submission to CAISO MRI-S. Serve as a trained backup for full-scope VEE execution to support operational redundancy and continuity of submission timelines (T9, T55, monthly).Monitor and reconcile third-party load and generation SQMD submissions, including Scheduling Coordinator-submitted data, against PacifiCorp-calculated values to identify configuration changes, data discrepancies, and potential settlement impacts.Validate MRI-S pullback data from third-party Scheduling Coordinators by comparing CAISO-returned values to Joules calculations, Day-Ahead bids (CMRI data), and internal meter/source-system records.Perform recurring VEE and source-meter review for third-party load meters, including validation of MV90, IEE, and related EAS schedule inputs used in Joules load calculations.Monitor third-party SQMD configurations and submitted values for uncommunicated changes, coordinating with internal stakeholders and third-party Scheduling Coordinators to resolve discrepancies and maintain alignment with approved SQMD plans.Research and analyze complex data.Conduct analysis through research, gathering, and interpretation of data.Present analysis and recommendations to management and implement selected alternative.Maintain and validate data impacting financial results, including reconciliation of NSL loads, borderline invoices, and PACE Joules borderline meter-data calculations against applicable transmission invoicing.Validate California Independent System Operator - Extended Day Ahead Market (EDAM) generation, interties and load resources, ensuring adherence to SQMD plans. Validate meter data submissions to MRI-S for EDAMExecute meter data completeness checks, identify anomalies, and perform root cause analysis on missing, late, or inconsistent interval data across MV90, BPA sources, JLS, and Joules.Prepare, package, and validate outbound MRI S submissions, ensuring data meets CAISO format, timing, and quality requirements to support T9, T55, and monthly settlement cycles.Support and/or execute recurring Unaccounted-for Energy (UFE) validation processes, including weekly checks comparing submitted SQMD against expected system load and generation balances, identifying discrepancies and driving corrective actions to ensure alignment with CAISO settlement outcomes.Compare interrogated meter data against multiple sources and validate end-of-hour data in the Energy Accounting System.Analyze energy flow, single line diagrams, and transmission network diagrams, and propose alternate sources of meter data.Generate reports for data requests to meet customer needs.Additional Responsibilities for the Business Specialist position include the following:Identify and recommend policy, management, procedural, process and system improvements to strategically balance risk and reward.Support creation, review, and updates to ELAP, EIDE, and EDAM load/resource configurations within Joules and JLS to ensure accurate representation of PacifiCorp assets in CAISO markets.Support configuration and maintenance of Joules virtual meters, meter profiles, and estimation logic to improve continuity, traceability, and reliability of settlement-quality meter data when raw source data is delayed, missing, or unavailable.For EDAM load serving entities (LSE) maintain, and corroborate Settlement Quality Meter Data (SQMD) plans, including mapping of meters to resources, aggregation rules, calculation logic, and data lineage documentation.Identify opportunities to streamline meter data processes within Joules, automate data validation routines with SQL coding, and improve reliability of load/resource reporting.Monitor and manage the Joules Support email inbox to provide customer service for third-party Joules Portal users, including support for data requests, access coordination, issue triage, and communication of SQMD configuration changes, and data submission alignment.Provide recommendations and implement process and procedural improvements through research of best practices and effective presentation of information, plans and proposals.RequirementsRequirements for the Senior Business Analyst include the following:Bachelor's degree in Business Administration, Finance, Mathematics, Physical Sciences, or other applicable field; or the equivalent combination of education and experience.A minimum of four years of directly related experience in gathering, analysis, interpretation, trending, forecasting, and modeling skills.Proficient Microsoft Excel skills to compile, analyze, line graph and summarize complex data.Proficient with the use of personal computers including databases, word processing, and presentation applications to gather, analyze, and model information.Advanced communication and interpersonal skills to interface with team members and customers to promote positive customer outcomes.Ability to work with all levels of an organization, including people with different styles and backgrounds, and ability to work as a member on a team.Ability to present alternatives and recommendations.Teamwork skills to negotiate with and influence peers and management on policy and strategic issues.Knowledge of applicable company policies and procedures; applicable federal, state, and local governmental laws and regulations.Proven problem-solving skills.Additional Requirements for the Business Specialist position include:Minimum of five years related experience.Research and analysis skills including the ability to obtain relevant data, evaluate complex situations, develop creative alternatives, provide recommendations, and negotiate and influence outcomes.Excellent communication and interpersonal skills involving the ability to establish trust, maintain confidence, and understand social behavior and interactions.Ability to work with all organizational levels to influence actions and negotiate outcomes.PreferencesPreferences for the Senior Business Analyst role include:Knowledge and understanding of the electric utility industry and its regulatory and operating environments.Experience working with energy accounting and meter data.Experience with developing graphical reports to communicate results of complex analysis.Knowledge of applicable company policies and procedures; applicable federal, state, and local governmental laws and regulations.Additional Preferences for the Business Specialist position include:Understanding of the operation and function of line and substation equipment.Familiarity with grid operations, including how system topology, transmission constraints, and balancing area dynamics influence metering, load allocation, and EDAM settlements.Experience performing power flow analysis in Monarch, with the ability to interpret study results and understand impacts of outages, topology changes, and boundary meter implications.Strong understanding of meter data reconciliation, including comparing MV90 interrogations against BPA, SCADA, PI, and Joules/JLS data sources to ensure interval level accuracy.Experience with interdepartmental data sharing, including coordination with Transmission, Grid Operations, Settlements, Load Forecasting, and Jurisdictional Loads to align MV90 and related datasets.Working knowledge of EAS pyramid structure, including how data aggregates from meter profiles accounts load/resource groupings used in the net system load pyramid, operational reporting, and EDAM submittals.Familiarity with SCADA and PI DataLink tools to retrieve, trend, validate, and reconcile operational data for settlement quality processes.Ability to interpret market rules, regulatory requirements, contracts, tariffs, or approved operating plans and translate them into auditable data processes, calculations, and controls.Experience developing, maintaining, or supporting audit-ready documentation, control evidence, data lineage, and reconciliation procedures for high-impact operational or financial data.Demonstrated ability to coordinate with external parties, vendors, customers, or market participants to resolve data discrepancies, access issues, configuration changes, or submission alignment matters.Ability to lead cross-functional resolution of complex data, system, or settlement issues without direct authority, including coordinating work across operations, engineering, IT, finance, and external stakeholders.BenefitsAt PacifiCorp, we understand that living a healthy lifestyle isn't just about your physical health - your mental, financial, and social wellbeing also play an important role. That's why we offer a wide range of benefits designed to help you live a more balanced lifestyle.Our benefits include:Medical, dental, and vision insurance401k with match fixed contributions, including a Roth and saving option. For union employees, matching contributions vary by union. For nonunion, PacifiCorp makes a fixed contribution equal to 4% of your eligible pay each year for new hires. In addition, PacifiCorp matches 100% of the first 6% you contribute.Life insuranceAdditional voluntary benefits, including pet insuranceTuition AssistanceMass Transit Pass for employees in our Portland and Salt Lake City Offices.Work Life BalanceGenerous Paid Time Off (PTO) - Time off varies by employee type (Union or Non-Union)Paid short-term disability leave and long-term disability insurancePaid Parental LeavePaid Bereavement LeaveEmployee Assistance Program supporting mental and emotional wellbeingFor more information, please visit: https://careers.pacificorp.com/content/New-Benefits-Page/?locale=en_USAdditional InformationReq Id: 114768 Company Code: PACIFICORP PM25 Primary Location: SALT LAKE CITY 100% ONSITE Department: CFO Schedule: Full-Time Personnel Subarea: ExemptHiring Range: 77,200 - 122,100Target Incentive percentage: 12%PacifiCorp is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or religious creed, age, national origin, ancestry, citizenship status (except as required by law), gender (including gender identity and expression), sex (including pregnancy), sexual orientation, genetic information, physical or mental disability, medical condition, veteran or military status, familial or parental status, marital status or any other category protected by applicable local, state or U.S. federal law.Unless otherwise required by law, all offers of employment are contingent upon the successful completion of a background check and drug screening including for marijuana. While marijuana is legal in several states, including Oregon, a positive test for positions in Oregon may disqualify a candidate. The company complies with the laws of Washington and California and only obtains and considers positive tests for marijuana in safety-sensitive positions or those covered by U.S. Department of Transportation regulations.Employees must be able to perform the essential functions of the position with or without an accommodation.Nearest Major Market: Salt Lake City Career Segment: Compliance, Sustainability, Business Analyst, Law, Legal, Energy, Finance, TechnologyCompensation details: 77200-122100 Yearly SalaryPI9173b0a72995-25660-41033020
