Be an early applicantLess than 25 applicants

Company

Kearney & Company · 1 day ago

Air Force DEAMS Data Modeler

United States

Full-time

Remote

Mid, Senior Level

$80K/yr - $140K/yr

5+ years exp

Maximize your interview chances

Business DevelopmentConsulting

Growth Opportunities

No H1B

U.S. Citizen Only

Security Clearance Required

Insider Connection @Kearney & Company

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

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

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data analysisOracle ERPPower BIAdvanaEnvisionDEAMS systemOracle e-Business SuiteOracle CloudAF Financial ManagementDepartment of Defense SFISUSSGLAir Force financial systemsAF Lines of AccountingLarge data modelsData extraction protocolsStandard Operating Procedures

Required

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

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