Solutions Architect

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 is seeking a Solutions Architect for Oak Ridge, TN.

Job Description:

Knowledge, Skillset, and Abilities (KSAs)

• Enterprise Architecture & Business Acumen: Ability to translate high-level business goals and complex system metrics into actionable, executive-ready KPIs and visual strategies.
• Data Modeling & Pipeline Orchestration: Advanced knowledge of modeling data(e.g., star schemas, dimensional modeling) tailored specifically for Extract, Load, Transform (ELT) frameworks within modern data warehouses.
• BI & Data Visualization Expertise: Expert-level mastery of visualization tools (PowerBI, Tableau, or equivalent) with deep knowledge of dashboard UX/UI best practices, row-level security (RLS), and performance tuning for large datasets.
• Hands-on Scripting & Coding Capabilities: Proficiency in SQL and scripting languages (such as Python) to develop, debug, and optimize data transformation logic within the ELT layer.
• Requirements Gathering & Facilitation: Proven ability to lead cross-functional discovery sessions, facilitate discussions with engineering, IT, and executive stakeholders, and reconcile technical limitations with business desires.

Specific Requirements

• Stakeholder Consultation & Discovery: Facilitate workshops with system engineers, database administrators, and business stakeholders to identify key system metrics, pain points, data sources, and desired dashboard business outcomes.
• Architecture & Design: Design the end-to-end data flow architecture-from the source system metrics, through the ETL pipeline, to the data warehouse, and finally to the visualization layer (Power BI/Tableau and Enterprise level tools like Dynatrace, etc..).
• ETL Development & Scripting: Perform hands-on scripting, database engineering, and SQL optimization to clean, aggregate, and structure system metrics into highly performance-optimized schemas.
• Dashboard Development: Build, publish, and maintain interactive dashboards that track system health, operational performance, and enterprise-aligned metrics.
• Security & Access Control: Implement proper data access controls, authentication standards, and row-level security profiles to ensure that metrics are visible only to authorized personnel.
• Tool Selection Support: Lead the evaluation, trade-off analysis, and recommendation of the optimal Business Intelligence tools (e.g., comparing Power BI vs. Tableau vs tools like Dynatrace for the specific organization environment).

Specific Deliverables

• Deliverable 1: Business Requirements & Metrics Mapping Document (BRD): A comprehensive document detailing the business goals, stakeholder feedback, defined Key Performance Indicators (KPIs), mapped system metrics, and logical data definitions.
• Deliverable 2: End-to-End System Integration & Data Flow Architecture: A technical blueprint illustrating the data journey from source systems, through the ELT staging and transformation zones, to the final visualization analytical models.
• Deliverable 3: Data Pipeline/ELT Scripts & Repository: Well-documented, production-grade scripts (SQL, Python, or ETL/ELT tool pipelines) deployed to the project's code repository to orchestrate daily or real-time metric transformations.
• Deliverable 4: BI Dashboard Mockups & Wireframes: Architectural UI/UX mockups of the proposed dashboards capturing user interactions, filter schemes, and layout prior to final development.
• Deliverable 5: Production-Ready Dashboard Solutions: Interactive BI dashboards published to the designated enterprise environment, successfully connected to the automated ETL backend.
• Deliverable 6: System Hand-off, Documentation, & Training Plan: Operational runbooks outlining the data pipeline maintenance, schema details, dashboard metric logic, and a brief walkthrough session/recording for internal administrators.

Educational Requirements

Level 5: PhD in a technical field and 2 to 5 years of related experience or Masters degree in a technical field and 5 to 10 years of related experience or Bachelors degree in a technical field and 10 to 15 years of related experience or Associates degree in a technical field and 15 to 20 years of related experience. Requires demonstrated indepth knowledge and skills in a technical specialty. Recognized as an expert in their field.

Level 6: PhD in a technical field and 5 or more years of related experience or Masters degree in a technical field and 10 or more years of related experience or Bachelors degree in a technical field and 15 or more years of related experience or Associates degree in a technical field and 20 or more years of related experience. Requires demonstrated in-depth knowledge and skills in a technical specialty. This level should be limited to a small population. Recognized as an expert in their field.

Experience Level

5 - 15 years experience