Location: Remote
Job Type: Full-Time
Target Salary Range*: $100,000 - $117,500
*This represents the potential salary range for this position depending on education level, years of experience and/or certifications in addition to other position specific requirements which may impact salary
Amatriot is seeking a Data Engineer to support the DHS Development, Engineering, and Enterprise Projects (DEEP) program.
The DHS DEEP program provides application analysis, architecture, engineering, development, testing, operations, maintenance, and modernization support across Microsoft 365, Azure, Power Platform, SharePoint, ServiceNow, Drupal, Atlassian, GitLab, data, analytics, security, and custom application technologies. The team uses DHS SELC and Agile delivery practices to support secure, accessible, and reliable enterprise applications.
The Data Engineer supports the development, deployment, and operation of enterprise data pipelines connecting Azure, Microsoft 365, and other enterprise data sources. This role focuses on ETL/ELT development, SQL optimization, data quality, secure data handling, pipeline monitoring, and delivery of reliable datasets to application and analytics teams.
Key ResponsibilitiesData Pipeline Development and Deployment- Build, test, deploy, and maintain ETL/ELT pipelines connecting Azure, Microsoft 365, and enterprise data sources.
- Develop data transformations supporting application, analytics, and reporting requirements.
- Optimize SQL queries, schemas, and pipeline performance.
- Apply version control and automated deployment practices to support repeatable data pipeline releases.
- Implement data quality checks and validation processes.
- Support secure access to enterprise datasets.
- Apply appropriate handling practices for sensitive data in accordance with DHS controls.
- Support reliable and compliant movement of data across enterprise environments.
- Partner with data architects, application teams, and Power BI developers.
- Deliver reliable datasets supporting enterprise applications, reporting, and analytics.
- Collaborate with Government and contractor stakeholders to understand data requirements and resolve data integration issues.
- Monitor data pipelines and identify operational issues.
- Troubleshoot pipeline failures and data-processing problems.
- Support performance optimization and operational reliability of ETL/ELT processes.
- Assist with remediation of data integration and pipeline issues.
- Maintain data mappings and operational documentation.
- Produce clear technical and program documentation.
- Participate in Agile delivery activities supporting the DHS DEEP program.
- Follow applicable DHS SELC and program delivery practices.
- Bachelor’s degree; or
- Six additional years of relevant professional experience in lieu of a degree. [Required]
- Minimum 5 years of directly relevant professional experience. [Required]
- Hands-on experience with SQL, scripting, Azure data services, and ETL/ELT pipeline development. [Required]
- Experience working in Agile delivery environments. [Required]
- Experience producing clear technical or program documentation. [Required]
- Strong SQL and data-processing skills. [Required]
- Experience developing and supporting ETL/ELT pipelines. [Required]
- Knowledge of Azure data services. [Required]
- Scripting experience supporting data engineering and automation activities. [Required]
- Strong written and verbal communication skills. [Required]
- Ability to collaborate effectively with Government and contractor stakeholders. [Required]
-
Ability to obtain and maintain a Public Trust or other required DHS suitability determination. [Required]
- U.S. Citizenship. [Required]
- Ability to successfully complete a government background investigation. [Required]
Similar Jobs
What you need to know about the Charlotte Tech Scene
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus



