Azure Data Tech Lead

Minimum experience:

• Azure Data Lake - 2 years
• Azure Synapse Analytics - 3 years
• SQL Server Data Warehouse - 8 years
• Data Modeling - 5 years

Responsibilities

• You are an expert in Azure Data Analytics having a thorough understanding of Azure Data Platform tools.
• Expertise and hands-on experience on Azure Platform including Data Factory, Synapse, Data Lake Gen2, CICD, DevOps.
• Expertise in SQL Server DB, SQL Server Data Warehouse.
• Collaborate with project stakeholders like database administrators, technical architects, business analysts, and product owners to determine project needs and plan development and implementation strategies.
• To define, design, review, and explain Data Architecture requirements to all the project stakeholders.
• Lead the migration of data from legacy systems to newly developed solution.
• To create strategies and design solutions for a wide variety of use cases like Data Migration (end-to-end ETL process), database optimization, and data architectural solutions for Analytics Data Projects.
• To design, develop and troubleshoot highly complex technical problems in OLAP/OLTP/DW, Analytics and provide solutions for Enterprise level Applications utilizing Azure Data Platform.
• To implement data quality processes for use with BI solutions, data warehouses, etc.
• Work on streamlining data flows and data models consistently.
• Have a keen focus on improving and tuning data quality, accessibility, performance, and security needs.

Skills Required

• Bachelor/ master’s degree in the technology field (preference is computer science engineering, analytics).
• Self-driven, and able to think holistically about the product roadmap.
• Performing reviews of data Architecture and Designs.
• Research new technologies and data modeling methods.
• Creative in solving complex business problems.
• Excellent written & verbal communication.
• Proficient in capturing requirements, Architect and Design solutions for Azure Data Analytics, Data Lake, Data Warehousing, ETL Projects/Products
• End-to-end implementation experience in at least ONE Project in Data Warehouse and Analytics using Azure Data platform tools.
• Proficient in the tools: Azure Data Factory, Azure Data Lake, Azure Synapse, Azure SQL DB, MS-SQL
• Lead the solution implementation for Data Warehouse projects.
• Create conceptual, logical, and physical data models for both relational and dimensional solutions.
• Effectively managing large sets of data for performance, security, and data governance viewpoint.
• Deep knowledge of a wide variety of database systems and data mining techniques.
• Experience to build and test physical data models for a variety of use cases meeting performance and efficiency goals.
• Excellent in Logical and Physical Data Modelling using data modeling tools like Erwin, Enterprise Architect, etc.
• Certifications in Architecture, Analytics, Data Science, and Cloud will be added advantages.
• Experience in Azure Functions.
• Experience with implementing metadata-driven dynamic Azure pipelines is a plus.