Azure Data Solution Architect

**About Fusemachines**

Fusemachines is a leading AI strategy, talent, and education services provider. Founded by Sameer Maskey Ph.D., Adjunct Associate Professor at Columbia University, Fusemachines has a core mission of democratizing AI. With a presence in 4 countries (Nepal, United States, Canada, and Dominican Republic and more than 400 full-time employees). Fusemachines seeks to bring its global expertise in AI to transform companies around the world.

**About the role**:
This is a remote full-time position, responsible for translation of functional and non-functional requirements, in data and analytics including data integration, storage, processing, and analytics (BI, visualization and Advanced Analytics), into a solution design (low level design), describing it through standardized design artifacts, ensuring alignment to the target architectures, principles, patterns and standards as an input for the rest of the team.

**Qualification & Experience**
- Must have a full-time Bachelor's degree in Computer Science or similar from an accredited university.
- Minimum of 5 years of industry experience with large-scale data and analytics solutions.
- At least 2 years of experience as a solution architect for data and analytics with strong expertise in Python, SQL, Pyspark, Databricks, Jupyter notebooks, Snowflake, PowerBI and Azure.
- 5+ years of experience with DevOps tools and technologies: GitHub or Azure DevOps.
- Proven experience in data modeling, management, warehousing, processing/transformation, integration, cleansing and validation.
- Proven experience in Azure Data & Analytics PaaS Services: Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure Databricks.
- Preferred Certifications:

- Microsoft Certified: Azure Fundamentals
- Microsoft Certified: Azure Data Engineer Associate
- Microsoft Certified: Azure Solutions Architect Expert
- Databricks: Azure Platform Architect
- Nice to have:

- CDMP certification
- ITIL
- TOGAF
- SAFe
- SnowPro Core Certification
- SnowPro Advanced Data Engineer
- SnowPro Advanced Architect
- Microsoft Certified: Azure AI Engineer Associate
- AWS Certified Solutions Architect - Professional

**Required skills/ Competencies**
- Experience in business processing mapping of data and analytics solutions.
- Strong programming Skills in one or more languages such as **Python** (must have hands-on experience).
- Strong understanding and experience with **SQL** and writing advanced SQL queries.
- Deep understanding of data architecture concepts, principles, techniques, and best practices, including data modeling, data management, data integration, data warehousing, business intelligence, visualization and advanced analytics (ML/AI). Being able to design and architect effective data and analytics solutions that align with business objectives and priorities:

- Proficiency in designing highly available, scalable, and resilient data solutions that can handle varying workloads and demand spikes.
- Knowledge of disaster recovery strategies and backup and restore mechanisms in Azure.
- Strong experience in designing and implementing **Data Warehousing**, data lake and data lake house, solutions in Azure, Databricks and Snowflake.
- Strong experience in designing and implementing scalable and distributed Data Processing Technologies using Spark/**PySpark** (must have hands-on experience), DBT and Kafka, to be able to handle large volumes of data.
- ** Databricks** architecture and development experience, including Delta Lake, Unity Catalog, Delta Sharing, Delta Live Tables (DLT). Experience with Azure Databricks is a plus.
- Strong experience in designing and implementing data pipelines and efficient **ELT/ETL** processes, batch and real-time, in Azure (including **Azure Data Factory**) and **Databricks** and using open source solutions being able to develop custom integration solutions as needed, including Data Integration from different sources such as APIs, databases, flat files, Apache Parquet, event streaming, including cleansing, transformation and validation of the data.
- Deep knowledge in cloud computing specifically in Microsoft Azure services related to data and analytics, such as **Azure Data Factory**, **Azure Databricks**, Azure Functions, Azure Synapse Analytics, Azure Stream Analytics, SQL Server, **Azure Blob Storage**, Azure Data Lake Storage, **Azure SQL Database**, **PowerBI,** etc.
- Experience in Orchestration using technologies like Databricks workflows and Apache Airflow.
- Deep knowledge of data analytics architecture and services, including BI (**PowerBI or Tableau**).
- Must be familiar with advanced analytics, AI/ML services and tools, and the ability to integrate advanced analytics, machine learning, and AI capabilities into data solutions. Must have experience with **Jupyter Notebooks**, and nice to have experience with any one of the languages: SAS, SPSS or R.
- Deep knowledge of data governance architecture, design and implementation, i