SSIS, SSAS, SSRS, MSBI

Join a high-impact data and analytics team where you’ll lead the design and delivery of trusted BI solutions that help stakeholders make faster, smarter decisions. In this role, you’ll work hands-on with the Microsoft BI stack to build reliable data pipelines, semantic models, and insightful reports that translate complex data into clear business outcomes. You’ll collaborate closely with data engineers, analysts, and business partners to understand requirements, improve data quality, and optimize performance across the BI ecosystem. If you enjoy owning end-to-end delivery, mentoring teammates, and continuously improving how data is modeled, processed, and presented, this is a great opportunity to grow your leadership while building scalable, enterprise-grade BI solutions. Technical Requirements: Primary skills:Technology->Business Intelligence - Analytics->MSBI (SSAS) Technology->Business Intelligence - Reporting->MSBI (SSRS) Technology->SQL SSIS->SQL Server Responsibilities: Key Responsibilities: • Lead end-to-end development and support of MSBI solutions using SSIS, SSAS, and SSRS across multiple subject areas. • Design, develop, and optimize SSIS ETL packages including data extraction, transformation, loading, scheduling, and error handling. • Build and maintain SSAS tabular/multidimensional models, measures, KPIs, hierarchies, and partitions aligned to business reporting needs. • Develop SSRS reports, datasets, and subscriptions; ensure report accuracy, usability, and performance. • Write and tune complex SQL queries, stored procedures, and views to support ETL and reporting workloads. • Perform performance tuning for ETL, cube/model processing, and reporting; analyze bottlenecks and implement improvements. • Drive requirement discussions with stakeholders, convert needs into technical designs, and ensure timely, quality delivery. • Implement data validation, reconciliation checks, and monitoring to improve reliability and data quality. • Provide technical guidance, code reviews, and mentoring to team members; promote best practices and standards. • Support production deployments, troubleshooting, and root-cause analysis with clear documentation and communication. Minimum Qualifications: • BTECH, MTECH, MCA, or MSC. • 5–8 years of experience delivering BI solutions using SSIS, SSAS, SSRS, and MSBI. • Strong hands-on expertise in SQL including query writing, optimization, and database objects (views, stored procedures). • Proven experience building ETL workflows in SSIS with robust logging, error handling, and scheduling. • Experience developing SSAS models and SSRS reports with a focus on performance and correctness. • Working knowledge of Python for data processing, automation, or integration tasks supporting BI delivery. Preferred Skills: Technology->SQL SSIS->SQL Server,Technology->Business Intelligence - Reporting->MSBI (SSRS),Technology->Business Intelligence - Analytics->MSBI (SSAS)