Senior Data & BI Solutions Architect

International Executive Service Corps; Oak Ridge, Northern (TN, KY); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Spectra Tech in Oak Ridge, TN is seeking a Solutions Architect to design and govern enterprise data and BI solutions. You will lead data modeling, ELT pipelines, and dashboard delivery using Power BI/Tableau, with security and executive-facing KPI governance.

The role requires strong SQL and Python skills, stakeholder facilitation, and the ability to translate business goals into measurable analytics. This is an on-site opportunity in Oak Ridge with enterprise-scale impact.

Qualifications

• Lead cross-functional discovery sessions with IT and exec stakeholders.
• Architect end-to-end data flow from source to visualization.
• Perform ETL scripting and SQL optimization for performance.
• Develop and publish interactive BI dashboards enterprise-wide.
• Implement data access controls and row-level security.

Responsibilities

• Facilitate workshops to identify metrics, data sources, and outcomes.
• Design data flow architecture from source systems through ELT to warehouse.
• Create and maintain ELT scripts and data pipelines.
• Publish dashboards and ensure accessibility for executives.
• Ensure security and governance across BI environments.

Skills

Enterprise Architecture

Data modeling

BI/Data visualization

SQL & Python

Stakeholder facilitation

Education

PhD in technical field

Masters in technical field

Bachelors in technical field

Associates in technical field

Tools

Power BI

Tableau

Dynatrace

Job description

Spectra Tech in Oak Ridge, TN is seeking a Solutions Architect to design and govern enterprise data and BI solutions. You will lead data modeling, ELT pipelines, and dashboard delivery using Power BI/Tableau, with security and executive-facing KPI governance.

The role requires strong SQL and Python skills, stakeholder facilitation, and the ability to translate business goals into measurable analytics. This is an on-site opportunity in Oak Ridge with enterprise-scale impact.