Everforth ECS is seeking a highly skilled Senior Data Engineer with extensive experience designing, building, and maintaining data platforms and pipelines for large-scale, enterprise applications in support of the Department of Homeland Security. Tools necessary for excelling in this role include SQL (PostgreSQL or MySQL preferred), Elasticsearch/OpenSearch, data modeling and transformation frameworks, and DevSecOps practices in the Cloud.
This role will focus heavily on modernizing legacy data architectures and re-architecting the application’s data layer, shifting from Elasticsearch to PostgreSQL or MariaDB as the system of record for transactional data. You will play a critical role in evolving scoring models, intelligence modifiers, and capability gap logic while ensuring alignment and consistency between the new relational database and Elasticsearch.
Key Responsibilities:
- Design and architect robust, scalable data models, schemas, indexes, and stored procedures in a relational database to support transactional workloads and complex business logic.
- Lead the migration of the system of record from Elasticsearch to a relational database, including data modeling, transformation, validation, and cutover strategies.
- Develop and maintain data pipelines and integration processes to keep the database and Elasticsearch aligned for search and analytics use cases.
- Implement and evolve scoring models, intelligence modifiers, and capability gap logic in the data layer to support mission-critical decision support.
- Optimize database performance, including indexing strategies, query tuning, and partitioning to support high-volume, low-latency operations.
- Define and enforce data quality, data validation, and data governance standards across legacy and modernized components.
- Collaborate with application engineers to integrate APIs and services with the underlying data models and stored procedures, ensuring seamless functionality and consistent data semantics.
- Provide technical guidance and solutions for legacy data system modernization while minimizing downtime and operational risk during migration.
- Identify and remediate data-related technical debt in older systems while transitioning to modern data engineering patterns, tools, and frameworks.
- Integrate and operate CI/CD pipelines used for building, testing, and deploying data services and schema changes in cloud environments.
- Ability to pass a Public Trust investigation.
- Must have US citizenship.
- Bachelor’s degree in a related field.
- Minimum 15 years general work experience.
- 8+ years of experience as a Data Engineer or in a closely related role, with strong experience in legacy data system modernization.
- 5+ years of hands-on experience with relational databases including from-scratch schema design, index creation, stored procedures SQL development, performance tuning, and transaction management.
- 3+ years of experience working with Elasticsearch or OpenSearch, including index design, mappings, and data ingestion strategies.
- Demonstrated experience designing and implementing data models and logic to support scoring models, rules engines, or similar decision-support systems.
- 5+ years of experience supporting applications in production, troubleshooting complex data issues in legacy environments, and proposing effective remediation strategies.
- Strong understanding of data modeling for OLTP/transactional systems, including normalization/denormalization tradeoffs and referential integrity.
- Solid understanding of Git, version control workflows, and collaborative development practices.
Skills Required
- 15 years general work experience
- 8+ years as a Data Engineer or related role
- 5+ years of experience with relational databases
- 3+ years with Elasticsearch or OpenSearch
- Bachelor's degree in a related field
- Ability to pass a Public Trust investigation
- US citizenship
ECS Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about ECS and has not been reviewed or approved by ECS.
-
Healthcare Strength — ECS advertises multiple national-network medical plan options with HSA eligibility alongside dental and vision coverage. Coverage generally begins quickly and is paired with company-paid short- and long-term disability, adding stability to the health package.
-
Retirement Support — A 401(k) with Safe Harbor and immediate vesting on employer contributions is emphasized, with an employer match available. Access to an employee stock purchase plan via the parent company provides an additional savings avenue.
-
Parental & Family Support — Paid parental leave up to 30 days, adoption assistance, and other family-oriented leaves are highlighted. Feedback suggests these offerings add meaningful value beyond base pay for many roles.
ECS Insights
What We Do
ECS, a segment of ASGN (NYSE: ASGN), delivers advanced solutions and services in cloud, cybersecurity, artificial intelligence (AI), machine learning (ML), application and IT modernization, and science and engineering. The company solves critical, complex challenges for customers across the U.S. public sector, defense, intelligence and commercial industries. ECS maintains partnerships with leading cloud, cybersecurity, and AI/ML providers and holds specialized certifications in their technologies. Headquartered in Fairfax, Virginia, ECS has more than 3,400 employees throughout the U.S. and has been recognized as a Top Workplace by The Washington Post for the last five years.
