Senior Data Architect - Cloud DW & Gov Analytics Leader

SMX; San Juan (PR); In loco; USD 135.000 - 200.000; Tempo pieno

Vantaggi offerti da questo lavoro

Health insurance

Paid leave

Retirement

Descrizione del lavoro

SMX seeks a Senior Data Architect to design and optimize an enterprise data warehouse supporting the FTA’s mission. You will lead data architecture, models, and ETL pipelines, integrating NTD/TRAMS data and modernizing AWS-based infrastructure with Databricks and data lakes.

You will guide governance, work with stakeholders, and translate business needs into robust technical requirements for secure, scalable analytics across the organization.

Competenze

• 10+ years in BI, data warehousing, data modeling and database design.
• Experience architecting cloud data solutions on AWS.
• Strong dimensional modeling for analytics and reporting.
• Hands-on with SQL Server and MariaDB platforms and ETL/ELT tooling.

Mansioni

• Lead overall data architecture for scalable data models and data marts.
• Design, develop, and maintain enterprise data warehouse components.
• Oversee ETL/ELT pipelines and data integration across systems (NTD, TRAMS, etc.).
• Provide technical leadership and governance for data integrity and quality.
• Collaborate to migrate to Databricks and modern data lake platforms on AWS.

Conoscenze

Enterprise BI

Data Warehousing

Data Modeling

DB Design

Cloud AWS

Dimensional Modeling

SQL Server

MariaDB

SSIS

Python

Databricks

ETL/ELT

Stakeholder Communication

Formazione

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

Data Modeling Certification (DMC)

Strumenti

Power BI

MapBox

Vitara

AWS DMS

Jira

Confluence

Strategy analytics platform

Descrizione del lavoro

SMX seeks a Senior Data Architect to design and optimize an enterprise data warehouse supporting the FTA’s mission. You will lead data architecture, models, and ETL pipelines, integrating NTD/TRAMS data and modernizing AWS-based infrastructure with Databricks and data lakes.

You will guide governance, work with stakeholders, and translate business needs into robust technical requirements for secure, scalable analytics across the organization.