Cleared Sr. Data Architect (5719)

We are seeking an expert Senior Data Architect to design, implement, and optimize the enterprise data warehouse that directly supports the FTA's mission to improve public mass transportation across the nation. This is a high-impact role where you will work with our team to replace legacy systems, implement cutting-edge cloud data solutions, and provide the architectural backbone that enables advanced analytics and data-driven decision-making for a vital government agency.

Essential Duties:

- Lead Data Architecture: Own the overall data architecture, including the design, development, and maintenance of scalable data models, data marts, and database solutions that align with the FTA's business requirements.

- Data Modeling & Design: Create and maintain logical and physical database models using tools like Microsoft Visio. Design hierarchies, attributes, and metrics to maximize drill-down and analytical capabilities within the Enterprise Data Warehouse.

- ETL & Data Integration: Oversee the integration of disparate data se