Solutions Architect

• 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

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

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

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

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

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

Benefits

RayTek Employee Benefits Highlights

Health and Wellness

• UnitedHealthcare PPO with 100% preventive care
  
• 24/7 telemedicine & behavioral health access
  
• Dental PPO ($1,500 max) & Vision plan ($10 exams, $150 frame allowance)
  
• Exercise reimbursement up to $360 per year
  

Financial Security

• 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)
  
• Short-Term Disability: 60% pay / $1,000 weekly
  
• 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