T

Trilogy Federal

Provides SDVOSB federal financial management consulting

Data Engineer

Data EngineeringPosted on Nov 13
Full-timeArlington County, Arlington, VA, USA$95k - $110k /yr

About the Job

Requirements

  • A bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related technical discipline, or an equivalent combination of education and relevant professional experience is required.
  • Seven or more years of professional experience in data engineering, data integration, or enterprise data platform development are required.
  • Hands-on experience with Azure Data Factory, Azure Databricks, and Apache Kafka is required.
  • Strong proficiency in Structured Query Language (SQL) and Python for data processing, transformation, and pipeline development is required.
  • Experience designing and maintaining Extract, Transform, and Load (ETL) and Extract, Load, and Transform (ELT) pipelines is required.
  • Experience with cloud-based lakehouse architectures, distributed data processing, and data modeling is required.
  • Experience implementing automated data quality checks, pipeline monitoring, error handling, and performance optimization is required.
  • Experience integrating data governance requirements into engineering workflows, including metadata management, data lineage, and policy-based data access controls, is required.
  • Familiarity with source control, automated testing, and Continuous Integration and Continuous Delivery (CI/CD) practices is required.
  • Ability to meet VA personnel vetting, background investigation, and system access requirements is required.
  • Ability to travel for 1–2 domestic business trips per year is required.

Responsibilities

  • Design, develop, and maintain scalable data ingestion and processing pipelines using Azure Data Factory (ADF), Azure Databricks, Apache Kafka, and related cloud technologies.
  • Engineer and optimize data lakehouse solutions, including Delta Lake architectures, semantic models, conformed dimensions, and partitioning strategies that support enterprise analytics and artificial intelligence and machine learning (AI/ML) workloads.
  • Integrate data from enterprise systems, legacy platforms, and cloud-based sources using batch, streaming, and event-driven ingestion patterns.
  • Implement automated data validation, reconciliation, and monitoring to ensure data accuracy, completeness, consistency, and freshness.
  • Support migration of data pipelines and analytical workloads to Summit, validate parity with source systems, and ensure production readiness.
  • Optimize data processing performance, resource utilization, and cloud costs through workload tuning and efficient data architecture.
  • Collaborate with data governance specialists to ensure ingested datasets are documented in the Enterprise Data Catalog (EDC), including required metadata, data definitions, and end-to-end lineage.
  • Implement Government-approved data governance requirements within engineering solutions, including access controls, data quality standards, and dataset publication criteria.
  • Develop and maintain technical documentation, including pipeline specifications, architecture decisions, operational procedures, and troubleshooting guidance.
  • Monitor production pipelines, investigate failures and performance issues, and implement corrective actions to maintain reliable data services.

Desired Qualifications

  • Experience supporting VA or other federal agency data modernization initiatives is preferred.
  • Experience working within Microsoft Azure Government cloud environments is preferred.
  • Experience with Azure Synapse Analytics, dedicated SQL pools, or comparable enterprise data warehouse technologies is preferred.
  • Familiarity with federated query technologies such as Starburst or Trino is preferred.
  • Experience migrating complex legacy data warehouse workloads to cloud-based platforms is preferred.
  • Experience working with sensitive healthcare data and federal privacy and security requirements is preferred.
  • Microsoft Certified: Azure Data Engineer Associate or a comparable cloud data engineering certification is preferred.

About the Company

Trilogy Federal

Provides SDVOSB federal financial management consulting

Trilogy Federal provides financial management and IT consulting services to the U.S. federal government as a verified SDVOSB. Its work covers assessing and optimizing financial management solutions, migrating or enhancing systems to meet new requirements, and delivering data-driven reporting through Business Intelligence (BI) and Business Performance Management (BPM) tools. The company distinguishes itself through deep federal financial management expertise from a leadership team with over 60 years of combined experience, a practical, data-focused approach, and end-to-end support that aims for fiscal compliance and audit readiness. Trilogy’s goal is to help agencies achieve timely, reliable, and value-added financial reporting across programs of all sizes.

Company size
51-200
Company stage
Not listed
Total funding
Not listed
Headquarters
Arlington, WV
Founded
2009

Recently Posted Jobs

Explore more opportunities at Trilogy Federal

See more jobs