Senior Data Solutions Architect - ELT & BI Dashboards

Spectra Tech, Inc.; Oak Ridge (TN); On-site; USD 110,000 - 170,000; Full time

Job summary

Spectra Tech, Inc. is seeking a Solutions Architect in Oak Ridge, TN to lead enterprise data architecture and BI/ELT initiatives. You will translate business goals into measurable KPIs, design end-to-end data flows, and build scalable dashboards for executives and operations teams.

The role requires strong data modeling, ETL scripting, and security practices, with oversight of tools like Power BI and Tableau. On-site position in Oak Ridge.

Qualifications

• Translate business goals into KPIs and visual strategies.
• Model data (star schemas, dimensional modeling) for ELT in data warehouses.
• Expertise in BI dashboards, UX/UI, RLS, and performance tuning for large datasets.
• Proficient in SQL and Python for data transformation logic.
• Lead cross-functional discovery, reconciling tech limits with business needs.

Responsibilities

• Facilitate workshops with engineers, DBAs, and stakeholders to identify metrics and outcomes.
• Design end-to-end data flow from source metrics to ETL, warehouse, and visualization.
• Perform scripting, database engineering, and SQL optimization for optimized schemas.
• Build, publish, and maintain interactive dashboards for system health and performance.
• Implement data access controls and row-level security for authorized users.
• Evaluate BI tools and advise on the best fit for the organization.

Skills

Enterprise Architecture

Data Modeling

ETL / ELT

BI Visualization

SQL / Python

Requirements Gathering

Tools

Power BI

Tableau

Dynatrace

Job description

Spectra Tech, Inc. is seeking a Solutions Architect in Oak Ridge, TN to lead enterprise data architecture and BI/ELT initiatives. You will translate business goals into measurable KPIs, design end-to-end data flows, and build scalable dashboards for executives and operations teams.

The role requires strong data modeling, ETL scripting, and security practices, with oversight of tools like Power BI and Tableau. On-site position in Oak Ridge.