Senior Data Architect, Cloud DW & Data Strategy

SMX; Hagåtña (GU); 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 an enterprise data warehouse supporting the FTA's mission. You will replace legacy systems, implement cloud data solutions, and provide the backbone for analytics and data-driven decisions for a vital government agency.

Lead architecture, data modeling, ETL/ELT pipelines, and governance while guiding teams and stakeholders. Experience with AWS, Databricks, and modern data platforms is essential for success.

Qualifications

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

Responsibilities

• Own data architecture, including scalable data models, data marts, and DB solutions.
• Create and maintain logical/physical data models and hierarchies.
• Oversee ETL/ELT integration from internal systems and external sources.
• Provide technical leadership and governance for data analytics.
• Support cloud modernization and migration to Databricks/Data Lakes on AWS.

Skills

Data warehousing

Data modeling

ETL/ELT design

AWS cloud

SQL Server

MariaDB

Databricks

Python

SSIS

Stakeholder comms

Education

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

Tools

Microsoft Visio

Job description

SMX is seeking a Senior Data Architect to design, implement, and optimize an enterprise data warehouse supporting the FTA's mission. You will replace legacy systems, implement cloud data solutions, and provide the backbone for analytics and data-driven decisions for a vital government agency.

Lead architecture, data modeling, ETL/ELT pipelines, and governance while guiding teams and stakeholders. Experience with AWS, Databricks, and modern data platforms is essential for success.