Division Order Analyst

Targa Resources; Houston (TX); On-site; USD 65,000 - 95,000; Full time

Job summary

Targa Resources is seeking a Division Order Analyst in Houston, TX to manage monthly checkwrite jobs in the W Energy system, reconcile settlement data, and review variances. You will process ownership transfers, set up division order screens, and handle balance write-offs and adjustments in W.

The role supports escheat calculations and state payments while maintaining SharePoint records and Excel-based reconciliations.

Qualifications

• Associate Degree (with underlying High School Diploma), or College Degree.
• 3 to 5 years energy experience in division order setups and title documents.
• Results driven, takes initiative, accountable and responsible, can work independently and within/across teams.
• Strong verbal and written communication skills.
• Strong interpersonal skills with internal and external stakeholders.
• Thrives in a fast paced, high-performance environment with multi-tasking.

Responsibilities

• Process monthly checkwrite jobs in W Energy, generate reconciliation spreadsheet and review variances.
• Review ownership change documents and prepare Transfer Orders.
• Setup/update Division Order/Contract Allocation screens in W for meters and contract changes.
• Generate and process balance write off in W.
• Generate owner manual adjustments for Customer Service Rep. to process in W.
• Process transfer/suspense/release in W per instructions
• Monthly review of royalty suspense and determine resolutions for owners/states/contracting parties
• Maintain Division Order Matrix in Microsoft Lists and SharePoint repository for ownership changes
• Assist escheat processing and reporting and submit payments to States before deadlines
• Generate escheat reconciliation in OneStream
• Handle inquiries from customers regarding title issues and owner accounts
• Assist with ad-hoc requests and analyses
• Back-up other Division Order Analysts as needed

Skills

Microsoft Office

W Energy

Verbal and written communication

Interpersonal skills

Analytical skills

Systems aptitude

Education

Associate degree or higher

Tools

Oracle

SharePoint

W Energy

Job description

• Process monthly checkwrite jobs in W Energy (“W”) application, generate reconciliation spreadsheet using settlement summary provided by accounting and Cognos reports, review/resolve variances on reconciliation spreadsheet, Cognos Reconciliation Detail report and/or Boomi failures, generate Oracle WF Invoice Payment Status report to send to treasury and send checkwrite files to Customer Service Rep.
• Review ownership change documents, process transfer in W, and prepare/distribute Transfer Orders according to industry and company guidelines
• Setup/update Division Order and/or Contract Allocation screens in W for new connect/reconnect/ disconnect meters and contract changes instructed by Contract Analyst
• Generate and process balance write off in W
• Generate owner manual adjustments for Customer Service Rep. to process in W
• Process transfer/suspense/release in W instructed by Assignment Group and/or Contract Analyst
• Monthly review of royalty suspense and determine resolution to submit payment to the owner, escheat to the State or invoice/write off for contracting parties
• Maintain Division Order Matrix in Microsoft Lists to track requests for ownership changes and suspense review
• Maintain SharePoint repository for storing electronic ownership change records
• Assist and back‑up for escheat processing and reporting by generating the required state forms and submitting payments to the States before deadline
• Generate and upload escheat reconciliation spreadsheet into OneStream application
• Handle phone calls, emails, and mail from external and internal customers regarding title issues/inquiries and owner account questions
• Handle special projects as delegated by manager
• Assist and back‑up other Division Order Analyst as needed
• Assist with ad‑hoc requests and analysis as needed

JOB FUNCTIONS AND KEY RESPONSIBILITIES:

• Process monthly checkwrite jobs in W Energy (“W”) application, generate reconciliation spreadsheet using settlement summary provided by accounting and Cognos reports, review/resolve variances on reconciliation spreadsheet, Cognos Reconciliation Detail report and/or Boomi failures, generate Oracle WF Invoice Payment Status report to send to treasury and send checkwrite files to Customer Service Rep.
• Review ownership change documents, process transfer in W, and prepare/distribute Transfer Orders according to industry and company guidelines
• Setup/update Division Order and/or Contract Allocation screens in W for new connect/reconnect/ disconnect meters and contract changes instructed by Contract Analyst
• Generate and process balance write off in W
• Generate owner manual adjustments for Customer Service Rep. to process in W
• Process transfer/suspense/release in W instructed by Assignment Group and/or Contract Analyst
• Monthly review of royalty suspense and determine resolution to submit payment to the owner, escheat to the State or invoice/write off for contracting parties
• Maintain Division Order Matrix in Microsoft Lists to track requests for ownership changes and suspense review
• Maintain SharePoint repository for storing electronic ownership change records
• Assist and back‑up for escheat processing and reporting by generating the required state forms and submitting payments to the States before deadline
• Generate and upload escheat reconciliation spreadsheet into OneStream application
• Handle phone calls, emails, and mail from external and internal customers regarding title issues/inquiries and owner account questions
• Handle special projects as delegated by manager
• Assist and back‑up other Division Order Analyst as needed
• Assist with ad‑hoc requests and analysis as needed

MINIMUM ESSENTIAL QUALIFICATIONS:

• Associate Degree (with underlying High School Diploma), or College Degree
• 3 to 5 years energy experience working in all areas of division order setups and reviewing title documents including wills, probate documents, trust documents, assignments, deeds, and title opinions
• Results driven, takes initiative, accountable and responsible, can work independently and within/across teams
• Strong verbal and written communication skills
• Strong interpersonal skills with the ability to build relationships internally at all levels and with external stakeholders
• Thrives in a fast paced, dynamic, high-performance work environment with the ability to multi-task and prioritize assignments
• Must be flexible and able to adapt as business needs change
• Strong analytical and problem-solving skills
• Strong systems aptitude and process orientation
• Exposure to computer systems and related skills, including Microsoft Office Suite and W Energy
• Regular and reliable attendance

PREFERRED QUALIFICATIONS:

• 3 years of accounting experience with knowledge of performing close activities and account reconciliations
• Familiarity with Oracle, SharePoint and W Energy applications
• Division order experience working in Kansas, Louisiana, New Mexico, North Dakota, Oklahoma, and Texas

EQUAL EMPLOYMENT OPPORTUNITY:

Targa Resources provides equal employment opportunities based on merit, experience, and other work-related criteria and without regard to race, color, ethnicity, religion, national origin, sex, age, pregnancy, disability, veteran status, or any other status protected by applicable law. We also strive to provide reasonable accommodation to employees’ beliefs and practices that do not conflict with Targa’s policies and applicable law. We value the unique contributions that every employee brings to their role with Targa.