Data Engineer (UAP, EEB) at ECS
United States
$140k - $165k
<p><span>ECS is seeking a<strong><em> Data Engineer </em></strong>to work <em><strong>remotely</strong></em>. </span><strong><u><span>Please Note:</span></u></strong><strong><span> This position is contingent upon additional funding.</span></strong></p> <p> </p> <p><span>ECS is currently seeking a Data Engineer that develops, implements, and maintains architecture solutions across a large enterprise data warehouse to support effective and efficient data management and enterprise-wide business intelligence analytics.</span></p> <p><span><strong> </strong></span></p> <p><span><strong>Responsibilities: </strong></span></p> <ul> <li><span>Implement, and optimize data pipeline architectures for data sourcing, ingestion, transformation, and extraction processes, ensuring data integrity, consistency, and compliance with organizational standards.</span></li> <li><span>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.</span></li> <li><span>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.</span></li> <li><span>Establish and enforce data governance standards, including data quality metrics, validation rules, and best practices for data warehouse design, architecture, and tooling.</span></li> <li><span>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.</span></li> <li><span>Implement and tune data warehouse systems, focusing on query performance, batch processing efficiency, and resource management; utilize indexing, partitioning, and caching strategies.</span></li> <li><span>Perform advanced data analysis, validation, and profiling using SQL and scripting languages; develop data models, dashboards, and reports in collaboration with stakeholders.</span></li> <li><span>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.</span></li> <li><span>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.</span></li> </ul> <p><span>Salary Range: $140,000 - $165,000</span></p> <p><span><a href="https://ecstech.com/careers/benefits"><span>General Description of Benefits</span></a></span></p> <strong><span>Qualifications</span></strong> <ul> <li><span><em><strong><span>5-10+ years of experience</span></strong></em></span></li> <li><span><em><strong><span>US Citizen or Green Card holder and must be able to obtain a Public Trust clearance.</span></strong></em></span></li> <li><span>Detail oriented with strong analytical and problem-solving skills </span></li> <li><span>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. </span></li> <li><span>Skill using Unix/Linux shell scripting to develop and implement automation scripts for Extract, Transfer Load (ETL) processes.</span></li> <li><span>Communications skills (both verbal & written) - ability to work and communicate with all levels in team structure </span></li> <li><span>Team player with the ability to prioritize and multi-task, work in a fast-paced environment, and effectively manage time. </span></li> <li><span>Java/J2EE and REST APIs, Web Services and building event-driven Micro Services and Kafka streaming using Schema registry, OAuth authentication.</span></li> <li><span>Spring Framework and GCP Services in public cloud infrastructure, Git, CI/CD pipeline and containerization, data ingestion/data modeling</span></li> <li><span>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</span></li> </ul>
Apply Now
