The Amatriot Group Logo

The Amatriot Group

Data Engineer

Posted 2 Days Ago
Remote
Hiring Remotely in United States
100K-118K Annually
Senior level
Remote
Hiring Remotely in United States
100K-118K Annually
Senior level
Build and maintain ETL/ELT pipelines across Azure, Microsoft 365, and enterprise data sources. Develop transformations, optimize SQL and schemas, implement data quality and security controls, monitor pipeline operations, troubleshoot failures, and deliver reliable datasets with architects, application teams, and Power BI developers. Maintain data mappings and technical documentation while working in agile environments supporting DHS enterprise applications.
The summary above was generated by AI

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

Position Overview

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.
Data Quality and Security
  • 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.
Collaboration and Dataset Delivery
  • 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.
Pipeline Operations and Troubleshooting
  • 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.
Documentation and Agile Delivery
  • 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.
QualificationsEducation
  • Bachelor’s degree; or
  • Six additional years of relevant professional experience in lieu of a degree. [Required]
Experience
  • 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]
Skills
  • 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]
Clearance
  • Ability to obtain and maintain a Public Trust or other required DHS suitability determination. [Required]

Other Requirements
  • U.S. Citizenship. [Required]
  • Ability to successfully complete a government background investigation. [Required]

Similar Jobs

16 Hours Ago
Remote or Hybrid
CA, USA
123K-223K Annually
Senior level
123K-223K Annually
Senior level
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
Build and maintain sales compensation systems, data pipelines, integrations, data models, and commission calculation logic. Translate compensation plans into tested technical configurations, ensure reconciliation and historical traceability, and implement access controls, audit trails, monitoring, and release practices. Partner with Sales Compensation Operations, Finance, Payroll, and technical teams to deliver accurate, explainable commission results.
Top Skills: APIsCaptivateiqCloud Data WarehousesLookerExcelPigmentSalesforceSpiffSQLXactly
Yesterday
In-Office or Remote
CA, USA
123K-223K Annually
Senior level
123K-223K Annually
Senior level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Build and maintain the technical foundation for sales compensation, including commission systems, integrations, data pipelines, calculation logic, data models, testing, access controls, audit trails, reconciliation, and release practices. Partner with Sales Compensation Operations, Finance, Payroll, and technical teams to implement approved compensation plans and ensure accurate, explainable, reproducible commission results.
Top Skills: Access ControlsAPIsAudit TrailsAutomated TestingData ModelingData PipelinesExcelLookerPigmentSalesforceSQLVersion Control
2 Days Ago
Remote
US
106K-170K Annually
Junior
106K-170K Annually
Junior
Cloud • Fintech • Food • Information Technology • Software • Hospitality
Build and maintain scalable production data pipelines and cloud data infrastructure. Ensure data quality, observability, lineage, governance, and cost-efficient performance. Develop data platform tooling, semantic and metrics layers, and enterprise data models supporting analytics, reporting, AI applications, and operational decisions. Collaborate with Analytics, Engineering, Product, operations, and business stakeholders while contributing to architecture, code reviews, testing, and technical standards.
Top Skills: AirflowAWSAzureBigQueryClaudeDbtDelta LakeDockerGCPGithub CopilotJavaPythonRedshiftScalaSnowflakeSnowflake Cortex AiSQLTerraform

What you need to know about the Charlotte Tech Scene

Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.

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

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account