- Lead the design and development of data warehouse solutions tailored for complex projects, managing large volumes of data with Microsoft SQL Server Integration Services (SSIS) for efficient extraction, transformation, and loading (ETL).
- Hardness the power of Microsoft SQL Server Analysis Services (SSAS) to architect and implement multidimensional and tabular data models capable of handling extensive datasets, facilitating in-depth business analysis and reporting.
- Develop highly interactive reports, dashboards, and paginated reports using Microsoft SQL Server Reporting Services (SSRS) and MS Power BI to distill insights from vast datasets, leveraging advanced visualization techniques and AI capabilities to provide actionable insights.
- Drive optimization efforts for data warehouse performance and scalability, utilizing cutting-edge techniques and best practices in SSIS, SSAS, SSRS, and Power BI to ensure seamless operations in the face of complex project requirements and massive data volumes.
- Collaborate closely with business stakeholders to meticulously gather and refine requirements, translating them into actionable data solutions that align with project objectives and effectively address the challenges posed by large-scale data processing.
- Provide invaluable technical leadership and mentorship to junior team members, guiding them through the intricacies of managing complex projects and large datasets within the Microsoft BI ecosystem, while fostering their growth into proficient BI professionals.
- Proactively monitor system performance and implement robust solutions to enhance data quality, reliability, and efficiency, safeguarding the integrity and accuracy of insights derived from extensive datasets in mission-critical projects
|
