Solutions Architect

Socket.dev; Oak Ridge (TN); On-site; USD 120,000 - 150,000; Full time

Job summary

Edgewater Federal Solutions is seeking a Solutions Architect to support a federal client in Oak Ridge, TN. You will lead architecture design for end-to-end data flows, from metrics and ETL to data warehouse and visualization layers like Power BI and Tableau.

The role requires 10-15 years of experience, U.S. citizenship, and deep expertise in ELT, data modeling, and BI visualization. On-site work and security controls are essential for enterprise-grade dashboards.

Qualifications

• Bachelor's degree and 10-15 years of experience or an equivalent combination of education and experience.
• U.S. Citizenship is required per contract.
• Ability to translate high-level business goals into executive-ready KPIs and visual strategies.
• Data modeling with star/snowflake schemas in ELT data warehouses.
• Expert BI visualization with dashboard UX/UI, RLS, and performance tuning.
• Proficient in SQL and scripting languages (Python) for data transformation.

Responsibilities

• Facilitate workshops with system engineers, DBAs, and stakeholders to identify KPIs and data sources.
• Design end-to-end data flow from source metrics to the visualization layer.
• Develop SQL and scripts to clean and structure metrics into optimized schemas.
• Build and maintain dashboards tracking system health and enterprise metrics.
• Implement data access controls and row-level security.
• Lead BI tool evaluations and recommendations (Power BI, Tableau, Dynatrace).

Skills

Enterprise Architecture

Data Modeling

ELT/ETL

BI Visualization

SQL

Python

Requirements Gathering

Education

Bachelor's degree

Tools

Power BI

Tableau

Dynatrace

Job description

Overview

Edgewater Federal Solutions is seeking a Solutions Architect to support our federal client in Oak Ridge, TN.

Responsibilities

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

Qualifications

• Bachelor's degree and 10-15 years of experience or an equivalent combination of education and experience.
• U.S. Citizenship is required per contract.
• Enterprise Architecture & Business Acumen: Ability to translate high-level business goals and complex system metrics into actionable, executive-ready KPIs and visualstrategies.
• 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 (Power BI, 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 withinthe 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.

About Us:

Edgewater Federal Solutions is a privately held government contracting firm located in Frederick, MD. The company was founded in 2002 with the vision of being highly recognized and admired for supporting customer missions through employee empowerment, exceptional services and timely delivery. Edgewater Federal Solutions is ISO 9001, 20000-1, 270001 certified, appraised at CMMI Level 3 Maturity for Development and Services, and has been named in the Top Workplaces in the Greater Washington Area Small Companies for 2018 through 2025.

It has been and continues to be the policy of Edgewater Federal Solutions to provide equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, marital status, veteran status, and/or other statuses protected by applicable law.