Senior BI Developer - SSRS/SSIS

Profile : - Senior BI Developer Experience : - 5 to 15 years Location : - Mumbai (Goregaon on-site) Timing : - 12 : 30 PM to 9 : 30 PM Salary : - Up to 29 LPA Must Have : - SSIS - SSRS - SQL - Power BI Responsibilities : - Design and develop data ETL routines to integrate data from disparate source systems into an integrated business intelligence environment including defining source-to-target mappings, business rules and other required data transformations - Develop dashboards and reports using Microsoft Power BI, SSRS or other BI technologies. - Ensuring the quality of the data through utilization of process and technology - Participation in actively formulating and maintaining both a data catalog and a data dictionary - Providing data marts and data lakes to support business initiatives - Conduct business analysis to define the required data to fulfill on business requirements - Meet with Customers to understand business problems and questions, exploring options to model data driven platforms used for analyzing answers - Become a trusted partner for Customers who translates business problems into analysis; then helps interpret the analysis into actionable steps - Actively participate in the design, development, and maintenance of complex BI Dashboards, Reports, Queries, and integrated applications - Manage other resources to complete the development work needed to deliver the required product to the client - Analyze and share results with users to ensure content meets business requirements; and train users to facilitate adoption and understanding of BI reports and tools - Proactively initiate projects and analysis targeting opportunities for revenue growth, risk mitigation, and operational efficiency - Provide technical support of the Microsoft Platform Software - Comprehensive data analysis and design experience, with full knowledge of data warehouse & data mart methodologies as well analysis modeling - Lead solution and design sessions for end to end for data integration efforts - Deliver technical innovations in support of business growth; progressing ideas from concepts to full scale implementation with focus on flexibility, reuse, and overarching extensibility. Requirements : - 3-5 years of experience in the Microsoft business intelligence platform, including SQL Server databases, SQL Server Integration Services, Power BI/SSRS & SSAS and/or Azure Cloud Services - 3-5 years of building and maintaining data integration processes - 2-3 years supporting large scale data integration and ETL processes including daily monitoring and operational support - Strong experience working in data warehouse architectures - Experience building formatted paginated reports using MS SSRS - Experience with PowerBI dashboard development or experience with one or more BI reporting tools like QlikView/QlikSense, Tableau, Micro Strategy, Open Source reporting is a plus - Experience with the PowerBI Cloud Services - Significant experience in the design and development of data integration solutions and data analysis - Expert in automating data integration routines - Expert in optimization of data integration processing and database design - Expertise in designing and developing dashboards, reports, analytics and data visualization solutions. - Experience in creating dimensional data models across multiple subject areas is a plus - Strong command of MS Excel - Experience and familiarity with processes, platforms, and stakeholders - Excellent written and oral communication skills - Excellent technical documentation skills - Ability to work independently in a fast paced environment with minimum over sight. You would own building a future proof integration architecture to solve integration needs across projects. - Balances a variety of competing goals in a design, including project time, scope and budget constraints, and system performance, message verbosity, and loose coupling. (ref:hirist.tech)

Location: Mumbai, IN

Posted Date: 4/24/2024