DEAMS Database Architect

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 a robust background in developing and implementing solutions to fully leverage the computational benefits of a Cloud environment. The successful candidate should have experience with a wide range of software development tools and programming languages to enable development across multiple layers of the Cloud architecture. The candidate should have solid functional end-to-end AF Financial Management experience, while experience with the Palantir Cloud Foundry platform is preferred. The candidate will interact with the DEAMS FMO and auditors in support of the interface reconciliation of DEAMS. The candidate will interact with Advana and FASTR developers to implement DEAMS data solutions.

Other responsibilities may include:

• Developing strategies to properly ingest DEAMS financial data into the cloud enclaves receiving direct DEAMS connections
• Build solutions within the cloud technology stacks
• Optimize the technology stack to process the raw DEAMS data into actionable financial records within the Advana reporting tools
• Identifying anomalies within the DEAMS to cloud implementation and recommend corrective (preventative) actions
• Incorporating audit-based requirements to fully answer Notification of Findings and Recommendations (NFR) requirements
• Minimizing cloud compute time by balancing the scheduled complex calculations with the required processing capacity for the calculations
• Ability to understand issue and analyze root cause through direct customer interaction; brings expertise to resolve complex issues and communicates with clients effectively in order to resolve customer issues
• Delivering accurate and complete reports of DEAMS data within the cloud environment
• Documenting Standard Operating Procedures (SOP)
• Providing analysis and problem resolution for fixes to reported problems
• Participating in process improvement workshops identifying gaps, and providing solutions to bridge gaps and enhance processes

• Minimum 5 years of technical experience
• Experience developing large data models
• Experience delivering solutions in cloud technology stacks
• Experience with Advana, Envision, or other cloud software enclaves
• Knowledge of DEAMS system, SQL, and Oracle
• 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)
• Knowledge of Air Force financial systems such as:
  • Automated Funds Management (AFM)
  • Defense Enterprise Accounting Management System (DEAMS)
  • Financial Management Suite (FMSuite)
  • General Accounting and Finance System Base Level (GAFS-BL)
  • General Accounting and Finance System Re-Engineered (GAFS-R)
• 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:
  • Automated Disbursing System (ADS)
  • Air Force Equipment Management System (AFEMS)
  • Central Disbursing System (CDS)
  • Civilian Pay Accounting Interface System (CPAIS)
  • Central Procurement Accounting System (CPAS)
  • Commanders' Resource Integration System (CRIS)
  • Defense Cash Accountability System (DCAS)
  • Defense Cash Management System (DCMS)
  • Defense Civilian Payroll System (DCPS)
  • Defense Departmental Reporting System (DDRS)
  • Deployable Disbursing System (DDS)
  • Defense Transaction Interface Module (DTIM)
  • Integrated Accounts Payable System (IAPS)
  • Job Order Cost Accounting System II (JOCAS II)
  • Procurement Integrated Enterprise Environment (PIEE)
  • Reserve Travel System (RTS)
  • Standard Base Supply System (SBSS)
  • Standard Materiel Accounting System (SMAS)
  • Wide Area Work Flow (WAWF)
  • Detailed familiarity with AF Lines of Accounting and financial data elements

KCO1701

#LI-MA1

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, national origin, ethnicity, ancestry, genetic information, religion, sex, gender, gender identity, sexual orientation, marital status, pregnancy, childbirth, any medical condition related to pregnancy or childbirth, age, disability, protected veteran status, relationship or association to a protected veteran, or any other characteristic protected by local, state or federal laws, rules or regulation. Click here for more information on Kearney's EEO Policy.

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.