ECS · 10 hours ago
Data Engineer (UAP, EEB)
United States
Full-time
Remote
Senior Level
$140K/yr - $165K/yr
5+ years expECS is a leading mid-sized provider of technology services to the United States Federal Government. They are seeking a Data Engineer to develop, implement, and maintain architecture solutions across a large enterprise data warehouse to support effective data management and business intelligence analytics.
Artificial Intelligence (AI)Cloud ComputingCyber SecurityLegalConsultingSoftwareInformation TechnologyCloud InfrastructureComplianceMachine LearningSecurity
No H1B
Security Clearance RequiredU.S. Citizen Only
Responsibilities
Implement, and optimize data pipeline architectures for data sourcing, ingestion, transformation, and extraction processes, ensuring data integrity, consistency, and compliance with organizational standards
Develop and maintain scalable database schemas, data models, and data warehouse structures; perform data mapping, schema evolution, and integration between source systems, staging areas, and data marts
Automate data extraction workflows and develop comprehensive technical documentation for ETL/ELT procedures; collaborate with cross-functional teams to translate business requirements into technical specifications and data schemas
Establish and enforce data governance standards, including data quality metrics, validation rules, and best practices for data warehouse design, architecture, and tooling
Develop, test, and deploy ETL/ELT scripts and programs using SQL, Python, Spark, or other relevant languages; optimize code for performance, scalability, and resource utilization
Implement and tune data warehouse systems, focusing on query performance, batch processing efficiency, and resource management; utilize indexing, partitioning, and caching strategies
Perform advanced data analysis, validation, and profiling using SQL and scripting languages; develop data models, dashboards, and reports in collaboration with stakeholders
Conduct testing and validation of ETL workflows to ensure data loads meet scheduled SLAs and business quality standards; document testing protocols, results, and remediation steps
Perform root cause analysis for data processing failures, troubleshoot production issues, and implement corrective actions; validate data accuracy and consistency across systems; support iterative development and continuous improvement of data pipelines
Qualification
Required
5-10+ years of experience
US Citizen or Green Card holder and must be able to obtain a Public Trust clearance
Detail oriented with strong analytical and problem-solving skills
Ability to use database tools, techniques, and applications (e.g., Teradata, Oracle, Non-Relational) to develop complex SQL statements (e.g., multi-join), and to tune and troubleshoot queries for optimal performance
Skill using Unix/Linux shell scripting to develop and implement automation scripts for Extract, Transfer Load (ETL) processes
Communications skills (both verbal & written) - ability to work and communicate with all levels in team structure
Team player with the ability to prioritize and multi-task, work in a fast-paced environment, and effectively manage time
Java/J2EE and REST APIs, Web Services and building event-driven Micro Services and Kafka streaming using Schema registry, OAuth authentication
Spring Framework and GCP Services in public cloud infrastructure, Git, CI/CD pipeline and containerization, data ingestion/data modeling
Develop Microservices using Java/J2EE Spring for ingesting large volume real-time events into Kafka topics. Architect solutions that make the data available to consumers in real time
Preferred
Familiarity with Databricks concepts and terminology, such as workspace, catalog
Python, Spark
Company
ECS
ECS is a fast-growing 4,000-person, $1.2B provider of advanced technology solutions for federal civilian, defense, intelligence, and commercial customers.
1001-5000 employees
Funding
Current Stage
Late StageTotal Funding
unknown2018-01-31Acquired
2015-04-10Private Equity
Leadership Team
Keith McCloskey
VP / Chief Technology Officer
Ryan Garner
Chief Financial Officer
Recent News
Business Wire
2026-01-22
2025-11-19
2025-03-26
Company data provided by crunchbase