Solutions Architect

Edgewater Federal Solutions, Inc. • Oak Ridge, TN

14h • Onsite

About The Position

Edgewater Federal Solutions is seeking a Solutions Architect to support our federal client in Oak Ridge, TN. This role involves stakeholder consultation, architecture and design of data flow, ETL development, dashboard creation, security implementation, and tool selection support.

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.
• Ability to translate high-level business goals and complex system metrics into actionable, executive-ready KPIs and visual strategies.
• Advanced knowledge of modeling data (e.g., star schemas, dimensional modeling) tailored specifically for Extract, Load, Transform (ELT) frameworks within modern data warehouses.
• 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.
• Proficiency in SQL and scripting languages (such as Python) to develop, debug, and optimize data transformation logic within the ELT layer.
• 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