• 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).
• Harness 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.

Bachelor’s degree in computer science, engineering, or related field5+ years of hands-on experience in data warehousing, BI development, or related roles, with a proven track record of successfully managing complex projects and large volumes of data using Microsoft technologies.Proficiency in Microsoft SQL Server Integration Services (SSIS) for ETL development and automation, particularly in the context of handling substantial datasets and intricate project requirements.Extensive experience with Microsoft SQL Server Analysis Services (SSAS), adept at architecting and implementing robust data models capable of accommodating the complexities of large-scale data analysis.Strong skills in Microsoft SQL Server Reporting Services (SSRS) and MS Power BI, demonstrating proficiency in developing impactful reports and visualizations, as well as leveraging AI capabilities for enhanced insights.Preferred Experience with AI technologies and machine learning within the context of BI solutions preferred, showcasing the ability to integrate AI-driven analytics to provide predictive and prescriptive insights.Exceptional SQL skills for data manipulation, querying, and optimization, essential for efficiently managing and processing vast amounts of data within the context of complex projects.In-depth understanding of data warehousing concepts, dimensional modeling, and data governance principles, crucial for designing and implementing scalable solutions capable of meeting the demands of large-scale data processing.Excellent communication skills and a collaborative mindset, essential for effectively engaging with stakeholders and navigating the challenges inherent in managing complex projects with extensive datasets.