Data Engineer

SAIC · Washington

SAIC is seeking a hands-on Data Engineer with strong Azure experience to build and maintain reliable, scalable data pipelines and datasets that power analytics and operational insights. You will own ingestion, transformation, and data product delivery across Azure services, with Azure Data Factory (ADF), Blob Storage, and Azure SQL as core technologies. Experience with Azure Synapse Analytics, Microsoft Fabric, and Power BI is a plus.

You will design, develop, and operate data solutions using multiple data modeling approaches (e.g., star/snowflake, Data Vault) and data formats (e.g., JSON, Parquet, CSV, Avro). You will collaborate closely with analytics, product, and operations teams to deliver trusted, secure, and performant data products in a modern Azure-based data platform.

Key Responsibilities:

Design, develop, schedule, and monitor batch and near real-time data pipelines in Azure Data Factory (ADF) for data ingestion, transformation, and load (ELT/ETL).
Implement and manage data storage strategies in Azure Blob Storage (access tiers, lifecycle policies, partitioning, folder design).
Design, manage, and optimize datasets in Azure SQL (Database/Managed Instance) including schema design, indexing, and performance tuning.
Create and maintain dimensional models (star/snowflake), and apply 3NF, normalization/denormalization, and Data Vault 2.0 patterns where appropriate.
Implement data quality and governance capabilities including validation rules, profiling, lineage, documentation, and standards for schema evolution and data contracts.
Optimize pipeline runtimes, SQL queries, and storage I/O; implement alerting, retry logic, and cost controls to ensure performance and reliability.
Collaborate with analytics, product, and operations teams to understand requirements and deliver robust, well-documented datasets and data products.
Apply security and compliance best practices, including RBAC, data masking, encryption at rest/in transit, and key management, in line with company policies.
Contribute to best practices, templates, and reusable components to improve consistency and speed of delivery across the data platform.

SAIC® is a premier mission integrator focused on advancing the power of technology and innovation to serve and protect our world. Our robust portfolio of offerings across the defense, space, intelligence, and civilian markets includes secure high-end solutions in mission IT, enterprise IT, engineering services, and professional services. We integrate emerging technology, rapidly and securely, into mission critical operations that modernize and enable critical national imperatives.

We are approximately 23,000 strong; driven by mission, united by purpose, and inspired by opportunities. SAIC is an Equal Opportunity Employer. Headquartered in Reston, Virginia, SAIC has annual revenues of approximately $7.3 billion. For more information, visit saic.com. For ongoing news, please visit our newsroom.

More jobs at SAIC · Data & Analytics jobs in Washington DC