Purpose of the Job:
To handle all Data/BI responsibilities, including a major part of the work on ADF and team handling.
Key Responsibilities:
- Data Warehouse Development:
- Design and implement scalable and efficient data warehouse solutions.
- Develop complex SQL Server-based solutions, including T-SQL queries, stored procedures, and performance tuning.
- Optimize SQL Server databases, develop T-SQL scripts, and improve query performance.
- ETL Development and Maintenance:
- Build and optimize ETL workflows using Azure Data Factory (ADF) for data integration from multiple sources.
- Ensure high-performance data pipelines for large-scale data processing.
- Integrate and automate data processes using Azure Functions to extend ETL capabilities.
- Cloud Integration:
- Implement cloud-native solutions leveraging Azure SQL Database, Azure Functions, and Synapse Analytics.
- Support hybrid data integration scenarios combining on-premises and Azure services.
- Data Governance and Quality:
- Establish and maintain robust data quality frameworks and governance standards.
- Ensure consistency, accuracy, and security of data across all platforms.
- Leadership and Collaboration:
- Lead a BI and data professionals team, providing mentorship and technical direction.
- Partner with stakeholders to understand business requirements and deliver data-driven solutions.
- Define project goals, timelines, and resources for successful execution.
- Should be flexible to support multiple IT platforms
- Managing day-to-day activities – Jira request, SQL execution, access request, resolving alerts, and updating Tickets