Data Engineer
Remote, United States
Logistics Management Institute
With a legacy of solving the government’s most complex challenges and an outcome-driven model to execute above expectation, LMI transforms missions with solutions that define the new speed of possible.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.
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
- Confidential/NAC
- Bachelor’s degree in related technical discipline
- Minimum 5 years of hands-on experience in in database management operations
- Experience with cloud database development and implementation (AWS preferred).
- Understanding of data migration procedures for backup and restore as well as schema migration for existing data holdings.
- Demonstrated experience with ETL pipeline design and implementation.
- Strong and robust understanding of SQL (MariaDB/MySQL, Postgres, MS SQL, or Oracle).
- Demonstrated experience implementing ETL pipelines within and without the use of 3rd party vendor solutions.
- Demonstrated experience documenting database architecture and diagrams.
Desired
- Experience with storage on cloud for containerized applications.
- Experience with NoSQL (Cassandra, HBase, MongoDB, etc.).
- Experience with index-based datastores
Percentage of Travel Required: 5%
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Architecture AWS Cassandra Data analysis Data warehouse ETL HBase MariaDB MongoDB MS SQL MySQL NoSQL Oracle Pipelines PostgreSQL Research SQL Testing
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Research Scientist jobs
- Open Data Science Manager jobs
- Open Data Engineer II jobs
- Open Principal Data Scientist jobs
- Open Business Data Analyst jobs
- Open Data Scientist II jobs
- Open BI Analyst jobs
- Open Sr Data Engineer jobs
- Open Business Intelligence Engineer jobs
- Open Lead Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Data Science Intern jobs
- Open Software Engineer, Machine Learning jobs
- Open Senior Business Intelligence Analyst jobs
- Open Junior Data Scientist jobs
- Open MLOps Engineer jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Analytics Engineer jobs
- Open Marketing Data Analyst jobs
- Open Data Engineer III jobs
- Open Junior Data Engineer jobs
- Open Data Analyst II jobs
- Open Data Engineering Manager jobs
- Open ETL Developer jobs
- Open Data quality-related jobs
- Open Tableau-related jobs
- Open Privacy-related jobs
- Open Excel-related jobs
- Open ML models-related jobs
- Open Data pipelines-related jobs
- Open APIs-related jobs
- Open PhD-related jobs
- Open PyTorch-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open LLMs-related jobs
- Open Consulting-related jobs
- Open TensorFlow-related jobs
- Open Deep Learning-related jobs
- Open Business Intelligence-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open DevOps-related jobs
- Open Kubernetes-related jobs
- Open Git-related jobs
- Open Hadoop-related jobs
- Open Docker-related jobs