Solutions Architect

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 tothe visualization layer (Power BI/Tableau andenterprise-leveltools like Dynatrace, etc..).ETL Development & Scripting: Perform hands-on scripting, database engineering, and SQL optimization to clean, aggregate, and structure system metrics into highlyperformance-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 toauthorized 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 vstools 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 KeyPerformance 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 stagingand transformation zones, to the final visualizationandanalytical models. Deliverable 3:Data Pipeline/ELT Scripts & Repository: Well-documented, production-grade scripts (SQL, Python, or ETL/ELT tool pipelines) deployed to the project'scode 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 layoutprior to final development. Deliverable 5:Production-Ready Dashboard Solutions: Interactive BI dashboards published to the designated enterprise environment, successfully connected to theautomated ETL backend. Deliverable 6:System Hand-off, Documentation, & Training Plan: Operational runbooks outlining the data pipeline maintenance, schema details, dashboard metriclogic, and a brief walkthrough session/recording for internal administrators.