Data Warehouse Analyst, Staff

Lockheed Martin•Baltimore, MD

1d•$95,000 - $189,290•Hybrid

About The Position

Position is a staff member of the LMCPI/REM/Lease Administration Organization serving as a key member supporting all things related to real estate compliance. Primary responsibilities include: Maintaining Portfolio Hierarchy in LMBuildings (Geography, Locations, Organizations, External Companies and Contacts). Generates frequency and ad-hoc reports related to the Annual 10K Report and Proxy Statement, CMS 950 Lease Accounting Review. Updates Future Events and other Real Estate Dashboards using Tableau and LMB system generated reports Manages SOX Key Controls related to Lease Administration Supports internal REM/Lease Admin team and cross functional teams such as SALT, Corporate Accounting, Business Area Real Estate requests. Position will work directly with Lease Admin Sr. Manager and REM Module Lead on all REM related Change Requests/Issues (CRIs) to ensure system functionality and REM priorities are being achieved. May be asked to initiate CRI and perform testing in lower environments to ensure authorized requirement is ready before promoting to the production environment. Performs other related tasks as assigned such as special projects and leadership request.

Requirements

Proficient in MS Excel: Formula & Function, Data Analysis & Modeling, Automation & Efficiency, Reporting & Visualization
Prior experience in converting manual processes into digital/electronic processes.
Effective communication skills (verbal and written).
Demonstrated problem solving abilities: define, analyze, generate solutions, monitor results
Documents Processes and Procedures including writing documented scripts/guides for others to utilize as needed
Forward thinking abilities, takes initiative, works independently without waiting for specific instructions.

Nice To Haves

Familiarity with Lockheed Martin CMS-950 Accounting for Leases.
Experience and knowledge of Real Estate processes and procedures
Product knowledge of tools such as: Tririga/LMBuildings; Tableau software
Familiarity with SAP/S4HANA applications
Knowledge of Operating Expense Reconciliation analysis

Responsibilities

Maintaining Portfolio Hierarchy in LMBuildings (Geography, Locations, Organizations, External Companies and Contacts).
Generates frequency and ad-hoc reports related to the Annual 10K Report and Proxy Statement, CMS 950 Lease Accounting Review.
Updates Future Events and other Real Estate Dashboards using Tableau and LMB system generated reports
Manages SOX Key Controls related to Lease Administration
Supports internal REM/Lease Admin team and cross functional teams such as SALT, Corporate Accounting, Business Area Real Estate requests.
Works directly with Lease Admin Sr. Manager and REM Module Lead on all REM related Change Requests/Issues (CRIs) to ensure system functionality and REM priorities are being achieved.
May be asked to initiate CRI and perform testing in lower environments to ensure authorized requirement is ready before promoting to the production environment.
Performs other related tasks as assigned such as special projects and leadership request.