Senior Data Architect - Cloud Modernization & DW Lead

SMX; Austin (TX); Presencial; USD 135.000 - 200.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health insurance

Paid leave

Retirement

Descripción de la vacante

SMX is seeking a Senior Data Architect to design and optimize an enterprise data warehouse that supports the FTA's mission. You will lead data modeling, ETL pipelines, and cloud modernization efforts, including Databricks and Data Lakes, across critical systems like NTD and TRAMS.

You will collaborate with federal leads and stakeholders, translating requirements into scalable data architectures, while championing data quality and governance across the organization.

Formación

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
• 10+ years of professional experience in BI, data warehousing, data modeling, and database design.
• Proven experience architecting and optimizing data solutions in AWS cloud environments.
• Expertise in dimensional modeling techniques for reporting and analytics.
• Hands-on with relational databases: SQL Server and MariaDB.
• Experience building ETL/ELT processes using SSIS, Python, or Databricks.
• Strong ability to translate business needs into technical requirements and communicate with stakeholders.

Responsabilidades

• Lead overall data architecture, including scalable models, data marts, and database solutions.
• Create and maintain logical/physical data models; design hierarchies and metrics.
• Oversee ETL/ELT pipelines and data integration from critical systems and external sources.
• Provide technical leadership and governance; align with enterprise data and analytics governance.
• Support cloud modernization; assess AWS infrastructure and migrate to modern platforms like Databricks and Data Lakes.

Conocimientos

BI & DW experience

Data modeling

Cloud AWS

Dimensional modeling

SQL Server

MariaDB

ETL/ELT design

Data governance

Stakeholder communication

Architectural leadership

Educación

Bachelors in CS/Engineering/IS or related

Herramientas

SSIS

Python

Databricks

Visio

AWS DMS

Power BI

Descripción del empleo

SMX is seeking a Senior Data Architect to design and optimize an enterprise data warehouse that supports the FTA's mission. You will lead data modeling, ETL pipelines, and cloud modernization efforts, including Databricks and Data Lakes, across critical systems like NTD and TRAMS.

You will collaborate with federal leads and stakeholders, translating requirements into scalable data architectures, while championing data quality and governance across the organization.