Solutions Architect

RayTek Federal Corporation • Oak Ridge, TN

9d • $160,000 - $200,000 • Hybrid

About The Position

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.

Requirements

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

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.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Ph.D. or professional degree