Enterprise Data Warehouse Administrator

Job Locations US-MD-Belcamp
Posted Date 4 months ago(4/3/2020 5:09 PM)
Job ID
# of Openings


LMI is a consulting firm dedicated to advancing the management of government. Our clients value our specialized services in logistics, management advisory services, advanced analytics, and digital services supporting the defense, national security and health markets. We believe government can make a difference, and we seek talented, hardworking people who share that conviction.  We offer competitive salary, a merit-based bonus structure, a generous retirement plan, an unlimited leave policy, a focus on continued development including a robust educational reimbursement program, flexible work schedules, and programs to support work-life balance.


The Enterprise Data Warehouse Administrator will work on a large project team supporting the Army Shared Services Center (Army SSC) organization located at Aberdeen Proving Ground, MD. The Army SSC provides capability support services to all Army Enterprise Resource Planning (ERP) logistics and financial systems. Capability support includes system sustainment, sustainment modernization, and enhancement activities such as system design, development, testing, and deployment. Specific tasks include functional analysis, help desk, cybersecurity, quality assurance, configuration management, database administration, portal and support tool management, SAP BASIS support, technical services, interface/middleware maintenance, and system monitoring.


The Enterprise Data Warehouse Administrator will assist the Army SSC in providing EDW related services including reporting within EDW and user generated queries. The reports and queries cover all aspects of the Army financial and logistic processes in LMP. The Enterprise Data Warehouse Administrator shall support the EDW Business Area with BI, Manufacturing Integration and Intelligence (MII), BObJ and Business Explorer (BeX) modules (Query Designer, Web Application Designer, Report Designer).


  • Current National Agency Check and Inquiries (NACI) or eligibility to obtain a NACI
  • 10 years of experience in BW & BO
  • Army project experience a plus
  • ECC experience in functional areas SCP, ACQ, PS
  • Strong BW Data modeling experience, ETL processing in SCP, ACQ, MAINT
  • Strong BW Data modeling experience to combine data from different DataMarts into one InfoProvider for reporting
  • Experience in ABAP in ECC/ BW to able to maintain various routines/user exits
  • Strong Experience to debug, troubleshoot issues & performance tuning with custom enhancements in BW, identifying & applying OSS notes, ETL network optimization
  • Extensive experience in Reporting using Business Objects tools: Web Intelligence, Crystal Reports, Dashboards, Analysis for Office using BICS
  • Extensive experience to merge fields from 2 queries in WebI
  • Extensive experience in creating Dashboards with data filters, importing/exporting excel, formatting, jumps to WebI
  • Experience with Crystal reports/Analysis for Office/Lumira
  • Experience in creating promotion jobs in CMC, schedule/maintain Business Objects reports through scheduler, use publications
  • Strong experience in Query Designer, Web Designer, Report Designer
  • Knowledge of HANA concepts
  • Integration experience with portal, training, BASIS and infrastructure teams desired
  • Understanding the business requirement and developing functional/technical specs
  • ECC 7.0, BW 7.3 & BO 4.0/4.1/4.2 experience must
  • Experience to independently work on end-to end Performance troubleshooting and tuning (Modeling/Reports)
  • 2 years of LMP experience in BW/BO
  • Data modeling experience in BW datamarts-Finance, Controlling & Project Systems
  • Experience in Query Designer, Web Application Designer, Report Designer in areas of Finance, Controlling & Project Systems
  • Experience in LMP lifecycle process to include development of CRD/CDD/QA Test Script/functional/technical specs etc.
  • Experience in LMP BW Network monitoring including daily/weekly/monthly/yearly jobs
  • Experience in working with other teams such as Solution Delivery on peer reviews, design reviews etc.

EEO Statement

LMI is an Equal Opportunity Employer-all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin. 


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

LMI is an Equal Opportunity Employer. LMI is committed to the fair treatment of all and to our policy of providing applicants and employees with equal employment opportunities. LMI recruits, hires, trains, and promotes people without regard to race, color, religion, sex (including pregnancy), sexual orientation, gender identity, age, national origin, disability, veteran status, or any other factors protected by applicable law.

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.