Job Closed
This listing is no longer active.
SDVOSB, Systems Integrator to Federal Civilian Agencies, the Intelligence Community, and Department. of Defense.
Senior Data Architect
Location
Pennsylvania + 1 moreAll locations: Pennsylvania | Virginia
Posted
10 days ago
Salary
0
Seniority
Senior
Job Description
Senior Data Architect
Onyx Government Services
• Develop and maintain enterprise data and analytics strategy documents, roadmaps, and improvement plans (including POA&Ms) for DLA J6TF • Design and support an enterprise data governance framework — governance structure documentation, data ownership assignments, data stewardship roles, and operating procedures • Manage metadata per DoD standards, including DoD Metadata Registry (DoD 8320 series) and Net-centric Enterprise Services requirements • Provide architecture recommendations for DLA analytical platforms — data ingestion, storage, processing, and delivery layers • Support enhancement of DLA's Enterprise Data Warehouse (EDW) — logical and physical schema design, data source integration, and analytical layer development • Develop data dictionaries, data inventories, and data lineage documentation across DLA's multi-system enterprise environment • Identify and register authoritative data sources across DLA data domains; document authoritative source designations per governance policy • Conduct data quality assessments — profile source data, document quality issues, and produce remediation recommendations • Support data governance working groups and data stewardship council activities — facilitation, briefings, and deliverable preparation • Develop and maintain artifacts including logical data models, conceptual data models, metadata management plans, and enterprise architecture alignment documents • Prepare monthly progress reports, IPR briefing charts, and deliverables for COR review
Job Requirements
- 5+ years of experience as a Data Architect, Enterprise Data Architect, or equivalent technical role
- Experience supporting a Chief Data Officer (CDO), enterprise data governance office, or equivalent organizational function in a federal agency or DoD component
- Demonstrated experience developing enterprise data and analytics strategy documents, data management frameworks, or data governance charters
- Experience with DoD metadata management standards and data policy — DoD 8320 series, Net-centric Enterprise Services, or equivalent federal data standards
- Experience designing or enhancing Enterprise Data Warehouses (EDW) — logical/physical schema, data flow architecture, multi-source integration
- Proficiency with data modeling tools: ERwin, SAP PowerDesigner, ER/Studio, or equivalent enterprise data modeling platform
- Experience developing data dictionaries, data inventories, and data lineage documentation across complex, multi-system environments
- Experience identifying and designating authoritative data sources, conducting data quality assessments, and producing remediation recommendations
- IAT Level II certification (per DoD 8570.01-M / DoD 8140) at time of start — qualifying certifications include: CompTIA Security+, CISSP, CCNA Security, CySA+, or equivalent from the DoD-approved list
- Active Top Secret clearance (IT-I Critical Sensitive / T5) required at time of proposal submission — no exceptions.
Benefits
- Competitive compensation
- Professional development
- Remote work options
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Data Engineer
DynataThe world’s largest first-party data company for insights, activation & measurement
• Create and maintain optimal data pipeline architecture • Assemble large, complex data sets that meet functional / non-functional business requirements • Design and implement data application components • Work with data and analytics experts to strive for greater functionality in our data systems • Develop and direct security procedures and safeguards to reduce the risk of outside breaches and protect sensitive information
• Serve as the primary technical lead and escalation point for enterprise data engineering initiatives. • Bridge business requirements, architectural standards, and engineering implementation. • Partner with business analysts, architects, BI teams, DevOps, and data engineers to support successful solution delivery. • Interpret and clarify technical implementation requirements for data engineering teams. • Guide implementation decisions across Databricks pipelines, transformations, and data models. • Review engineering implementations for consistency, scalability, maintainability, and alignment to standards. • Support troubleshooting and root cause analysis for data quality issues, failed pipelines, performance concerns, and production defects. • Act as L1/L2 support lead for enterprise data platform operational issues. • Perform lineage and downstream impact analysis for data model and pipeline changes. • Guide implementation of reusable engineering patterns, medallion architecture, and gold-layer datasets. • Coordinate defect triage, release support, deployment validation, and production stabilization activities. • Support adoption of engineering standards, CI/CD processes, governance controls, and operational best practices. • Mentor and guide data engineers on technical implementation approaches and enterprise standards. • Drive consistency across engineering teams, platforms, and data products. • Document technical patterns, implementation standards, operational procedures, and support processes.
• Responsible for understanding, preparing, transforming, loading, and validating data migrated from the legacy system to the new model. • Map entities, fields, and relationships of the current model, including user, subscription, dependent, and payment where applicable to the scope. • Perform AS IS → TO BE mapping, identifying gaps, inconsistencies, duplicates, and required rules for the new data model. • Define and execute processes for extraction, cleansing, normalization, transformation, and loading of legacy Filó data. • Create import scripts, integrity controls, execution logs, volume validations, and data reconciliation. • Support modeling of the partner, company, beneficiary, dependents, offers, and subscriptions hierarchy. • Participate in cutover strategy, data freeze, migration window, and rollback planning.
• Define and implement Artificial Intelligence solutions applied to data modernization and legacy systems. • Develop mechanisms for analyzing, interpreting, and extracting technical information from legacy artifacts. • Build Generative AI–based solutions to accelerate documentation, transformation, and migration processes. • Create intermediate metadata models to represent flows, business rules, dependencies, entities, and transformations. • Develop accelerators and reusable components aligned with the enterprise data architecture. • Support the definition of templates, technical standards, and declarative structures for modern pipelines. • Develop and evolve pipelines using Databricks, PySpark, Lakeflow Jobs, and Declarative Pipelines. • Work with batch loads, incremental ingestions, CDC (Change Data Capture), and enterprise integrations. • Support the advancement of data governance, traceability, and data quality during migration. • Collaborate with architects, data engineers, and platform specialists to define scalable and secure solutions.




