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

Spectra Tech, Inc. is committed to hiring and retaining a diverse workforce. We are an Equal Employment Opportunity (EEO) employer. It is the policy of the Company to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information. We are also an E-Verify employer.