Data Management Specialist - Data Engineer
Support the Defense Security Cooperation Agency (DSCA) Chief Data and Artificial Intelligence Officer (CDAO) with data analytics, data integration and pipeline ingest, data management, and catalog and metadata management.
- Remote
- Full-time
- Remote
- Posted Nov 17, 2026
INDUSTRYSoftware & InternetSaaS & Enterprise SoftwareData & Analytics
Responsibilities
- Design, build, and maintain scalable data pipelines and ETL/ELT processes to support analytics and business intelligence based on the DSCA OLTP systems.
- Develop and optimize data models for both operational and analytical systems.
- Implement best practices for data ingestion, transformation, storage, and retrieval across environments.
- Collaborate with data scientists, analysts, and business stakeholders to define data requirements and deliver reliable solutions.
- Ensure data quality, consistency, and governance through monitoring, testing, and validation frameworks.
- Write and maintain efficient SQL queries, stored procedures, and scripts for data processing.
- Work with structured and unstructured data from multiple sources (databases, APIs, streaming platforms, third-party feeds).
- Optimize performance and scalability of large datasets using distributed computing frameworks (e.g., Spark).
- Apply security, compliance, and privacy standards to data solutions.
- Ensure that Data is curated based on requirements and designed with reusability in mind.
- Normalize data elements across systems.
- Build data index, apply deduplication logic to align data, investigate data mismatches, identify data quality gaps, and reconcile metadata for a unified view of business data.
- Troubleshoot data-related issues, ensuring minimal downtime and reliable delivery of data products.
- Provide Data Quality (DQ) measures and improvements in accordance with defined criteria for silver and gold data zones.
- Ensure data is easily discoverable, well-managed, and integrated with metadata and business rules using tools like Collibra.
- Coordinate work across various Advana lines of businesses (Acquisition, Procurement, Supply Chain, and Finance) to continually improve the ability to link mission critical data with other domain data.
- Data sources are to be auto cataloged and integrated with data dictionaries metadata that provide understanding through exposure of data descriptions and business rules that facilitate data integration.
Requirements
- Bachelor of Science or Arts from an accredited university or college, scientific or technical discipline preferred
- Experience in a Federal clients
- Experience in a Defense
Nice to have: Collibra Data Governance Center functionalities, Procurement Lifecycle (DoD's Procure to Pay end-to-end process)
Skills
SQLPythonData integrationData managementData analyticsETL/ELTSparkDatabricksDatabricks SQL EditorErwin data modelerCollibra
Benefits
- Medical
- Dental
- Vision
- Life insurance
- Disability insurance
- Health savings accounts
- Flexible spending accounts
- Retirement 401K plan
- Paid leave programs
Full description
Company details are for members
Sign up for a free job alert to see Seneca Holdings's profile, website and LinkedIn, and the same for every employer on Referso Jobs.