Cloud Data Architect — AWS, Databricks & DW Lead

SMX; Carson City (NV); 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 an enterprise data warehouse supporting the FTA mission. You will lead data modeling, architecture, and data integration efforts across critical systems while guiding governance and quality.

The role emphasizes cloud modernization on AWS, adoption of Databricks, and scalable data lake architectures to empower analytics and decision-making for a vital government agency.

Qualifications

• 10+ years in BI, data warehousing, modeling and database design.
• Experience architecting data solutions in AWS cloud.
• Expertise in dimensional modeling for reporting and analytics.
• Hands-on with SQL Server and MariaDB databases.
• ETL/ELT design using SSIS, Python, and Databricks.
• Able to translate business needs into technical requirements.

Responsibilities

• Own the data architecture for enterprise data warehouse development.
• Lead data modeling, data marts, and scalable database designs.
• Oversee ETL/ELT pipelines across diverse data sources.
• Provide technical leadership and governance for data initiatives.
• Assist cloud modernization: optimize AWS and migrate to Databricks/Data Lakes.

Skills

Data warehousing

Data modeling

DB design

AWS

Stakeholder communication

Technical leadership

Education

Bachelor's degree in Computer Science, Engineering, Information Systems

Tools

SQL Server

MariaDB

SSIS

Python

Databricks

Power BI

Map Box

Job description

SMX is seeking a Senior Data Architect to design and optimize an enterprise data warehouse supporting the FTA mission. You will lead data modeling, architecture, and data integration efforts across critical systems while guiding governance and quality.

The role emphasizes cloud modernization on AWS, adoption of Databricks, and scalable data lake architectures to empower analytics and decision-making for a vital government agency.