AEM Corporation · 21 hours ago
Data Engineer
Washington, DC
Full-time
Onsite
Senior Level
$120K/yr - $130K/yr
5+ years expAEM Corporation is seeking a Data Engineer to join their team and contribute to building trusted, high-quality data products for Federal clients. The role involves designing and implementing scalable data pipelines and lakehouse solutions using Microsoft Azure services, while collaborating closely with product owners and stakeholders in a Scrum environment.
ConsultingData VisualizationInformation ServicesInformation Technology
No H1B
U.S. Citizen Only
Responsibilities
Design and implement secure, scalable data pipelines in Azure (Synapse Notebooks, Python, Pandas, pySpark, Synapse Pipelines, Azure Functions, Logic Apps, etc.) to ingest, profile, transform, improve data quality, and publish trusted data
Engineer robust lake storage on ADLS Gen2 using Parquet, Iceberg, partitioning techniques, and performance optimization techniques
Establish data quality controls: profiling, validation rules, reproducible transformations, and automated tests with monitoring/alerting
Operationalize pipelines with CI/CD, environment promotion, secrets management, and run-time observability (e.g., Azure DevOps)
Model and serve data for analytics/BI (e.g., Power BI), including row-level security and refresh orchestration
Document design decisions, lineage, and data contracts; contribute to catalog/metadata management (e.g., Microsoft Purview)
Collaborate within a Scrum team—participate in sprint planning, reviews, and retros—and partner with product owners/stakeholders to refine user stories
Continuously improve team ways of working: propose automation, standardization, and quality practices that increase throughput and reliability
Qualification
Required
U.S. citizen with the ability to obtain a Public Trust background investigation
5+ years of professional data engineering experience and a bachelor's degree (or 3+ years with a related advanced degree)
Strong Python (pandas, PySpark) and SQL; experience building reproducible, testable data transformations
Hands-on expertise with Azure Synapse Analytics (Notebooks/SQL/Spark) and ADLS Gen2
Production experience with Synapse or Azure Data Factory, Functions, and Logic Apps for event-driven orchestration
Solid data architecture fundamentals (lakehouse patterns, partitioning, schema management) and performance tuning at scale
Data quality, lineage, and governance mindset; familiarity with Microsoft Purview or equivalent catalog/lineage tooling
Version control (Git) and CI/CD practices (e.g., Azure DevOps) for data solutions
Excellent communication skills and a collaborative, help-seeking/help-giving approach in a Scrum team
Preferred
Experience integrating with AWS data services (S3, Glue/Glue Data Catalog, Lambda) and/or cross-cloud data patterns
Experience enabling BI/analytics (Power BI, model design, RLS) and supporting analysts with performant datasets
Experience building observability for data systems (usage/cost telemetry, data SLAs, pipeline health dashboards)
Familiarity with MDM and reference data concepts and enterprise governance
Relevant certifications: Microsoft Azure Data Engineer (DP-203), Azure Enterprise Data Analyst, or AWS data certifications
Existing Federal Government Clearance
Company
AEM Corporation
AEM Corporation is a diversified services company that primarily supports federal agencies and Fortune 500 clients.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Sharon deMonsabert
President
Recent News
2025-09-22
2025-07-10
Company data provided by crunchbase