Air Force DEAMS Data Modeler

Kearney & Company is seeking a DEAMS Data Modeler to join our team! The successful candidate will serve as a key member of the Data Analytics Team and interact with DEAMS users in support of the sustainment of the Defense Enterprise Accounting Management System (DEAMS). This candidate is responsible for working with the Defense Enterprise Accounting Management System (DEAMS) Integrated Process Team (IPT) Leads to help ensure the successful sustainment of the Oracle ERP technology and financials modules for DEAMS. Potential candidates must have data analysis experience focusing on comparing disparate data sets from multiple sources. The successful candidate should have solid functional end-to-end AF Financial Management experience, including budget formulation/execution; IRT GAFS and DEAMS Reimbursable processes. Other responsibilities may include:

• Analyze existing Microsoft PowerBI data modeling to determine the applicable business rules associated with building the logic to tie-out O2C accounting and the P2P cost transfers between direct and reimbursable authority for GAFS and DEAMS transactions
• Distinguishing and defining Public and Federal posting logic processes that apply assessable units and business processes within the Universe of Transactions (UoT) QDD
• Determine and perform data extraction protocols, test proposed process, clearly document process
• Documenting Standard Operating Procedures (SOP) IRT reimbursable process/tools
• Assist with applying identified business rules and determining appropriate validation procedures within Advana and Envision
• Participate in working sessions and help in the design and requirements of this tool to fit the needs of both the financial reporting level as well as the base-level

• Minimum 5 years of technical experience
• Experience developing large data models
• Experience with Advana, Envision, or other cloud software enclaves
• Knowledge of DEAMS system
• Knowledge of Power BI suite
• Ability to create efficient data models using Microsoft Power BI Desktop's in-memory technology
• Understanding of the Department of Defense Standard Financial Information Structure (SFIS) and the United States Standard General Ledger (USSGL)
• Ability to obtain a U.S. secret level security clearance (requires US Citizenship)
• Must be willing and able to travel as required

Preferred Qualifications

• Bachelor's degree
• Experience with Oracle e-Business Suite (eBS) R12
• Experience with Oracle Cloud
• Knowledge of Air Force financial and logistics systems such as Air Force Equipment Management System (AFEMS), Automated Funds Management (AFM), Civilian Pay Accounting Interface System (CPAIS), Central Procurement Accounting System (CPAS), Commanders' Resource Integration System (CRIS), Defense Civilian Payroll System (DCPS), General Accounting and Finance System Base Level (GAFS-BL), General Accounting and Finance System Re-Engineered (GAFS-R), Integrated Accounts Payable System (IAPS), Job Order Cost Accounting System II (JOCAS II), Standard Base Supply System (SBSS), Standard Materiel Accounting System (SMAS), and Wide Area Work Flow (WAWF)
• Detailed familiarity with AF Lines of Accounting and financial data elements

This position is currently remote. Management or the client may adjust or eliminate the remote work arrangement at any point. This would require employee presence at a defined work location on a full-time or hybrid basis, depending on client needs.

Exclusively focused on the Government, Kearney & Company provides financial services, including auditing, consulting, and technology services. Our commitment to our employees and clients as well as to dedication and trust, critical values to our Firm, have led to Kearney's recognition as one of the leading accounting firms in the country. Based on our employees' feedback, we are also consistently rated a Best Place to Work. Employment at Kearney means a flexible, collaborative, and open-minded work environment. We hope it is your "first easy decision." Learn more at www.kearneyco.com/careers.

The expected salary range for this position is between $80,000 and $140,000. This range is representative of base pay only and does not include straight time pay for hours worked over 40 per week, company contributions towards paid benefits, and/or bonuses. Actual compensation (meeting or exceeding the range) will be determined based on specific experience, education, work location, clearance level, and other factors permitted by law. This position is eligible for bonuses (when applicable).

We also offer a competitive benefits package that includes:

• Medical, Dental, Vision, Life, AD&D, and Disability Insurance
• 401(k) Retirement Plan and 529 Education Savings Plan
• Flexible Spending & Health Savings Account
• Accident, Critical Illness, Hospital Indemnity Insurances
• Legal Insurance and Pet Insurance
• Employee Assistance Program, fitness and wellness benefits, and other firm benefits
• Paid holidays, vacation, and sick time

Applicants have rights under Federal Employment Laws

Work location is subject to change based on client requirements.
Kearney & Company is an Equal Opportunity Employer and will consider all qualified applicants without regard to race, color, creed, genetic information, religion, national origin, ethnicity, gender; gender identity, sexual orientation, pregnancy, childbirth or related medical condition, age, disability or handicap, servicemember status, relationship or association with a protected veteran, and any other category protected by Federal, state, or local law. Click here to learn more.

If you would like to request a reasonable accommodation, regarding accessibility of our website, a modification or adjustment of the job application or interview process due to a disability, please call 703-236-2391 or email accommodations@kearneyco.com. Please be advised that this contact information is for accommodation requests only and cannot be used to inquire about the status of an application.

Family and Medical Leave Act (FMLA)

FMLA is designed to help employees balance their work and family responsibilities by allowing them to take reasonable unpaid leave for certain family and medical reasons. Kearney & Company provides eligible employees with up to 12 weeks of unpaid, job-protected leave per year. Military family leave is available for up to 26 weeks under FMLA. Click here to learn more.

Employee Polygraph Protection Act (EPPA)

The EPPA prohibits most private employers from using lie detector tests either for pre-employment screening or during the course of employment. Kearney & Company adheres all provisions of the EPPA. Click here to learn more.