Solutions Architect

ROI Services LLC; Oak Ridge (TN); Remote; USD 140,000 - 210,000; Full time

Job summary

ROI Services LLC seeks a fully remote Solutions Architect to design, build, and govern robust data, observability, and reporting architectures. The role bridges IT operations with enterprise strategy and requires extensive experience across Grafana and BI platforms.

You will lead dashboards, migrations, secure data pipelines, and governance, while coordinating with cross-functional teams. Occasional travel to ORNL may be required.

Qualifications

• Bachelor's degree in a technical discipline with 15+ years of relevant experience or equivalent substitutions accepted in lieu of a degree.
• Hands-on Grafana administration with production experience on at least one other platform (Power BI, Tableau, Dynatrace, Datadog).
• Advanced SQL proficiency across enterprise databases with query tuning experience.
• Working knowledge of BI data governance, semantic models, and secure credential management.
• Proficiency with API troubleshooting tools (curl, Postman) and remote server administration.

Responsibilities

• Translate IT operations requirements into actionable metrics and system integration patterns.
• Build Grafana dashboards and lead evaluations or migrations to platforms like Dynatrace, Datadog, Power BI, or Tableau.
• Design and maintain secure ETL/ELT pipelines, semantic models, and dimensional schemas.
• Implement data governance controls, row/column-level security, least-privilege access, and lineage tracking.
• Manage Linux data collection scripts (cron, systemd) and remote server access (SSH/RDP).
• Integrate REST APIs and resolve complex connectivity and authentication issues (proxies, TLS, OAuth, Kerberos).

Skills

Grafana administration

SQL proficiency

BI governance

API troubleshooting

Education

Bachelor's degree in a technical discipline

Tools

Power BI

Tableau

Dynatrace

Datadog

SQL Server

Oracle

MySQL

Job description

We are seeking a fully remote Solutions Architect to design, build, and govern robust data, observability, and reporting architectures, bridging IT operations and enterprise strategy.

Key Responsibilities:

• Architecture & Design: Translate IT operations requirements into actionable metrics and system integration patterns.
• Dashboarding & Migration: Build enterprise Grafana dashboards and lead evaluations or migrations to platforms like Dynatrace, Datadog, Power BI, or Tableau.
• Data Pipelines: Design and maintain secure ETL/ELT pipelines, semantic models, and dimensional schemas.
• Governance & Security: Implement data governance controls, row/column-level security, least-privilege access, and lineage tracking.
• Infrastructure & Scripting: Manage Linux data collection scripts (cron, systemd) and remote server access via SSH/RDP.
• Integrations & Troubleshooting: Integrate REST APIs and resolve complex connectivity and authentication issues (proxies, TLS, OAuth, Kerberos).

Knowledge, Skills, and Abilities (KSAs):

• Hands-on Grafana administration plus production experience with at least one alternative platform (Power BI, Tableau, Dynatrace, Datadog).
• Advanced SQL proficiency across enterprise databases (SQL Server, Oracle, MySQL) with query tuning experience.
• Working knowledge of BI data governance, semantic models, and secure credential management.
• Proficiency with API troubleshooting (curl, Postman) and remote server administration.

Preferred Qualifications:

• Production experience across multiple BI/observability platforms.
• RHEL administration in hardened environments (STIG, SELinux).
• Scripting expertise in Python, Bash, or PowerShell.
• Background in regulated/restricted environments (NIST 800-53 / FISMA) and enterprise data sources (SAP, VMware, ServiceNow, Splunk).

Education & Experience:

• Minimum of a Bachelor's degree in a technical discipline with 15+ years of relevant experience (equivalent education and professional experience substitutions accepted in lieu of a degree).

Clearance:

• DOE-Q and/or Top Secret Clearance is preferred. The ability to obtain one is required

Travel/Work Model:

• This role is fully remote with OCCASIONAL travel to Oak Ridge National Laboratory (ORNL). The travel will be reimbursed when required.