[Remote] Modernization Data Architect (US HHS Badge)

Note: The job is a remote job and is open to candidates in USA. Apptad is seeking a Modernization Data Architect to support regulatory systems undergoing multiyear modernization. The role defines and implements a Databricks lakehouse architecture, builds stable data interfaces as legacy systems migrate, and leads data modeling, integration, and delivery with client stakeholders and Deloitte teams.

Responsibilities

• Define, gain governance approval for, implement, and maintain a medallion (bronze, silver, gold, or equivalent layered) lake house architecture on Databricks as the target platform for modernized reporting, analytics, and data integration. Design the curated layers so they remain stable as legacy source systems are replaced underneath them
• Design and implement transitional legacy bridge data interfaces, such as materialized views or other stable abstraction layers, that remain consistent for consuming applications regardless of where the underlying data is hosted as sources migrate across database platforms and cloud environments. Carry these bridges through to legacy decommissioning and eventual API or Databricks native integration patterns
• Support evaluation and selection of target data platforms during modernization planning, including the planned migration to AWS RDS/PostgreSQL, and translate platform decisions into concrete migration plans and integration approaches with dependent systems
• Lead the architecture, design, and implementation of data interfaces, synchronization jobs, data quality procedures, and harmonization activities across multiple disparate agency source systems
• Partner with client stakeholders and Deloitte teams to assess data requirements, define priorities, and deliver scalable data management solutions. Operate comfortably at both the business/functional and technical implementation level
• Analyze legacy data models, database schemas, and business processes to identify entities, relationships, data flows, and transformation requirements
• Create target state conceptual, logical, and physical data models, including lakehouse/medallion layer designs, to support application development, reporting, and system integration. Collaborate with clients to assess and adapt these models against business, technical, and operational needs
• Conduct database analysis and develop data management plans covering data classification, retention, disposition, archival, and data growth strategies
• Streamline and consolidate data synchronization and integration jobs, scripts, and processes across agency database schemas. Identify optimization opportunities across code, queries, synchronization, integrations, and database calls
• Work with development teams to design and create database objects across integrated legacy and modernized systems to improve efficiency, scalability, and maintainability
• Coordinate with API, application development, security, infrastructure, and other workstreams on data architecture and implementation decisions
• Support Agile delivery activities, including Jira ticket management, planning, prioritization, status reporting, and dependency management
• Produce clear technical documentation and communicate data architecture, design decisions, risks, and recommendations to client and Deloitte leadership

Skills

• Requires active U.S. Dept. of HHS Badge, running!
• Active HHS badge
• Non-U.S. citizens working on visas must have lived in the U.S. for at least 3 of the last 5 years
• Visa expiration date must be at least 1 year beyond the projected start date
• Minimum 5 years of experience in data architecture, data engineering, data integration, or database design, including designing Lakehouse or medallion (bronze, silver, gold, or equivalent layered) architectures on a modern cloud data platform such as Databricks as a stable interface for downstream reporting and integration
• Experience designing and implementing transitional or bridge data interfaces, such as materialized views, database links, or view based abstraction layers, that decouple downstream consumers from underlying source system changes across heterogeneous database platforms and as systems move from on premises to cloud environments
• Experience supporting database platform evaluation and migration planning, such as migrating from Oracle to AWS RDS or PostgreSQL, including integration with dependent systems during and after migration
• High proficiency with Databricks and SQL, particularly Oracle Database, and PostgreSQL; working knowledge of AWS data services such as RDS
• Minimum 3 years of experience working in the U.S. in a public trust environment
• Experience designing and implementing data interfaces, synchronization processes, integration jobs, and data quality procedures across multiple, disparate source systems
• Experience developing conceptual, logical, and physical data models for enterprise applications, including layered lakehouse/medallion data models
• Ability to create clear data architecture diagrams, data flow diagrams, and entity relationship diagrams to support design reviews and governance approval
• Experience analyzing legacy data models, database schemas, business processes, and entity relationships to support modernization efforts
• Experience creating data management plans, including data classification, retention, disposition, archival, and data growth strategies
• Experience optimizing queries, database calls, data synchronization processes, integrations, and application code
• Demonstrated ability to present data architecture designs and tradeoffs to business and non-technical stakeholders, and to lead technical implementation directly rather than handing designs off to another architect or engineer
• Experience working in a public sector or agency environment, including complex legacy system modernization
• Familiarity with Agile software development practices and Jira ticket management
• Strong organization, self-management, prioritization, and problem-solving skills in a fast-paced, matrixed environment
• Experience with Spring Boot or similar containerized, microservices based web API development, and how data architecture should integrate with API first microservices
• Experience with Angular or similar modern front end or micro-UI frameworks, particularly how UI and API consumption patterns should inform data interface design
• Experience with Elasticsearch or similar search and indexing platforms, especially indexing, and searching unstructured or semi structured documents such as regulatory submission documents alongside structured data
• Knowledge of broader API based architectures, RESTful services, and event driven integration patterns
• Experience with data streaming or near real time synchronization patterns
• Experience with data governance, metadata management, data lineage, master data management, or data cataloging
• Experience supporting application development teams with database objects, interfaces, and data migration activities
• Experience with performance tuning, data reconciliation, automated data quality testing, or monitoring of data pipelines

Benefits

• Remote work (USA)

Company Overview

Company H1B Sponsorship