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 sets from critical FTA systems (e.g., NTD, TRAMS) and external sources, ensuring the development of robust, efficient ETL/ELT pipelines.
- Technical Leadership & Governance: Serve as the subject matter expert for data architecture, collaborating with stakeholders to gather requirements and providing guidance to development teams. Support enterprise data and analytics governance activities to ensure data integrity and quality.
- Cloud Modernization: Work with the data lead to help assess and optimize the current AWS cloud infrastructure for performance, cost-efficiency, and scalability. Assist with the migration of the technology stack to modern platforms like Databricks and Data Lakes.
Required Skills & Experience
- 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 within a cloud environment, specifically AWS.
- Expertise in dimensional modeling techniques and tools for effective 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.
- Strong ability to translate business needs into technical requirements and communicate complex technical concepts effectively to stakeholders and federal leads.
Desired Skills & Experience
- Data Modeling Certification (DMC) from the Data Modeling Institute.
- Experience with the Strategy analytics platform; certifications in Strategy are a significant plus.
- Familiarity with data replication tools such as AWS DMS.
- Experience with additional BI and visualization tools like 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.
# LI-SA1
The SMX salary determination process takes into account a number of factors, including but not limited to, geographic location, Federal Government contract labor categories, relevant prior work experience, specific skills, education and certifications. At SMX, one of our Core Values is to Invest in Our People so we offer a competitive mix of compensation, learning & development opportunities, and benefits. Some key components of our robust benefits include health insurance, paid leave, and retirement.
At SMX®, we are a team of technical and domain experts dedicated to enabling your mission. From priority national security initiatives for the DoD to highly assured and compliant solutions for healthcare, we understand that digital transformation is key to your future success.
We share your vision for the future and strive to accelerate your impact on the world. We bring both cutting edge technology and an expansive view of what’s possible to every engagement. Our delivery model and unique approaches harness our deep technical and domain knowledge, providing forward-looking insights and practical solutions to power secure mission acceleration.
SMX is an Equal Opportunity employer including disabilities and veterans.
Selected applicant may be subject to a background investigation and/or education verification.
SMX does not sponsor a new applicant for employment authorization or immigration related support for this position (i.e. H1B, F-1 OPT, F-1 STEM OPT, F-1 CPT, J-1, TN, E-2, E-3, L-1 and O-1, or any EADs or other forms of work authorization that require immigration support from an employer).
Skills Required
- 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
- Experience architecting and optimizing cloud-based data solutions using AWS
- Expertise in dimensional modeling techniques and tools for reporting and analytics
- Hands-on experience with relational database platforms, specifically SQL Server and MariaDB
- Experience designing and building complex ETL/ELT processes using SSIS, Python, or Databricks
- Ability to translate business needs into technical requirements and communicate complex technical concepts to stakeholders and federal leads
- Data Modeling Certification from the Data Modeling Institute
- Experience with the Strategy analytics platform or Strategy certifications
- Familiarity with AWS DMS or other data replication tools
- Experience with Power BI, Mapbox, or Vitara
- Working knowledge of Jira and Confluence
- Previous experience supporting a federal government agency, particularly the Department of Transportation
SMX Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about SMX and has not been reviewed or approved by SMX.
-
Fair & Transparent Compensation — Salary ranges are publicly listed on many postings and a pay transparency statement clarifies how location, contract, and credentials influence offers. This visibility helps set clear expectations around compensation.
-
Leave & Time Off Breadth — About four weeks of PTO plus 11 paid federal holidays are highlighted in careers materials. Paid military leave on some roles further expands time‑off coverage.
-
Retirement Support — A 401(k) with a dollar‑for‑dollar match on the first 5% and immediate vesting is called out in role descriptions. Traditional and Roth options support long‑term savings.
SMX Insights
What We Do
SMX is a global technology and advanced engineering provider specializing in Cloud Solutions, C5ISR, and Advanced Engineering / IT. Our tradition of delivering innovative, technical solutions dates back to 1995, however, you may know us better by one of our legacy company names: Trident Technologies, Smartronix, Datastrong, or C2S Consulting Group. With the support of OceanSound Partners, our private equity investment sponsor, we began operating as one business starting in 2019 and became SMX in 2021. We operate in close proximity to our clients around the globe and have core locations in Alabama, California, the DC Metro, Florida, Hawaii, Maryland, and Massachusetts. Today, as SMX, we are one team and together empower government and commercial enterprises to become more effective, innovative, and resilient, no matter what challenges they face. SMX offers competitive benefits, excellent work environments, and growth opportunities for our employees while continuing to expand operations and support our communities. We have more than 25 years of rapid and consistent growth with continuous recognition as an employer-of-choice technology company. In addition, we have earned coveted industry quality and business certifications; have a strong commitment to business partnerships, ethics, compliance, and sustainability; and have a multitude of premier contracting vehicles. The combination of these attributes allows us to provide sound, repeatable business solutions yet remain flexible and agile to quickly adapt to specific customer requirements. Committed to ensuring the highest levels of customer satisfaction, SMX is structured around the programs and technologies we support to provide optimal and seamless operations. We have maintained a reputation for excellence, helping to assure the missions of our Department of Defense, Public Sector, Fortune 1000, and other Government and commercial customers.
.png)
