Senior Data Architect: Cloud Modernization & Enterprise DW

SMX; Topeka (KS); On-site; USD 135,000 - 200,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement

Job summary

SMX is seeking a Senior Data Architect to design, implement, and optimize the enterprise data warehouse supporting the FTA’s mission. You will lead the data architecture, model data for analytics, and oversee ETL/ELT pipelines while modernizing cloud infrastructure on AWS and Databricks.

You will collaborate with federal leads and stakeholders to ensure data integrity, governance, and scalable analytics across critical systems such as NTD and TRAMS.

Qualifications

• 10+ years of professional experience in BI, Data Warehousing, Data Modeling, and Database Design.
• Experience architecting and optimizing data solutions in AWS cloud.
• Expertise in dimensional modeling techniques for reporting and analytics.
• Hands-on with relational databases like SQL Server and MariaDB.
• Experience building ETL/ELT pipelines using SSIS, Python, or Databricks.

Responsibilities

• Lead Data Architecture: design, develop, and maintain scalable data models, data marts, and database solutions.
• Data Modeling & Design: create logical and physical models; design hierarchies and metrics for analytics.
• ETL & Data Integration: oversee ingestion from critical systems and external sources; develop robust ETL/ELT pipelines.
• Technical Leadership & Governance: guide development teams; support governance for data integrity and quality.
• Cloud Modernization: assess and optimize AWS infrastructure; migrate to modern platforms like Databricks and Data Lakes.

Skills

Data architecture

Cloud architecture

Dimensional modeling

Stakeholder communication

ETL/ELT development

Education

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

Tools

SQL Server

MariaDB

SSIS

Python

Databricks

Power BI

Map Box

Vitara

Job description

SMX is seeking a Senior Data Architect to design, implement, and optimize the enterprise data warehouse supporting the FTA’s mission. You will lead the data architecture, model data for analytics, and oversee ETL/ELT pipelines while modernizing cloud infrastructure on AWS and Databricks.

You will collaborate with federal leads and stakeholders to ensure data integrity, governance, and scalable analytics across critical systems such as NTD and TRAMS.