What are the responsibilities and job description for the Data and AI Solution Architect(Only W2) position at Aaura Softwares?
Job Title: Data and AI Solution Architect
Location: Dallas, TX (onsite required for the first week of the project)
Duration: long term contract
Only W2
Roles and Responsibilities:
- Expertise in Snowflake architecture, including secure and scalable single-tenant and multi-tenant designs.
- Strong knowledge of data mesh, lakehouse, and medallion architecture patterns for enterprise-scale platforms.
- Ability to integrate Snowflake with Azure services (Data Lake Storage, Event Grid, Service Bus, Purview, Power BI, Fabric).
- Proficiency in data security frameworks, including encryption, masking, and governance.
- Excellent communication and stakeholder alignment skills, with experience in documentation using C4 and ArchiMate.
Requirements:
- 12 years in data architecture and solution design, with 3 years of hands-on Snowflake experience.
- Proven experience in Databricks-to-Snowflake migration and working within the Azure ecosystem.
- Familiarity with CI/CD pipelines, Infrastructure as Code (Terraform/Bicep), and modern cloud-native compute (Functions, AKS, Container Apps).
- Strong understanding of Control Plane vs. Operations (Data) Plane and modern data architecture principles.
- Preferred certifications: Azure Architect, SnowPro, TOGAF, or CDMP.