Data Engineer

Data Engineer Job Location: US-VA-Tysons Overview LMI is seeking a skilled and detail-oriented Data Engineer to join a high‑performing team supporting a government healthcare client. In this role, you will design scalable data solutions and extract, transform, load (ETL) processes, manage critical application databases, and collaborate with cross‑functional teams to implement best practices for data integrity, availability, and performance. LMI is a new breed of digital solutions provider dedicated to accelerating government impact with innovation and speed. Investing in technology and prototypes ahead of need, LMI brings commercial‑grade platforms and mission‑ready AI to federal agencies at commercial speed. Leveraging our mission‑ready technology and solutions, proven expertise in federal deployment, and strategic relationships, we enhance outcomes for the government, efficiently and effectively. With a focus on agility and collaboration, LMI serves the defense, space, healthcare, and energy sectors—helping agencies navigate complexity and outpace change. Headquartered in Tysons, Virginia, LMI is committed to delivering impactful results that strengthen missions and drive lasting value. Responsibilities Supports data architecture for large‑scale application programming interfaces (APIs) and web application back‑end data stores (e.g., SQL Server, MongoDB, or PostgreSQL). Designs, builds, and maintains PySpark ETL processes to supply application data for usage in the web application via Amazon Web Services (AWS) Glue. 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. Develops and optimizes SQL queries, stored procedures, and indexing strategies to improve database performance and availability. Implements medallion architecture and data lake best practices within AWS cloud ecosystems. Executes statements to create and update various tables and views utilized for testing of code on a database. Establishes database backup/recovery strategy using user‑managed backup and implements automation of many database administrator (DBA) utility functions. Engineers database solutions that ensure data request performance, reliability, and integrity for business‑critical systems. Develops reusable components for deployment in a traditional data warehouse environment. Standardizes database maintenance activities by standardizing directory structure and documentation of DBA activities. Documents database design, data definition language, data migration strategies between different products/versions, and overall architecture to ensure system transparency and auditability. Collaborates with software engineering and data science teams to improve platform performance, scalability, and availability. Utilizes AI‑powered development tools (e.g., code autocompletion, debugging assistants, automated testing frameworks) to enhance coding efficiency, ensure accuracy, and accelerate the software development lifecycle. Qualifications Required: Bachelor's degree in industrial engineering, operations research, statistics, mathematics, computer science, or related field. 3+ years of experience. Strong analytical skills. Proficiency in Microsoft Office programs including Word, Excel, PowerPoint. Proficiency in Python and SQL. Experience with entity relationship diagrams (ERDs). Experience creating or working with data cleansing pipelines. 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 Python and/or SQL. Proficiency in noSQL. Understanding of federal healthcare programs. Experience working in a consultant/client environment. Experience with medallion architecture. 3-5 years of experience in data analysis and reporting. Target Salary Range: $92,000 - $158,000 The salary range displayed represents the typical salary range for this position and is not a guarantee of compensation. Individual salaries are determined by various factors including, but not limited to location, internal equity, business considerations, client contract requirements, and candidate qualifications, such as education, experience, skills, and security clearances. Equal Opportunity Employer 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 View email address on click.appcast.io. #J-18808-Ljbffr