Senior Data Architect — Cloud Data Warehouse Leader

SMX; Atlanta (GA); On-site; USD 135,000 - 200,000; Full time

Job summary

SMX is seeking an expert Senior Data Architect to design and optimize the enterprise data warehouse supporting the agency's mission. You will lead data modeling, ETL/ELT development, and governance while modernizing the cloud stack on AWS and migrating to Databricks/Data Lakes.

In this high-impact role, you will collaborate with federal leads and stakeholders to translate business needs into scalable data solutions, overseeing data integration across critical systems (NTD, TRAMS) and guiding

Qualifications

• 10+ years of professional experience in BI, DW, data modeling, and database design.
• Experience architecting data solutions in AWS cloud.
• Expertise in dimensional modeling for effective reporting and analytics.
• Hands-on with SQL Server and MariaDB.
• Experience building ETL/ELT processes using SSIS, Python, or Databricks.

Responsibilities

• Own the overall data architecture and design scalable data models, data marts, and database solutions.
• Create and maintain logical and physical models, design hierarchies and metrics for analytics.
• Oversee ETL/ELT pipelines across critical systems and external sources.
• Provide technical leadership and governance for data architecture and quality.
• Support cloud modernization, optimize AWS, and migrate to Databricks/Data Lakes.

Skills

BI & DW

Data modeling

Dimensional modeling

Cloud AWS

SQL & RDBMS

ETL/ELT design

Stakeholder communication

Education

Bachelor's degree in CS/Engineering/IS

Data Modeling Certification (DMC)

Tools

SSIS

Python

Databricks

Power BI

Map Box

Vitara

Jira

Confluence

AWS DMS

SQL Server

MariaDB

Job description

SMX is seeking an expert Senior Data Architect to design and optimize the enterprise data warehouse supporting the agency's mission. You will lead data modeling, ETL/ELT development, and governance while modernizing the cloud stack on AWS and migrating to Databricks/Data Lakes.

In this high-impact role, you will collaborate with federal leads and stakeholders to translate business needs into scalable data solutions, overseeing data integration across critical systems (NTD, TRAMS) and guiding