Mid-Level Data Engineer

Summary

ECS is seeking a Mid-Level Data Engineer to support a high-priority federal Data Analytics and Business Intelligence platform for the Department of Homeland Security. The role guides cross-functional teams, manages secure data processing and pipelines, deploys models, supports automation, and maintains data-related systems using agile methodologies.

Responsibilities

• Complete development efforts across data pipeline to store, manage, store, and provision to data consumers
• Partner with data scientists, data architects, and federal stakeholders to deploy models in production
• Write code to ensure the performance and reliability of data extraction and processing
• Support continuous process automation for data ingest
• Achieve technical excellence by advocating for and adhering to lean-agile engineering principles and practices such as API-first design, simple design, continuous integration, version control, and automated testing
• Work with program management and engineers to implement and document complex and evolving requirements
• Help cultivate an environment that promotes customer service excellence, innovation, collaboration, and teamwork
• Collaborate with others as part of a cross-functional team that includes user experience researchers and designers, product managers, engineers, and other functional specialists

Skills

• Must be a US Citizen
• Must be able to obtain Public Trust Clearance
• 7+ years of IT experience including experience in working with modern cloud data warehouse technologies
• Experience with designing table models
• Experience with ingesting data of various types into the Redshift data warehouse
• Proficiency in developing ETL processes, and performing test and validation steps
• Proficiency in manipulating data (Python, R, SQL, SAS)
• Strong knowledge of big data analysis and storage tools and technologies
• Strong understanding of the agile principles and ability to apply them
• Experience working inside the AWS ecosystem
• Experience with relational databases (e.g., PostgreSQL)
• Work comfortably in version control systems (e.g., Git)

Qualifications

Must Haves

• Must be a US Citizen
• Must be able to obtain Public Trust Clearance
• 7+ years of IT experience including experience in working with modern cloud data warehouse technologies
• Experience with designing table models
• Experience with ingesting data of various types into the Redshift data warehouse
• Proficiency in developing ETL processes, and performing test and validation steps
• Proficiency in manipulating data (Python, R, SQL, SAS)
• Strong knowledge of big data analysis and storage tools and technologies
• Strong understanding of the agile principles and ability to apply them
• Experience working inside the AWS ecosystem
• Experience with relational databases (e.g., PostgreSQL)
• Work comfortably in version control systems (e.g., Git)

Benefits

• Remote work