Senior Data Architect – Cloud Data Warehouse Leader

SMX; Boise (ID); On-site; USD 135,000 - 200,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement plan

Job summary

SMX is seeking a Senior Data Architect to design and optimize the enterprise data warehouse supporting the FTA's mission to modernize public mass transportation. You will lead cloud modernization, migrate to Databricks and data lakes, and build scalable data models and ETL pipelines across critical systems.

Ideal candidates bring 10+ years in BI/DW, strong SQL Server and MariaDB experience, and proven leadership in cloud environments, governance, and analytics.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field.
• 10+ years in BI, Data Warehousing, Data Modeling, and DB Design.
• Experience architecting data solutions in AWS cloud environment.
• Expertise in dimensional modeling and analytics-ready data structures.
• Hands-on with SQL Server, MariaDB; ETL/ELT using SSIS, Python, Databricks.

Responsibilities

• Lead overall data architecture with scalable models, data marts, and DB solutions.
• Oversee ETL/ELT pipelines across critical systems and external sources.
• Provide governance and guidance to development teams and stakeholders.
• Drive cloud modernization: optimize AWS infra and migrate to Databricks/Data Lakes.
• Translate business needs into technical requirements for federal leads.

Skills

Data warehousing

Data modeling

AWS cloud

ETL/ELT design

SQL Server

MariaDB

SSIS

Python

Databricks

Stakeholder communication

Federal/government domain

Education

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

Tools

Microsoft Visio

Power BI

Map Box

Vitara

Jira

Confluence

Job description

SMX is seeking a Senior Data Architect to design and optimize the enterprise data warehouse supporting the FTA's mission to modernize public mass transportation. You will lead cloud modernization, migrate to Databricks and data lakes, and build scalable data models and ETL pipelines across critical systems.

Ideal candidates bring 10+ years in BI/DW, strong SQL Server and MariaDB experience, and proven leadership in cloud environments, governance, and analytics.