Senior Data Architect: Cloud Data Warehouse & Analytics

SMX; Richmond (VA); 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 the enterprise data warehouse supporting public mass transportation initiatives. Lead data architecture, model design, ETL/ELT pipelines, and cloud modernization on AWS with Databricks/Data Lakes.

You will guide governance, drive data quality, and collaborate with federal leads to translate business needs into scalable data solutions. This role requires deep BI/DW experience and strong communication skills.

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 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 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.
• Data Modeling & Design: Create and maintain logical and physical database models using tools like Microsoft Visio.
• ETL & Data Integration: Oversee the integration of disparate data sets and development of robust ETL/ELT pipelines.
• Technical Leadership & Governance: Serve as subject matter expert for data architecture and guide development teams; support governance activities.
• Cloud Modernization: Assess and optimize AWS infrastructure; assist with migration to Databricks and Data Lakes.

Skills

Business Intelligence

Data Warehousing

Data Modeling

Database Design

Cloud Architecture (AWS)

SQL Server

MariaDB

ETL/ELT

SSIS

Python

Databricks

Data Governance

Education

Bachelor's degree in Computer Science/Engineering/Info Systems or related

Tools

SSIS

Python

Databricks

Microsoft Visio

SQL Server

MariaDB

Power BI

AWS

Job description

SMX is seeking a Senior Data Architect to design, implement, and optimize the enterprise data warehouse supporting public mass transportation initiatives. Lead data architecture, model design, ETL/ELT pipelines, and cloud modernization on AWS with Databricks/Data Lakes.

You will guide governance, drive data quality, and collaborate with federal leads to translate business needs into scalable data solutions. This role requires deep BI/DW experience and strong communication skills.