Solutions Architect

Overview

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

Responsibilities

• Translate Leadership and IT Operations questions and existing tools/systems output into metrics, and identify which source systems hold the data (applications, databases, APIs, monitoring tools, SaaS platforms).
• Design and build dashboards in Grafana today, and support evaluation of or migration to Dynatrace, Datadog, Power BI or Tableau.
• Build and maintain ETL/ELT pipelines and semantic models that pull data efficiently and securely from source systems.
• Apply data governance controls, including row-level and column-level security, least-privilege service accounts, data classification, retention and lineage.
• Write efficient, well-scoped queries that don’t overload source systems or expose data beyond what’s needed.
• Deploy and maintain data collection scripts on Linux servers, scheduled with cron or systemd timers.
• Troubleshoot or communicate potential issues with connectivity and authentication across proxies, TLS, firewalls and APIs.
• Document data sources, metric definitions, refresh logic and support runbooks.

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. 
• Hands-on experience building and administering Grafana dashboards, plus production experience with at least one other platform: Power BI, Tableau, Dynatrace, Datadog, etc.
• Strong SQL across enterprise databases (SQL Server, Oracle, MySQL), including query tuning and an understanding of source-system impact.
• Experience with semantic models and dimensional modeling (star schemas, measures, relationships).
• Working knowledge of BI data governance: RLS, CLS, data ownership, classification, and secure credential handling.
• Experience integrating REST APIs and varied authentication methods (API tokens, OAuth/OIDC, basic auth, Kerberos/LDAP, service accounts).
• Connectivity troubleshooting with curl, including authenticated proxies, headers, tokens and TLS certificates, and with API tools such as Postman.
• Comfortable working on remote servers over SSH (including MFA-protected access) and Remote Desktop: editing configuration files, deploying and scheduling scripts with cron or systemd timers, managing services, and reading logs.

Desired: 

• Production experience with two or more of Power BI, Tableau, Dynatrace or Datadog.
• RHEL administration in hardened environments (e.g. STIG, SELinux, fapolicyd), including permissions, policy troubleshooting and certificates.
• Experience administering a BI or observability platform: upgrades, plugins/connectors, provisioning, backups.
• Scripting in Bash, PowerShell or Python.
• Experience in on-premises, restricted-network or regulated environments; familiarity with NIST 800-53 / FISMA.
• Experience with general Web Development, SAP, VMware, ServiceNow, Splunk or similar enterprise systems as data sources.

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.