Data Engineer

Overview

LMI is seeking a Data Engineer to be part of a team that is designing and developing complex, enterprise level information systems.

LMI is a consultancy dedicated to powering a future-ready, high-performing government, drawing from expertise in digital and analytic solutions, logistics, and management advisory services. We deliver integrated capabilities that incorporate emerging technologies and are tailored to customers’ unique mission needs, backed by objective research and data analysis. Founded in 1961 to help the Department of Defense resolve complex logistics management challenges, LMI continues to enable growth and transformation, enhance operational readiness and resiliency, and ensure mission success for federal civilian and defense agencies.

LMI has been named a 2022 #TopWorkplace in the United States by Top Workplaces! We are honored to be recognized as a company that values a people-centered culture, and we are grateful to our employees for making this possible!

Responsibilities

• Supports data architecture for large-scale APIs and web application back-end data stores.  
• Implements ETL processes to supply application data for usage in the web application.  
• Manages critical low latency application databases on platforms. Develops packages and scripts for system enhancements and interfaces.  
• Develops scripts to validate the various data on systems.  
• Writes queries to improve the database performance and availability.  
• Executes statement to create and update various tables and views utilize for testing of code on a database. 
• Establishes database backup/recovery strategy using user-manage backup.  
• Engineers database solutions and interfaces enabling performance of data requests.  
• Develops reusable components for deployment in a traditional data warehouse environment. 
• Standardizes database maintenance activities by standardizing directory structure and documentation of DBA activities. 
• Establishes backup and recovery options and implements automation of many DBA utility functions.  
• Documents database design, data definition language, and define data migration strategy between different products/versions and develop data migration procedures.  

Qualifications

Required: 

• Bachelor’s degree in industrial engineering, operations research, statistics, mathematics, computer science, or related field 

• 3+ year(s) of experience 

• Strong analytical skills 

• Proficiency in Microsoft Office programs including Word, Excel, PowerPoint. 

• Proficiency in Python or PowerBI 

• Superior communication skills, both written and oral.

• Ability to absorb large amounts of new technical and policy knowledge without a lot of guidance.

Desired: 

• Master’s degree in industrial engineering, operations research, statistics, mathematics, computer science, data science or related discipline.

• Expert knowledge of Excel – VBA, Python, Tableau, PowerBI, SQL, and/or SAS 

• Understanding of federal healthcare programs. 

• 3-5 years of experience in data analysis and reporting.

Percentage of Travel Required: 10%