Job Description
Senior Data Engineer Modern Technology Solutions, Inc - 4.4 Alexandria, VA Job Details 4 hours ago Benefits Disability insurance Health insurance Tuition reimbursement Paid time off 401(k) 6% Match 401(k) matching Employee stock ownership plan Flexible schedule Life insurance Qualifications Commercial use (data warehousing systems) Cloud analytics services Cloud data warehouses Programming languages Bachelor's degree Full Job Description The Data Engineer will be writing code that moves data through a pipeline, fixing data pipeline issues, optimizing data systems, and collaborating with stakeholders, day to day. The Capital Software Project is building a data fabric system. The data fabric system includes a data pipeline that will be moving complex mix of data types and formats to a data lake and a series of databases. Allowing mission engineering analyst to conduct data analysis from authoritative sources of truth. The Data Engineer will be working with the Systems Engineering and DevSecOps teams to ensure that datasets are properly converted, transformed, routed and stored. Create ETL/ELT code to ingest, transform, and load data from a variety of sources into the data lake and scale. Primary data sources will be mission engineering data and physics-based simulation results. How you will contribute to our National Security and Defense mission: As a Data Engineer will be working with the Systems Engineering and DevSecOps teams to ensure that datasets are properly converted, transformed, routed and stored, as designed. You will also bring your experience in harvesting metadata from datasets. You'll bring your experience in multi-source and cross-domain data integration. Day-to-day, you will be blending your software engineering, data architecture, and operational monitoring skills to: Build and Maintain Data Pipelines to: Write or update ETL/ELT code that ingests data from APIs, databases, or files. Implement transformations to clean, standardize, or enrich data. Optimize pipeline performance and improve reliability. Hands-on experience with AI and ML pipelines, MLOps workflows, and data processing methodologies. Implement methods for data traceability and lineage. Monitor Pipelines and Data Quality to: Check automated alerts and logs for failed jobs or data anomalies. Troubleshoot issues such as schema changes, missing data, or performance bottlenecks. Validate data accuracy and consistency across systems. Leverage your expertise in semantic modeling Collaborate with Engineering Teams to: Meet with project teams to understand new data requirements. Work with backend engineers or DevSecOps to align pipeline changes with system updates. Support stakeholders by providing data extracts or explanations of data structure. Design and Improve Data Architecture Plan new data models or schemas for analytics or application use case. Incorporate metadata strategies tailored fit for the use case. Help shape the data warehouse/lake structure. Evaluate new tools or cloud services to improve scalability and maintainability. Write Code and Documentation Build reusable application containers in Python, SQL, or other languages used in the stack. Document pipeline logic, data contracts, and system diagrams. Participate in code reviews to ensure quality and best practices.
Work Location:
Due to the security classification for this project, work will be performed in-office, 5-days a week. You'll be a great fit for this role if: (SOFT SKILLS) You have a passion for technology. You bring a forward-looking mindset, anticipating needs and designing scalable, future-ready data structures. You approach complexity with innovation and drive, identify and resolve challenges quickly. You rigorously deliver high-quality, actionable solutions that enhance mission execution. You understand the Department of Defense reference and compliance architectures. You are passionate about continuous learning and growth, and seek opportunities to challenge yourself. You have excellent communication skills. Responsibilities:
Your job functions will include but may not be limited to: Develop and maintain ETL/ELT pipelines to ingest, transform, and load data from a variety of sources into our data warehouse or data lake. Design scalable and reliable data architectures, including schemas, workflows, and integration layers. Optimize data models, ensuring alignment with analytics and operational needs. Collaborate cross-functionally to understand data requirements and provide technical solutions. Monitor pipeline performance, troubleshoot data issues, and implement continuous improvements. Ensure data quality, integrity, and security throughout the entire data lifecycle. Automate data workflows using scripting, orchestration tools, and CI/CD practices. Maintain documentation related to data processes, standards, and best practices. Design scalable and reliable data architectures, including schemas, workflows, and integration layers. Conduct design reviews, validate solution architectures, and ensure alignment with enterprise standards. Bring Solid understanding of DoD frameworks, security requirements, and best practices for classified and unclassified environments. Qualifications Required:
7+ years of relative working experience as a Senior Data Engineer or in a related field. Strong experience with ETL/ELT development and building data pipelines. Proficiency with at least one major programming language (e.g., Python, Java, Scala). Experience working with SQL and relational databases (e.g., PostgreSQL, SQL
Server, MySQL). Exposure and familiarity with data services on modern cloud platforms (AWS, Azure, GCP, etc.). Familiarity with modern data warehousing technologies (e.g., ADLS, Redshift, BigQuery, Synapse). Education:
Bachelor's degree Computer Science, Software Engineering, or a related field. Clearance Requirements:
Must have a Secret DoD Security Clearance. #LI-MS1 #LI-Onsite #MTSI Secret Perks and Benefits Vacation:
New Hires Accrue 20 days of PTO and 10 Holidays per Year Health Insurance:
Zero Deductible Health Plans Flexible Schedules:
Flex Schedules Professional Development:
Up to $10,000 Annual Education/Training Reimbursement ESOP:
Funded Stock Ownership Plan 401k Match+: 6% 401k Match + Immediate Vesting Bonus Program:
Semi-Annual Bonus Opportunity Mentorship:
Career Mentorship Programs Why is MTSI a great place to work Interesting Work:
Our co-workers support some of the most important and critical programs to our national defense and security. Values:
Our first core value is that employees come first. We challenge our co-workers to provide the highest level of support and service, and reward them with some of the best benefits in the industry. 100% Employee Owned:
We have a stake in each other's success, and the success of our customers. It's also nice to know what's going on across the company; we have company wide town-hall meetings three times a year. Great Benefits - Most Full-Time Staff Are Eligible for: Starting PTO accrual of 20 days PTO/year + 10 holidays/year Flexible schedules 6% 401k match with immediate vesting up to $9k annually Semi-annual bonus eligibility (July and Decemeber) Company funded Employee Stock Ownership Plan (ESOP) - a separate qualified retirement account Up to $10,000 in annual educational reimbursement Other company funded benefits, like life and disability insurance Optional zero deductible Blue Cross/Blue Shield health insurance plan Track Record of Success:
We have grown every year since our founding in 1993. Modern Technology Solutions, Inc. (MTSI) is a 100% employee-owned engineering services and solutions company that provides high-demand technical expertise in Digital Transformation, Modeling and Simulation, Rapid Capability Development, Test and Evaluation, Artificial Intelligence, Autonomy, Cybersecurity and Mission Assurance MTSI delivers capabilities to solve problems of global importance. Founded in 1993, MTSI today has employees at over 20 offices and field sites worldwide. For more information about MTSI, please visitwww.mtsi-va.com EEO Statement MTSI embraces nine core values including our first core value of Employees come first. Consistent with our Core Values, we are committed to Equal Opportunity, making decisions without regard to race, color, religion, sex, national origin, age, military/veteran status, disability, or any other characteristics protected by applicable law. MTSI is committed to Equal Employment Opportunity and providing reasonable accommodations to applicants and employees with physical and/or mental disabilities. Why is MTSI a great place to work Interesting Work:
Our co-workers support some of the most important and critical programs to our national defense and security. Values:
Our first core value is that employees come first. We challenge our co-workers to provide the highest level of support and service, and reward them with some of the best benefits in the industry. 100% Employee Owned:
We have a stake in each other's success, and the success of our customers. It's also nice to know what's going on across the company; we have company wide town-hall meetings three times a year. Great Benefits - Most Full-Time Staff Are Eligible for: Starting PTO accrual of 20 days PTO/year + 10 holidays/year Flexible schedules 6% 401k match with immediate vesting up to $9k annually Semi-annual bonus eligibility (July and Decemeber) Company funded Employee Stock Ownership Plan (ESOP) - a separate qualified retirement account Up to $10,000 in annual educational reimbursement Other company funded benefits, like life and disability insurance Optional zero deductible Blue Cross/Blue Shield health insurance plan Track Record of Success:
We have grown every year since our founding in 1993. Modern Technology Solutions, Inc. (MTSI) is a 100% employee-owned engineering services and solutions company that provides high-demand technical expertise in Digital Transformation, Modeling and Simulation, Rapid Capability Development, Test and Evaluation, Artificial Intelligence, Autonomy, Cybersecurity and Mission Assurance MTSI delivers capabilities to solve problems of global importance. Founded in 1993, MTSI today has employees at over 20 offices and field sites worldwide. For more information about MTSI, please visit www.mtsi-va.com
