Senior Data Architect - Enterprise Cloud DW (Public Sector)

SMX; Providence (RI); On-site; USD 135,000 - 200,000; Full time

Job summary

SMX is seeking a Senior Data Architect to design and optimize the enterprise data warehouse supporting the FTA mission. You will lead data models, data marts, and scalable database solutions while guiding ETL/ELT pipelines across AWS, Databricks, and data lakes in a modern cloud architecture.

You will collaborate with federal leads and stakeholders, translate complex requirements into robust technical specifications, govern data quality, and drive cost-efficient, high-performance analytics for

Qualifications

• Bachelor's degree required in CS/Engineering/IS or related field.

Responsibilities

• Design, implement, and optimize an enterprise data warehouse.
• Lead data architecture, models, data marts, and governance.
• Oversee ETL/ELT integration from multiple sources.
• Guide cloud modernization and migration to Databricks/Data Lakes.
• Provide technical leadership and stakeholder communication.

Skills

Data warehousing

Data modeling

Cloud architecture AWS

Dimensional modeling

SQL Server

MariaDB

Databricks

SSIS

Python

ETL/ELT design

Stakeholder communication

Enterprise data governance

Education

Bachelor's degree in Computer Science, Engineering, Information Systems, or related field

Tools

Databricks

SSIS

Power BI

MapBox

Vitara

Jira

Confluence

Job description

SMX is seeking a Senior Data Architect to design and optimize the enterprise data warehouse supporting the FTA mission. You will lead data models, data marts, and scalable database solutions while guiding ETL/ELT pipelines across AWS, Databricks, and data lakes in a modern cloud architecture.

You will collaborate with federal leads and stakeholders, translate complex requirements into robust technical specifications, govern data quality, and drive cost-efficient, high-performance analytics for