Solutions Architect

Edgewater Federal Solutions • Oak Ridge, TN

5d • Onsite

About The Position

Edgewater Federal Solutions is seeking a Solutions Architect to support our federal client in Oak Ridge, TN. This role involves facilitating workshops with stakeholders to identify key system metrics and pain points, designing end-to-end data flow architecture, performing hands-on scripting and SQL optimization for data transformation, building interactive dashboards, implementing security and access controls, and supporting the selection of Business Intelligence tools.

Requirements

• 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 visual strategies.
• 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 within the 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.

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 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..).
• Perform hands-on scripting, database engineering, and SQL optimization to clean, aggregate, and structure system metrics into highly performance-optimized schemas.
• Build, publish, and maintain interactive dashboards that track system health, operational performance, and enterprise-aligned metrics.
• Implement proper data access controls, authentication standards, and row-level security profiles to ensure that metrics are visible only to authorized personnel.
• 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).

What This Job Offers

• Job Type: Full-time
• Career Level: Senior