Solutions Architect

Edgewater Federal Solutions; Oak Ridge (TN); On-site; USD 140,000 - 190,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 workshops with engineers and stakeholders to define metrics and data sources, and design a complete data flow from ETL pipelines to dashboards using Power BI/Tableau.

You will implement data modeling, ELT optimization, and security controls, while evaluating BI tools (Power BI, Tableau, Dynatrace) for enterprise use.

Qualifications

• Bachelor's degree in a related field or equivalent combination of education and experience.
• Extensive experience designing and implementing end-to-end data flows and BI architectures.
• Proven ability to translate business goals into KPIs and visual strategies.

Responsibilities

• Stakeholder workshops to identify metrics, data sources, and dashboard outcomes.
• Design end-to-end data flow from source to visualization layer (Power BI/Tableau).
• Develop and optimize ELT processes and SQL for performance.
• Build, publish, and maintain interactive dashboards tracking system health.
• Implement data access controls and row-level security.
• Evaluate BI tools and recommend best-fit solutions for the environment.

Skills

Stakeholder consultation

Architecture & design

ETL development

Dashboard development

Security & access control

Tool selection

Data modeling

BI & data visualization

Scripting & coding

Requirements gathering

Education

Bachelor's degree or equivalent

10-15 years of experience or equivalent

Tools

Power BI

Tableau

Dynatrace

SQL

Python

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

About Us

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.