MITRE · 22 hours ago
Lead Data Design and Test Engineer
Bedford, MA
Full-time
Hybrid
Lead/Staff
$155K/yr - $233K/yr
8+ years expMITRE is a not-for-profit corporation dedicated to tackling the nation's toughest challenges. The Lead Data Design and Test Engineer will focus on designing efficient data models and schemas for the AWS Cloud Data Warehouse team while ensuring data correctness and validation to maintain quality and reliability.
Quantum ComputingCyber SecurityNon ProfitSaaSInformation Technology
Responsibilities
Collaborate with business and technical teams to translate requirements into efficient data models and schemas optimized for AWS CDW
Design and implement data architecture solutions, ensuring scalability, performance, and security
Develop data integration frameworks that support seamless ingestion, transformation, and consumption of structured and semi-structured data
Establish and enforce best practices for schema management, including versioning, indexing, and partitioning strategies
Work with teams to improve data accessibility and usability, ensuring models are optimized for analytics, reporting, and operational use cases
Maintain technical documentation, including data dictionaries, schema diagrams, and modeling standards to ensure consistency and clarity
Define data validation rules that help maintain consistency and accuracy across ingestion and transformation processes
Develop lightweight automated validation scripts that support early detection of data quality issues while integrating with development workflows
Write targeted test cases for critical data components, ensuring they can be integrated into CI/CD pipelines for ongoing validation
Conduct selective data audits and quality checks, ensuring schema changes and transformations do not introduce inconsistencies
Work closely with engineering teams to ensure data pipelines are designed with built-in validation mechanisms, minimizing rework and downstream issues
Qualification
Required
Minimum Experience: 8 years in Enterprise Data Warehouse technology, including data modeling, schema design, and testing
Bachelor's degree with eight years' related experience, or a master's degree with six years' related preferably with a technical major such as engineering, computer science, etc
Data Modeling Expertise: Strong experience in designing and managing relational database schemas and access, with SQL and PL/SQL proficiency
Testing Skills: Experience in ETL/ELT testing, data validation, and data quality assurance, including Python for automation and testing
AWS Knowledge: Familiarity with AWS CDW services (e.g., Redshift, Glue, EMR) and best practices for cloud data storage and integration
This position requires a minimum of 60% hybrid on-site
Preferred
Cloud Data Architecture Knowledge: Familiarity with cloud architecture principles, especially in AWS, with understanding of how to design scalable, cost-efficient, and secure data models
Performance Optimization: Proven skills in tuning SQL queries, database indexing, and caching mechanisms to optimize data retrieval and improve model performance
Documentation and Technical Writing: Strong documentation skills for creating clear, user-friendly technical documents, including test case repositories, design specs, and troubleshooting guides
Project Management Skills: Familiarity with project management tools (e.g., Jira, Asana) and methodologies, enabling effective prioritization, tracking, and reporting on testing and design tasks
Interpersonal Skills: Proven ability to collaborate effectively and actively participate in cross-training and team knowledge transfer
Company
MITRE
MITRE is a not-for-profit organization that operates research and development centers.
5001-10000 employees
Funding
Current Stage
Late StageTotal Funding
$2.05MKey Investors
US Department of EnergyMassachusetts Technology Collaborative
2023-07-27Grant
2023-06-08Grant· $2.05M
Leadership Team
Katie Schroth
Air & Space Forces Center Vice President
Kerry Buckley
Vice President
Recent News
thefastmode.com
2025-10-31
2025-10-29
2025-10-09
Company data provided by crunchbase