Cleared Sr. Data Architect (5719)

SMX•Hollywood, MD

10d•$134,700 - $200,400

About The Position

SMX is seeking an expert Senior Data Architect to design, implement, and optimize the enterprise data warehouse supporting the Federal Transit Administration’s mission to improve public mass transportation nationwide. The role will help replace legacy systems, implement cloud data solutions, and provide the architecture needed for advanced analytics and data-driven decision-making. The Senior Data Architect owns the overall data architecture, including scalable data models, data marts, and database solutions aligned with FTA business requirements. The role creates and maintains logical and physical database models and designs hierarchies, attributes, and metrics to support analytical capabilities in the Enterprise Data Warehouse. It oversees integration of data from FTA systems and external sources, including development of ETL/ELT pipelines. As the data architecture subject matter expert, this role collaborates with stakeholders to gather requirements, guides development teams, and supports enterprise data and analytics governance to ensure data integrity and quality. Working with the data lead, the architect also helps assess and optimize AWS infrastructure and supports migration to platforms such as Databricks and data lakes.

Requirements

Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field.
10+ years of professional experience in Business Intelligence, Data Warehousing, Data Modeling, and Database Design.
Proven experience architecting and optimizing data solutions in a cloud environment, specifically AWS.
Expertise in dimensional modeling techniques and tools for reporting and analytics.
In-depth knowledge of and hands-on experience with relational database platforms, specifically SQL Server and MariaDB.
Demonstrated experience designing and building complex ETL/ELT processes using tools such as SSIS, Python, or Databricks.
Ability to translate business needs into technical requirements and communicate complex technical concepts effectively to stakeholders and federal leads.

Nice To Haves

Data Modeling Certification (DMC) from the Data Modeling Institute.
Experience with the Strategy analytics platform; Strategy certifications are a significant plus.
Familiarity with data replication tools such as AWS DMS.
Experience with additional BI and visualization tools such as Power BI, Map Box, or Vitara.
Working knowledge of project management and documentation tools such as Jira and Confluence.
Previous experience supporting a federal government agency, particularly within the Department of Transportation.

Responsibilities

Own the overall data architecture, including the design, development, and maintenance of scalable data models, data marts, and database solutions aligned with FTA business requirements.
Create and maintain logical and physical database models using tools such as Microsoft Visio.
Design data hierarchies, attributes, and metrics to maximize drill-down and analytical capabilities within the Enterprise Data Warehouse.
Oversee integration of data sets from FTA systems such as NTD and TRAMS, as well as external sources, and ensure robust, efficient ETL/ELT pipelines are developed.
Serve as the data architecture subject matter expert, gather requirements with stakeholders, and provide guidance to development teams.
Support enterprise data and analytics governance activities to ensure data integrity and quality.
Work with the data lead to assess and optimize AWS cloud infrastructure for performance, cost-efficiency, and scalability.
Assist with migration of the technology stack to platforms such as Databricks and data lakes.