Senior Data & BI Solutions Architect

Demase-Technical-Services,-LL; Oak Ridge (TN); On-site; USD 113,000 - 120,000; Full time

Job summary

DeMase Technical Services is seeking a Solutions Architect to work on and offsite at the Y-12 site in Oak Ridge, TN. Travel may be required on an as-needed basis.

The role involves designing end-to-end data flow architectures, building dashboards in Power BI/Tableau, and implementing secure data access controls across enterprise metrics. Remote options are not specified; on-site engagement at Oak Ridge is required.

Responsibilities

• Designs and implements innovative solutions to address business requirements
• Leads multiple complex and high-priority projects
• Analyzes existing systems and dependencies to provide input on process improvement and system infrastructure
• Facilitates workshops with system engineers, database administrators, and business stakeholders to identify key system metrics, pain points, data sources, and desired dashboard business outcomes
• Designs 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.)
• Performs hands-on scripting, database engineering, and SQL optimization to clean, aggregate, and structure system metrics into highly performance-optimized schemas
• Builds, publishes, and maintains interactive dashboards that track system health, operational performance, and enterprise-aligned metrics
• Implements proper data access controls, authentication standards, and row-level security profiles to ensure that metrics are visible only to authorized personnel
• Leads 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)

Job description

DeMase Technical Services is seeking a Solutions Architect to work on and offsite at the Y-12 site in Oak Ridge, TN. Travel may be required on an as-needed basis.

The role involves designing end-to-end data flow architectures, building dashboards in Power BI/Tableau, and implementing secure data access controls across enterprise metrics. Remote options are not specified; on-site engagement at Oak Ridge is required.