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 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