Jobs Ask AI Pay Interviews Companies CompareSign in

Wait…

We read every job from the company's own job board. You apply on the company site.Jobs Job types Internships New graduate jobs Companies Pay Reported pay Check an offer Add your pay Interview questions Add your interview questions Compare with LinkedIn Job sites compared Pay transparency laws API for developers Monthly report Companies we cover Make a portfolio page For companies: find people About Privacy

Cleared Sr. Data Architect (5719)

SMX, United States +1

Posted pay

$135K–$200K

a year

Location: United States +1
Work type: Not given
Level: Senior
Skills in the job text: Python
AWS
SQL
Databricks
Jira
Power BI
Posted: 22 days ago
Last check: 1 h ago
Job type: Software engineering

Apply on the SMX site Sign in to save

The SMX site opens in a new tab.

S

SMX

About SMX: funding, hiring and pay

Check my fit

Compare your résumé with this job. See where you match, what is missing and which lines to change.

Sign in to check your fit

Overview

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.

What you need

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.

Nice to have

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.

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.

# 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.

The proposed salary for this position is

$134,700—$200,400 USD

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.

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).

Legal notes

SMX is an Equal Opportunity employer including disabilities and veterans.

Read the job posting on the SMX site

Similar jobs at other companies

AF
Data Architect in Washington, DC
Accenture Federal ServicesArlington, VA +1
- Software engineering
$103K–$196K / yr
Posted 2 days ago
Staff Data Engineer
DATDenver, CO
- Staff
- Data engineering
$173K–$216K / yr
Posted 3 days ago
A
Information Technology/Data Warehouse Subject Matter Expert (SME)
AnaVationHuntsville, AL
- Onsite
- Data engineering
Pay not posted
Posted Aug 27, 2026
CP
Senior Data Architect
Careers PeratonHerndon, VA +1
- Senior
- Software engineering
$135K–$216K / yr
Posted 27 days ago
CP
Data Architect | US
Cuesta PartnersChicago
- Remote
- Software engineering
$175K–$225K / yr
Posted Jan 28, 2026
AF
Cleared Data Engineer
Accenture Federal ServicesWashington, DC +1
- Data engineering
$93K–$176K / yr
Posted Oct 14, 2025

Source: the SMX Greenhouse job board. We last checked this job 1 h ago. We first saw it 5 days ago. A job on a job board does not always mean that the team interviews people now. We found this job board in a public list. We did not yet compare it with the careers page of the company.

Interview questions

No one has reported an interview at SMX yet. Did you interview there? Add the questions.

SMX

Open tech jobs: 53
With posted pay: 100%
Median posted base: $111K–$175K

About SMX: funding, hiring and pay

Compared with similar jobs

This base pay is below the median for senior software engineering jobs in other US places.

Median: $188K a year
Other jobs in the group: 1,847

We compare the middle of each posted range. This is base pay as posted. The group does not include this job.