Senior Data Architect - Cloud Data Warehouse Leader

SMX; Honolulu (HI); 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, implement, and optimize the enterprise data warehouse supporting the FTA mission to improve public mass transportation across the nation.

This high-impact role involves replacing legacy systems, enabling advanced analytics, and guiding cloud modernization with AWS, Databricks, and Data Lakes.

You will lead data architecture, model data, oversee ETL/ELT pipelines, and provide governance to ensure data integrity and quality for federal programs.

Qualifications

• 10+ years of experience in BI, Data Warehousing, data modeling, and database design.
• Bachelor's degree in CS, Engineering, IS, or related field.
• Proven cloud experience in AWS and data architecture.

Responsibilities

• Lead data architecture: design, develop, and maintain scalable data models, data marts, and DB solutions for Enterprise Data Warehouse.
• Data modeling & design: create logical/physical models to maximize analytics and drill-down.
• ETL & data integration: oversee integration of data from critical systems and external sources; build robust ETL/ELT pipelines.
• Technical leadership & governance: advise stakeholders, guide development teams, support data governance for integrity and quality.
• Cloud modernization: assess and optimize AWS infrastructure and migrate to Databricks/Data Lakes.

Skills

BI & DW experience

Dimensional modeling

Cloud AWS architecture

SQL Server & MariaDB

ETL/ELT pipelines

Stakeholder communication

Education

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

Tools

SSIS

Python

Databricks

Job description

SMX is seeking a Senior Data Architect to design, implement, and optimize the enterprise data warehouse supporting the FTA mission to improve public mass transportation across the nation.

This high-impact role involves replacing legacy systems, enabling advanced analytics, and guiding cloud modernization with AWS, Databricks, and Data Lakes.

You will lead data architecture, model data, oversee ETL/ELT pipelines, and provide governance to ensure data integrity and quality for federal programs.