What are the responsibilities and job description for the AI Data Warehouse Architect position at AVATAR IT Solutions Inc.?
My client is seeking a Senior Solution Architecture Lead with detailed knowledge and experience in Artificial Intelligence (AI), Cloud Platforms, Advanced Data Analytics, and Data Warehouse Systems. The consultant will serve as the principal system architect and subject matter expert responsible for designing, validating, and implementing scalable, secure, and robust enterprise technology solutions across multiple business areas.
The consultant will lead concurrent AI, cloud, analytics, and data warehouse initiatives while ensuring all solutions align with enterprise architecture standards, cybersecurity requirements, and business objectives. The ideal candidate will act as a trusted advisor to executive leadership, business stakeholders, and technical teams.
Minimum Technical Qualifications
1. A minimum of ten (10) years of IT experience with expert-level skills in enterprise architecture design, data modeling, and implementation for data warehouse systems and advanced data analytics platforms.
2. A minimum of five (5) years of experience designing architecture that integrates Generative AI capabilities into Business Intelligence and Data Warehouse platforms.
3. At least five (5) years of cloud architecture experience (such as Azure, AWS, or Google Cloud Platform), including deployment strategies and the use of infrastructure-as-code tools such as Terraform.
4. At least five (5) years of experience leading cross-functional technical teams, providing mentorship, and driving technical excellence in complex enterprise environments.
5. Five or more (5 ) years of experience in designing and implementing secure, scalable integration architectures for complex enterprise environments, including APIs, microservices, event-driven systems, and data integration.
Desirable Technical Qualifications
1. Five or more (5 ) years of hands-on experience with C# / Python, SQL databases, and advanced SQL queries.
2. Five or more (5 ) years of experience developing comprehensive technical documentation, including architecture diagrams, design specifications, standards, and best‑practice guidelines for enterprise‑scale systems.
3. Three or more (3 ) years of experience with Snowflake or AWS Redshift.
4. Three or more (3 ) years of experience of using Power BI to create data analytics dashboards.
Salary : $75 - $95