Senior Data Architect: Cloud DW & ETL Lead

SMX; Trenton (NJ); On-site; USD 135,000 - 200,000; Full time

Job summary

SMX is seeking a Senior Data Architect to design, implement, and optimize an enterprise data warehouse supporting the FTA’s mission to enhance public transportation. You will replace legacy systems, implement cloud data solutions, and provide an architecture backbone for advanced analytics.

You will lead data architecture, model data, oversee ETL/ELT pipelines, and ensure data governance and quality while guiding cloud modernization with AWS, Databricks, and Data Lakes.

Qualifications

• Must have 10+ years in BI, DW, modeling and DB design.
• Cloud-based data architecture experience, AWS preferred.
• Proficient in dimensional modeling for analytics and reporting.
• Strong SQL Server and MariaDB proficiency.
• Design and build complex ETL/ELT pipelines (SSIS, Python, Databricks).
• Able to translate business needs into technical requirements for stakeholders.

Responsibilities

• Own data architecture for scalable models, data marts, and DB solutions.
• Design logical/physical data models to maximize analytics capabilities.
• Oversee ETL/ELT pipelines integrating NTD/TRAMS and external data sources.
• Provide governance and data quality guidance across teams.
• Lead cloud modernization: assess AWS infra, migrate to Databricks/Data Lakes.

Skills

10+ years BI & DW

AWS cloud experience

Dimensional modeling

Relational DB expertise

ETL/ELT design

Business requirements translation

Education

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

Tools

SSIS

Python

Databricks

SQL Server

MariaDB

Power BI

Map Box

Vitara

Jira

Confluence

AWS

AWS DMS

Job description

SMX is seeking a Senior Data Architect to design, implement, and optimize an enterprise data warehouse supporting the FTA’s mission to enhance public transportation. You will replace legacy systems, implement cloud data solutions, and provide an architecture backbone for advanced analytics.

You will lead data architecture, model data, oversee ETL/ELT pipelines, and ensure data governance and quality while guiding cloud modernization with AWS, Databricks, and Data Lakes.