SSIS, SSAS, SSRS, MSBI

Job Description:

• 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

Key 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

Technical Requirements:

• Primary skills Technology Business Intelligence Analytics MSBI SSAS
• Technology Business Intelligence Reporting MSBI SSRS
• Technology SQL SSIS SQL Server

Additional Responsibilities:

• Preferred Qualifications
• Experience designing dimensional data models star snowflake and applying BI best practices for analytics ready datasets
• Strong troubleshooting skills across ETL semantic models and reporting layers with a structured approach to root cause analysis
• Experience with Python libraries for data handling and automation e
• g
• Pandas to complement BI workflows
• Exposure to version control and release practices for BI assets ability to maintain clean reusable well documented code
• Demonstrated leadership in coordinating deliveries improving team standards and collaborating effectively with business stakeholders

Preferred Skills:

Technology->SQL SSIS->SQL Server,Technology->Business Intelligence - Reporting->MSBI (SSRS),Technology->Business Intelligence - Analytics->MSBI (SSAS)