Solutions Architect

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.

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