Senior Data Architect — Cloud & Data Warehouse Leader

SMX; Helena (MT); In loco; USD 135.000 - 200.000; Tempo pieno

Vantaggi offerti da questo lavoro

Health insurance

Paid leave

Retirement

Descrizione del lavoro

SMX in United States seeks a Senior Data Architect to design, implement, and optimize an enterprise data warehouse supporting federal transportation missions. You will replace legacy systems, implement cloud-native data solutions on AWS, and provide an architectural backbone for advanced analytics and data-driven decisions.

You will lead data architecture, model data marts, oversee ETL/ELT pipelines, and guide governance while collaborating with stakeholders and DoD/government leads on secure,

Competenze

• Bachelor's degree in a relevant field is required.
• 10+ years of experience in BI, data warehousing, data modeling and database design.
• Proven cloud experience in AWS environments.
• Expertise in dimensional modeling for reporting and analytics.
• Strong knowledge of relational databases (SQL Server, MariaDB).
• Experience building ETL/ELT processes with SSIS, Python or Databricks.
• Ability to translate business needs into technical requirements and communicate with stakeholders.

Mansioni

• Lead overall data architecture and develop scalable data models, marts, and databases.
• Create and maintain logical and physical data models to maximize analytics capabilities.
• Oversee ETL/ELT pipelines and data integration across critical systems (NTD, TRAMS).
• Provide governance and guidance to development teams to ensure data quality and integrity.
• Support cloud modernization efforts, assess AWS infrastructure, and migrate to Databricks/Data Lakes.

Conoscenze

Data architecture

Data warehousing

Cloud computing

Dimensional modeling

ETL/ELT

Data governance

Stakeholder communication

Formazione

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

Strumenti

SSIS

Python

Databricks

SQL Server

MariaDB

Power BI

AWS DMS

Jira

Confluence

Descrizione del lavoro

SMX in United States seeks a Senior Data Architect to design, implement, and optimize an enterprise data warehouse supporting federal transportation missions. You will replace legacy systems, implement cloud-native data solutions on AWS, and provide an architectural backbone for advanced analytics and data-driven decisions.

You will lead data architecture, model data marts, oversee ETL/ELT pipelines, and guide governance while collaborating with stakeholders and DoD/government leads on secure,