Senior Data Architect: Cloud Data Warehouse & Governance Lead

SMX; Columbus (OH); On-site; USD 135,000 - 200,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement plan

Job summary

SMX seeks a Senior Data Architect to design and implement an enterprise data warehouse supporting federal transportation missions. You will lead data architecture, model building, ETL/ELT pipelines, and cloud modernization on AWS with Databricks and Data Lakes.

Ideal candidates have 10+ years in BI/Data Warehousing, expertise in SQL Server and MariaDB, and strong communication with stakeholders and federal leads. This role emphasizes governance and scalable analytics capabilities.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
• 10+ years of professional experience in Business Intelligence, Data Warehousing, Data Modeling, and Database Design.
• Proven experience architecting and optimizing data solutions within a cloud environment, specifically AWS.
• Expertise in dimensional modeling techniques and tools for effective reporting and analytics.
• In-depth knowledge of and hands-on experience with relational database platforms, specifically SQL Server and MariaDB.
• Demonstrated experience designing and building complex ETL/ELT processes using tools such as SSIS, Python, or Databricks.
• Strong ability to translate business needs into technical requirements and communicate complex technical concepts effectively to stakeholders and federal leads.

Responsibilities

• Lead Data Architecture: Own the overall data architecture, including the design, development, and maintenance of scalable data models, data marts, and database solutions that align with the FTA's business requirements.
• Data Modeling & Design: Create and maintain logical and physical database models using tools like Microsoft Visio. Design hierarchies, attributes, and metrics to maximize drill-down and analytical capabilities within the Enterprise Data Warehouse.
• ETL & Data Integration: Oversee the integration of disparate data sets from critical FTA systems (e.g., NTD, TRAMS) and external sources, ensuring the development of robust, efficient ETL/ELT pipelines.
• Technical Leadership & Governance: Serve as the subject matter expert for data architecture, collaborating with stakeholders to gather requirements and providing guidance to development teams. Support enterprise data and analytics governance activities to ensure data integrity and quality.
• Cloud Modernization: Work with the data lead to help assess and optimize the current AWS cloud infrastructure for performance, cost-efficiency, and scalability. Assist with the migration of the technology stack to modern platforms like Databricks and Data Lakes.

Skills

Data Architecture

Data Modeling

AWS Cloud

Databricks

SSIS

Python

SQL Server

MariaDB

ETL/ELT

Stakeholder Communication

Education

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

Tools

SQL Server

MariaDB

SSIS

Python

Databricks

Power BI

Job description

SMX seeks a Senior Data Architect to design and implement an enterprise data warehouse supporting federal transportation missions. You will lead data architecture, model building, ETL/ELT pipelines, and cloud modernization on AWS with Databricks and Data Lakes.

Ideal candidates have 10+ years in BI/Data Warehousing, expertise in SQL Server and MariaDB, and strong communication with stakeholders and federal leads. This role emphasizes governance and scalable analytics capabilities.