The Amatriot Group Logo

The Amatriot Group

Data Engineer

Posted 3 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

Yesterday
In-Office or Remote
92K-164K Annually
Senior level
92K-164K Annually
Senior level
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Lead migration of on-premises ETL and database workloads to Azure and Snowflake. Design scalable data platforms using ADF, Databricks, ADLS, Logic Apps, and Python; modernize SSIS and T-SQL solutions; and develop AI-powered applications using LLMs, semantic search, vector databases, and RAG architectures. Collaborate independently across teams, optimize data operations, and support governance, quality, and advanced analytics initiatives.
Top Skills: Anthropic ClaudeAWSAzure Ai SearchAzure Ai StudioAzure Blob StorageAzure CloudAzure Data FactoryAzure Data Lake Storage Gen2Azure Machine LearningAzure OpenaiDatabricksDocument IntelligenceGoogle Cloud PlatformLarge Language ModelsLogic AppsMlflowMlopsOpenaiPrompt EngineeringPythonRetrieval-Augmented GenerationSelf-Hosted Integration RuntimeSemantic SearchSnowflakeSparkSsisT-SqlVector Databases
Yesterday
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
2 Days Ago
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

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account