<p><p><b>Job Title : </b> Lead ADF - Microsoft BI & Data Warehouse Lead</p><br/><p><b>Skills : </b> Minimum 6+Years into <b>ADF in ETL</b>, Microsoft BI, DW, T-SQL / SQL, procedure writing, Azure/SQL</p><br/><p><b>Job Description : (Azure Cloud - API Cloud Integration is Mandate) with 3+Years </b></p><br/><p>Overview : </p><p><br/></p><p> We are looking for an experienced Microsoft BI & Data Warehouse Lead to design, develop, and maintain robust data warehouse and ETL solutions using the Microsoft technology stack.
The ideal candidate will have extensive expertise in SQL Server development, Azure Data Factory (ADF), and other Microsoft-based data integration tools such as Azure Functions, and other related tools.</p><br/><p>As a lead, he will play a crucial role in driving data strategy, ensuring system performance, and delivering scalable data solutions that meet organizational needs.</p><br/><p><b>Responsibilities : </b></p><br/><p>Data Warehouse Development : </p><br/><p>- Design and implement scalable and efficient data warehouse solutions.</p><br/><p>- Develop complex SQL Server-based solutions, including T-SQL queries, stored procedures, and performance tuning.</p><br/><p>- Optimize SQL Server databases, develop T-SQL scripts, and improve query performance.</p><br/><p>ETL Development and Maintenance : </p><br/><p>- Build and optimize ETL workflows using Azure Data Factory (ADF) for data integration from multiple sources.</p><br/><p>- Ensure high-performance data pipelines for large-scale data processing.</p><br/><p>- Integrate and automate data processes using Azure Functions to extend ETL capabilities.</p><br/><p>Cloud Integration : </p><br/><p>- Implement cloud-native solutions leveraging Azure SQL Database, Azure Functions, and Synapse Analytics.</p><br/><p>- Support hybrid data integration scenarios combining on-premises and Azure services.</p><br/><p>Data Governance and Quality : </p><br/><p>- Establish and maintain robust data quality frameworks and governance standards.</p><br/><p>- Ensure consistency, accuracy, and security of data across all platforms.</p><br/><p>Leadership and Collaboration : </p><br/><p>- Lead a team of BI and data professionals, providing mentorship and technical direction.</p><br/><p>- Partner with stakeholders to understand business requirements and deliver data-driven solutions.</p><br/><p>- Define project goals, timelines, and resources for successful execution.</p><br/><p>- Should be flexible to support multiple IT platforms</p><br/><p>- Managing Day to day activities - Jira request, SQL execution, access request, resolving alerts and updating Tickets</p><br/><p><b>Requirements : </b></p><br/><p>Education : Bachelors degree in computer science, Information Technology, or related field.
B.Tech / B.E</p><br/><p>Skills (Mandatory) (Note : list of skills needed to perform the role) : </p><br/><p>- Strong experience with SQL Server development (T-SQL, indexing, optimization).</p><br/><p>- In-depth knowledge of BI-DW concepts and data modelling.</p><br/><p>- Extensive experience with Azure Data Factory (ADF) for ETL tools</p><br/><p>- Advanced knowledge of Azure SQL Database and cloud technologies.</p><br/><p>- Excellent problem-solving, analytical, and leadership skills.</p><br/><p>- Strong communication and teamwork abilities.</p><br/><p>- Ability to translate business requirements into technical solutions</p><br/><p>- Experience with cloud-based data platforms and migrations.</p><br/><p>- Familiarity with DevOps for CI/CD in data integration pipelines.</p><br/><p>- Skills (Good to Have) (Note : list of skills that will add value to the role) : </p><br/><p>- Experience with additional cloud platforms (e.g., Azure, AWS, Google Cloud).</p><br/><p>- Advanced skills in data visualization tools (e.g., Power BI, SSRS, Tableau).</p><br/><p>- Proficiency in Python or other scripting languages.</p><br/><p>- Experience with Databricks is a plus.</p><br/><p>Certifications : </p><br/><p>- Relevant certifications in SQL, BI-DW, or cloud platforms are highly desirable.</p><br/><p>- Microsoft Certified : Azure Data Fundamentals /Any Cloud Certifications (preferred).</p><br/><p>Skills (Mandatory) (Note : list of skills needed to perform the Lead role) : Client Facing - US Based Clients - Need Strong Communication skill </p><br/></p> (ref:hirist.tech)