Data Architect - Clearance Required

Job Locations US-IL-Scott AFB
Posted Date 2 months ago(5/3/2024 3:13 PM)
Job ID
# of Openings
Information Technology


LMI is seeking a Data Architect to perform information technology related requirements as part of an integrated team supporting for the Department of Defense, United States Transportation Command. The position requires proficiency in physical data modeling and any major BI Visualization tool. Work will be performed at Scott AFB, IL and in the vicinity of O’Fallon, IL.


At LMI, we’re reimagining the path from insight to outcome at The New Speed of Possible™. Combining a legacy of over 60 years of federal expertise with our innovation ecosystem, we minimize time to value and accelerate mission success. We energize the brightest minds with emerging technologies to inspire creative solutioning and push the boundaries of capability. LMI advances the pace of progress, enabling our customers to thrive while adapting to evolving mission needs. 


  • Designs and builds relational databases. Performs data access analysis design, and archive/recovery design and implementation
  • Develops strategies for data acquisitions, archive recovery, and implementation of a database
  • Works in a data warehouse environment, which includes data design, database architecture, and metadata repository creation
  • Translates business needs into long-term architecture solutions
  • Defines, designs, and builds dimensional databases
  • Develops data warehousing blueprints, evaluating hardware and software platforms, and integrating systems
  • Reviews and develops object and data models and the metadata repository to structure the data for better management and quicker access


  • Bachelor's in Computer Science, Information Systems, Engineering, Business, Social Science, or other related analytical, scientific, or technical disciplines or equivalent years of experience
  • 3-5 years experience building automated ETL data-pipelines, using:Python,Pandas, Dataframes, or Pyspark.
  • 3-5 years of SQL experience including: Data Definition Language (DDL) and/or Data Manipulation Language (DML).
  • 3-5 years of MS Excel experience
  • 3-5 years of experience deriving business use case requirements
  • 3-5 years of Business Intelligence and Visualization experience using tools such as: Qlik, Tableau, or PowerBI.
  • 3-5 years working in an Agile/Scrum environment
  • 3-5 years using MS Teams / SharePoint
  • Experience building physical data models/database design, preferred
  • Experience working with DoD preferred, but not necessary
  • Must possess an active SECRET US Government clearance


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, sexual orientation, gender identity, national origin, pregnancy, disability, age, protected veteran status, citizenship status, genetic information, or any other characteristic protected by applicable federal, state, or local law. If you are a person with a disability needing assistance with the application process, please contact accommodations@lmi.org

Need help finding the right job?

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