What are the responsibilities and job description for the Solutions Architect position at Spectra Tech, Inc.?
*Job Description:
Knowledge, Skillset, and Abilities (KSAs) -
* 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 (PowerBI, 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.
Specific Requirements -
* 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).
Specific Deliverables -
* Deliverable 1: Business Requirements & Metrics Mapping Document (BRD): A comprehensive document detailing the business goals, stakeholder feedback, defined Key Performance Indicators (KPIs), mapped system metrics, and logical data definitions.
* Deliverable 2: End-to-End System Integration & Data Flow Architecture: A technical blueprint illustrating the data journey from source systems, through the ELT staging and transformation zones, to the final visualization analytical models.
* Deliverable 3: Data Pipeline/ELT Scripts & Repository: Well-documented, production-grade scripts (SQL, Python, or ETL/ELT tool pipelines) deployed to the project's code repository to orchestrate daily or real-time metric transformations.
* Deliverable 4: BI Dashboard Mockups & Wireframes: Architectural UI/UX mockups of the proposed dashboards capturing user interactions, filter schemes, and layout prior to final development.
* Deliverable 5: Production-Ready Dashboard Solutions: Interactive BI dashboards published to the designated enterprise environment, successfully connected to the automated ETL backend.
* Deliverable 6: System Hand-off, Documentation, & Training Plan: Operational runbooks outlining the data pipeline maintenance, schema details, dashboard metric logic, and a brief walkthrough session/recording for internal administrators.
*Educational Requirements:
Level 5: PhD in a technical field and 2 to 5 years of related experience or Masters degree in a technical field and 5 to 10 years of related experience or Bachelors degree in a technical field and 10 to 15 years of related experience or Associates degree in a technical field and 15 to 20 years of related experience. Requires demonstrated indepth knowledge and skills in a technical specialty. Recognized as an expert in their field.
Level 6: PhD in a technical field and 5 or more years of related experience or Masters degree in a technical field and 10 or more years of related experience or Bachelors degree in a technical field and 15 or more years of related experience or Associates degree in a technical field and 20 or more years of related experience. Requires demonstrated in-depth knowledge and skills in a technical specialty. This level should be limited to a small population. Recognized as an expert in their field.
*Experience Level:
5 - 15 years experience
Spectra Tech’s policy is to give equal opportunity to all qualified persons without regard to race, color, religion, sex, age, national origin, individuals with a disability, genetic information, sexual orientation, protected veteran status, or any other basis prohibited by applicable law.