Solution Architect - Data Engineering

Key Responsibilities

Strategy & Planning

• Define enterprise data platform vision and roadmap integrating Snowflake, dbt, and AtScale
• Design target-state architecture emphasizing scalability, performance, availability, and cost efficiency
• Establish data governance, security, and compliance strategies (GDPR, HIPAA, SOX)
• Define data quality, testing, and observability frameworks
• Develop platform cost management and chargeback strategies
• Set architectural standards for integration, data flow, and lineage

Delivery & Execution

• Architect and implement end-to-end data pipelines from source to Snowflake, using dbt for transformation and AtScale for semantic modeling
• Design and deploy Snowflake warehouse configurations, query optimization, and resource governance
• Implement dbt development standards, modular models, testing frameworks, and CI/CD pipelines
• Enable high-performance analytics through aggregate tables, caching, and optimized BI integrations
• Implement security controls including role-based access, masking, encryption, and audit logging
• Build monitoring, alerting, backup, and disaster recovery mechanisms

Support & Enablement

• Facilitate self-service analytics and governed data sharing for BI tools (Tableau, Power BI)
• Provide operational oversight including performance monitoring and issue resolution
• Support AI/ML workloads by advising on data access, feature readiness, and performance requirements
• Establish SLA monitoring, reporting, and incident response processes
• Drive continuous optimization for query performance and cost efficiency
• Create and maintain architecture documentation, runbooks, and best-practice guidelines

People Leadership

• Mentor data engineers and analysts on best practices, performance optimization, and platform standards
• Lead architectural review forums and design discussions
• Collaborate with DevOps, Security, and Infrastructure teams for automation, deployment, and governance alignment
• Communicate architectural decisions, trade-offs, and recommendations to stakeholders