Solutions Architect

RayTek Federal Corporation; Oak Ridge (TN); Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health insurance

Remote flexibility

401(k) match

Job summary

RayTek Federal Corporation seeks a Senior-Level Solutions Architect to design end-to-end data flow, ELT pipelines, and executive dashboards (Power BI/Tableau).

The role involves hands-on SQL/Python scripting, architecture of system metrics, and facilitating stakeholder workshops in a hybrid Oak Ridge, TN setting.Required capabilities include enterprise data modeling, dashboard development, and cross-functional leadership.

Qualifications

• PhD with 2+ years related experience or equivalent.
• Advanced knowlege of data modeling for ELT in modern warehouses.
• Expert BI tooling experience and dashboard UX/UI best practices.
• Proficiency in SQL and Python for ELT transformations.
• Ability to lead cross-functional sessions with executives and engineers.

Responsibilities

• Facilitate workshops with engineers, DBAs, and stakeholders to identify key metrics and dashboards.
• Design end-to-end data flow from source to visualization.
• Write and optimize ELT scripts; build optimized schemas.
• Publish and maintain interactive dashboards tracking system health and performance.
• Implement data access controls and row-level security.
• Evaluate BI tools and provide recommendations for the environment.
• Deliver required architecture blueprints, data flow documents, and hand-off materials.

Skills

Data modeling

BI tools

SQL

Python

Leadership

Stakeholder facilitation

ELT pipelines

Dashboard design

US Citizenship

Education

PhD in technical field

Master's degree in technical field

Bachelor's degree in technical field

Associate's degree in technical field

Tools

Power BI

Tableau

Dynatrace

SQL tooling

Job description

Oak Ridge, United States | Posted on 08/13/2026

RayTek is seeking a Senior-Level Solutions Architect to design and implement innovative solutions that address complex business requirements and lead multiple high-priority, high-complexity projects. This role will architect the end-to-end flow of enterprise system metrics — from source systems, through ELT pipelines, into production-ready, executive-facing BI dashboards — and will analyze existing systems and dependencies to inform process improvement and system infrastructure decisions. The ideal candidate brings deep expertise in enterprise data architecture, ELT pipeline design, and BI dashboard development (Power BI/Tableau), along with hands-on SQL/Python scripting ability and strong stakeholder facilitation skills. This position will be full-time and will be a combination of onsite and offsite in Oak Ridge, TN. Travel will be on an as-needed basis.

Key Responsibilities

• Facilitate workshops with system engineers, database administrators, and business stakeholders to identify key system metrics, pain points, data sources, and desired dashboard business outcomes.


• Design the end-to-end data flow architecture — from source system metrics, through the ETL pipeline, to the data warehouse, and into the visualization layer (Power BI/Tableau and enterprise tools such as Dynatrace).


• Perform hands-on scripting, database engineering, and SQL optimization to clean, aggregate, and structure system metrics into performance-optimized schemas.


• Build, publish, and maintain interactive dashboards that track system health, operational performance, and enterprise-aligned metrics.


• Implement data access controls, authentication standards, and row-level security (RLS) profiles to ensure metrics are visible only to authorized personnel.


• Lead evaluation, trade-off analysis, and recommendation of optimal BI tools (e.g., Power BI vs. Tableau vs. Dynatrace) for the organization's environment.


• Deliver a Business Requirements & Metrics Mapping Document, system integration/data flow architecture blueprint, documented ELT scripts and repository, dashboard mockups/wireframes, production-ready dashboards, and system hand-off documentation/training materials.

Requirements

Minimum Qualifications

Education

• PhD in a technical field with 2 or more years ofrelated experience OR;


• Master's degree in a technical field with 5 or moreyears of related experience OR;


• Bachelor's degree in a technical field with 10 or moreyears of related experience OR;


• Associate's degree in a technical field with 15 or moreyears of related experience

Experience, Knowledge, Skills and Abilities

• US Citizenship is required


• Demonstrated in-depth knowledge and skills in a technical specialty; recognized as an expert in their field.


• Advanced knowledge of data modeling (star schemas, dimensional modeling) tailored for ELT frameworks within modern data warehouses.


• Expert-level proficiency with Power BI, Tableau, or equivalent BI tools, including dashboard UX/UI best practices, row-level security (RLS), and performance tuning for large datasets.


• Proficiency in SQL and scripting languages (such as Python) to develop, debug, and optimize ELT transformation logic.


• Proven ability to lead cross-functional discovery sessions and facilitate discussions with engineering, IT, and executive stakeholders.


• Ability to translate high-level business goals and complex system metrics into executive-ready KPIs and visual strategies.


• Hybrid position based in Oak Ridge, TN, combining onsite and offsite work.


• Travel required on an as-needed basis.


• This is a one-year contract with the possibility of a one-year extension.


• No security clearance is required for this role.

RayTek Employee Benefits Highlights

Health and Wellness

• UnitedHealthcare PPO with 100% preventive care


• 24/7 telemedicine & behavioral health access


• Exercise reimbursement up to $360 per year


• Employer HSA match up to $1,200 (individual) or $2,400 (family) annually


• 401(k) plan with immediate eligibility and 100% vesting


• Employer 401(k) match up to 4% after 1 year


• Company-paid Life & AD&D (up to $100,000)


• Long-Term Disability: up to $8,000 monthly

Work-Life Balance

• 11 paid federal holidays (may vary by program)


• Remote flexibility for eligible positions

Employee & Family Support

• Day-one eligibility for all benefits


• Dependent coverage up to age 26


• Employee Assistance Program (EAP) – confidential counseling, legal, and financial support


• Travel Assistance Program – emergency medical, evacuation, and global support


• Referral, commendation, and milestone service bonuses