Sr. Masterfile Analyst
Denver, CO
Full Time
Accounting
Experienced
| Position Title: Department: | Sr. Masterfile Analyst Accounting |
| Location: | Denver |
| Reports to: | AP / JIB Supervisor |
| Salary Range: | $78,000 - $90,000 |
Job Summary
The Sr. Masterfile Analyst is responsible for maintaining and ensuring the accuracy, integrity, and consistency of master data across the organization’s systems. This role supports critical business functions by maintaining revenue owners, JIB partners and vendors master records, ensuring compliance with company standards and industry regulations. The analyst collaborates with cross-functional teams—including accounting, land, finance, and operations—to validate data, troubleshoot discrepancies, and implement process improvements. Strong attention to detail, data governance knowledge, and proficiency in ERP systems are essential for success in this position.
Essential Functions
- Accurate setup and maintenance of Business Associates, wells, allocation groups, prospects, cost centers, AFE’s and initial decks in both Quorum ODA and OpenInvoice.
- Set up and maintenance ACH payment requests and verify ACH data is valid, accurate and matches account data for future payments.
- Publish, release and monitor AFE’s between AFE Navigator, Quorum ODA and OpenInvoice.
- Prepare information for 1099 IRS process annually. Submit Bulk TIN reports as scheduled to identify missing/incorrect Tax Identification Numbers.
- Create and manage tickets through the owner relations system, including communicating to owners through email or by phone.
- Accurate setup and maintenance of BA’s in OpenInvoice and relevant account mapping. Onboarding of new vendors in OI.
- Troubleshoot inconsistencies between information points by recognizing and understanding key relationships among the Company’s accounting, volumetric and land related systems and processes.
- Perform timely analysis and validation of data imports between Quorum ODA and OpenInvoice and resolve issues.
- Assist with ERP system upgrades, testing, and integration related to master data.
- Provide training and guidance to end-users on master data procedures.
- Performs other duties as assigned.
SKILLS AND KNOWLEDGE
- Working knowledge of Microsoft Office Suite (emphasis on Excel using VLOOKUPS and pivot tables.
- Excellent attention to detail with a high degree of accuracy.
- Good time management and organizational skills, with the ability to multi-task and prioritize work to meet set deadlines.
- Basic knowledge of accounting software, accounts payable and invoicing platforms like Quorum ODA and/or OpenInvoice.
- Strong written and verbal communication and customer service skills.
- Advanced skills in Microsoft Excel and other Office applications.
- Strong understanding of oil and gas accounting principles, including cost allocation, lease operating expenses, and AFE reporting.
- Knowledge of regulatory compliance standards.
- Exceptional analytical skills with the ability to interpret complex financial data.
- Effective communication skills for liaising with partners and auditors.
- Strong organizational abilities to manage multiple priorities under tight deadlines.
- Experience with OpenInvoice systems.
- Familiarity with tax regulations relevant to the oil and gas industry.
Qualifications
- Bachelor’s Degree from an accredited institution.
- At least three (3) years of experience in Oil and Gas Industry.
- At least three (3) years of experience with accounting software, accounts payable and invoicing platforms such as Quorum ODA and/or OpenInvoice.
Supervisory Responsibilities
No supervisory responsibilities
Work environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
- Job is performed in an office setting with exposure to computer screens and requires regular use of a computer, keyboard, mouse, and multi-line telephone system.
- The noise level in the office environment is usually quiet.
- Specific vision abilities required by this job include close vision, distance vision and ability to adjust focus.
Physical demands
- May require occasional lifting of heavy objects.
- The employee is regularly required to stand, walk, and reach with hands and arms.
employee benefits
Prairie Operating Employee Co., LLC offers competitive compensation and benefits programs which include, but are not limited to, health care coverage, retirement plan, protection coverage, time off and leave programs, training and development opportunities and a range of allowances connected to specific work situations.
We do not discriminate on the basis of race, religion, national origin, sex, sexual orientation, gender identity, age, physical or mental disability, marital status or veteran status.
Prairie Operating Employee Co., LLC reserves the right to modify this job description at its discretion at any time. This job description is not intended to be all-inclusive and does not imply that these are the only duties to be performed by the employee(s) incumbent in this position. Employee(s) will be required to follow any other job-related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments.”
Apply for this position
Required*