Senior Data Architect - Cloud DW & Analytics Leader

SMX

Olympia (WA)

On-site

USD 135,000 - 200,000

Full time

2 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

SMX is seeking an expert Senior Data Architect to design, implement, and optimize the enterprise data warehouse that supports the FTA's mission to improve public mass transportation. The role replaces legacy systems and accelerates cloud data solutions for advanced analytics and data-driven decisions across a vital government agency.

You will lead data modeling, ETL/ELT development, and governance, while driving AWS modernization and migration to Databricks/data lakes to ensure scalable

Qualifications

Bachelor's degree required in a related field.
10+ years of professional BI/DW experience.
Cloud experience with AWS and modern data platforms.
Expertise in dimensional modeling for analytics.
Hands-on relational databases (SQL Server, MariaDB).
Experience building ETL/ELT with SSIS, Python, Databricks.
Ability to translate business needs into technical requirements and communicate to stakeholders.

Responsibilities

Lead overall data architecture and scalable data models.
Design and maintain logical/physical data models and data marts.
Oversee ETL/ELT pipelines across multiple data sources.
Provide technical leadership and governance for data initiatives.
Guide cloud modernization efforts in AWS, Databricks, and data lakes.

Skills

Dimensional modeling

Data warehousing

ETL/ELT design

Data governance

Education

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

Tools

SQL Server

MariaDB

SSIS

Python

Databricks

AWS

Power BI

Job description

You will lead data modeling, ETL/ELT development, and governance, while driving AWS modernization and migration to Databricks/data lakes to ensure scalable

Get your free, confidential resume review.

or drag and drop your file here.