SSIS, SSAS, SSRS, MSBI

Infosys

5–8 yrs Pune Full Time Work from office
Infosys logo
Posted : today
Actively hiring

Job description

Join a dynamic data and analytics team focused on delivering impactful BI solutions that empower stakeholders with data-driven decision-making. This role offers a hands-on opportunity to leverage the Microsoft BI stack for building robust data pipelines, creating insightful semantic models, and developing clear, actionable reports. You'll collaborate with cross-functional teams to enhance data quality and optimize the overall BI landscape. If you thrive on end-to-end ownership, enjoy mentoring others, and are passionate about advancing data modeling, processing, and presentation, this is an excellent platform for leadership growth and building scalable enterprise BI solutions.

Responsibilities

- Lead the full lifecycle development and support of MSBI solutions (SSIS, SSAS, SSRS) across various business domains. - Design, build, and refine SSIS ETL packages, managing data extraction, transformation, loading, scheduling, and error management. - Develop and maintain SSAS tabular/multidimensional models, including measures, KPIs, hierarchies, and partitions to meet business reporting demands. - Create and manage SSRS reports, datasets, and subscriptions, ensuring accuracy, usability, and optimal performance. - Craft and optimize complex SQL queries, stored procedures, and views to support ETL and reporting functions. - Conduct performance tuning for ETL processes, cube models, and reports, identifying and resolving bottlenecks. - Facilitate requirement discussions with stakeholders, translating needs into technical designs for timely and high-quality delivery. - Implement data validation, reconciliation checks, and monitoring mechanisms to enhance data reliability and quality. - Provide technical direction, conduct code reviews, and mentor team members, championing best practices and standards. - Support production deployments, troubleshoot issues, and perform root-cause analysis with clear documentation and effective communication.

Qualifications

- Possess a BTECH, MTECH, MCA, or MSC degree. - Hold 5-8 years of experience in delivering BI solutions using SSIS, SSAS, SSRS, and MSBI. - Demonstrate strong, hands-on expertise in SQL, including query writing, optimization, and database object development (views, stored procedures). - Proven experience in building SSIS ETL workflows with robust logging, error handling, and scheduling capabilities. - Experience in developing SSAS models and SSRS reports with a focus on performance and accuracy. - Working knowledge of Python for data processing, automation, or integration tasks within BI delivery.

Preferred skills include experience with dimensional data modeling, troubleshooting across BI layers, utilizing Python libraries like Pandas, exposure to version control and release practices for BI assets, and demonstrated leadership in coordinating deliveries and collaborating with stakeholders.

Essential Skills

SSISSSASSSRSMSBISQLPython

Good to Have

Pandasdimensional data modelsstar schemasnowflake schemaversion controlrelease practices

Highlights

  • Actively hiring

More Details

RoleSSIS, SSAS, SSRS, MSBI
DepartmentData & Analytics
Employment TypeFull Time, Work from office

About the Company

Infosys logo

Infosys

IT Consulting

SSIS, SSAS, SSRS, MSBI at Infosys | SkillMX | SkillMX