Senior Data Architect: AWS Cloud Data Warehouse Lead

SMX; Columbia (SC); On-site; USD 135,000 - 200,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement plan

Job summary

SMX seeks an expert Senior Data Architect to design and optimize an enterprise data warehouse supporting critical national transportation analytics. You will replace legacy systems, guide cloud modernization on AWS, and establish robust data models and ETL pipelines for advanced analytics and decision making.

You will lead architecture, governance, and collaboration with federal leads while driving data quality and scalable solutions aligned with mission needs.

Qualifications

• Bachelor’s degree in CS, engineering, information systems or related field.
• 10 years of BI, data warehousing, data modeling and database design experience.
• Proven cloud experience in AWS and data architecture leadership.
• Expertise in dimensional modeling and relational databases (SQL Server, MariaDB).
• Experience building ETL/ELT pipelines with SSIS, Python or Databricks.

Responsibilities

• Lead overall data architecture, data models, data marts, and scalable database solutions.
• Oversee data modeling, design hierarchies, attributes, and metrics for analytics.
• Manage ETL/ELT pipelines and data integration from multiple systems.
• Provide technical leadership and governance for data architecture and quality.
• Assist cloud modernization and migration to Databricks and Data Lakes on AWS.

Skills

Data architecture

Data warehousing

Data modeling

ETL/ELT

AWS cloud

Dimensional modeling

SQL Server

MariaDB

Stakeholder communication

Education

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

Tools

SSIS

Python

Databricks

Power BI

Map Box

Vitara

Jira

Confluence

Job description

SMX seeks an expert Senior Data Architect to design and optimize an enterprise data warehouse supporting critical national transportation analytics. You will replace legacy systems, guide cloud modernization on AWS, and establish robust data models and ETL pipelines for advanced analytics and decision making.

You will lead architecture, governance, and collaboration with federal leads while driving data quality and scalable solutions aligned with mission needs.