Translate business and technical requirements into an architectural blueprint to achieve business objectives.
Develops a thorough understanding of and validate/assess business and technical requirements, BI infrastructure, architecture, standards and processes, related to the project.
Ability to define high level roadmap and strategy for a data platform.
Collaborate with client teams to produce optimal architecture and designs.
Reviews ETL & BI technology options to ensure right tools are leveraged for the right purpose.
Develop architecture supporting end to end Data integration process using ETL and ELT using Structured, semi-structured and Un-structured Data.
Develop proof of concept prototypes for next-generation data platform solutions.
Develop and design of models for complex analytical and data warehouse systems including performing tasks related to database design, data analysis, data quality, metadata management and support.
Ensure data platform design follows the prescribed reference architecture and framework; Ensure design reflects appropriate business rules, and facilitates data integration, data conformity and data integrity.
Engaging with the customer’s business and technology stakeholders to consult , course correct and realize the vision of data-driven enterprise in their environment using appropriate best practices and reference.
Should have 10+ years of experience in providing end to end solution in Data Warehouse / Data Lake implementation.
Minimum 3+ years of experience in Azure cloud services.
Should have achieved One of the Azure Data track certifications (At least Associate Level).
Extensive hands on experience in modern data platform – data lake, data warehousing design, tuning and ETL/ELT process development on Azure in distributed computing , enterprise environment.
Expertise in Azure services such as Azure Synapse Analytics, Azure Analysis Services, Azure Data Factory, Azure Data Lake, Azure Data Catalog, Azure Purview, Event Hubs, HDInsight, Power BI, Cloud databases like Cosmos DB.
Assess and optimize customer’s Azure implementations.
Helping customers to migrate from their existing on-premises data warehouses to cloud.
Understands data governance and related azure services with specific focus on security and regulations like GDPR.
Understanding of database and analytical technologies in the industry including MPP and NoSQL databases, Data Warehouse design, ETL, BI reporting and Dashboard development.
Strong knowledge on various Design Patterns in DW / BI environment.
Knowledge of ML, MLOps and experience creating ML solutions and delivering those using Azure ML services will be added advantage.