5 Msbi Stack Jobs

You are an experienced ETL Developer with over 5 years of expertise in data transformation, integration, and visualization. Your role will involve designing, implementing, and maintaining ETL processes using SQL Server Integration Services (SSIS) for efficient data extraction, transformation, and loading. You will be responsible for developing data transformation and integration solutions, ensuring data consistency and accuracy across systems. Performing data cleansing, validation, and enrichment to ensure high-quality data for reporting and analysis will also be part of your responsibilities. Analyzing large datasets to uncover trends, patterns, and insights, as well as performing data mining to support decision-making processes, will be crucial. You will create and maintain visualizations to present data insights effectively to stakeholders. Developing and maintaining database objects including tables, stored procedures, triggers, and user functions within a SQL Server environment is another key aspect of your role. Your expertise in implementing end-to-end BI solutions using the MSBI stack, including SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services), will be utilized. Additionally, you will design and manage data warehouse solutions, optimize T-SQL query performance, and create and manage reusable SSIS components for streamlined ETL processes. Contributing to physical and logical database design, data mapping, and table normalization will also be part of your responsibilities. Your role will require you to identify dimensions, facts, measures, and hierarchies for data migration to SQL Server databases. Utilizing DMVs, SQL Profiler, and Extended Events for database performance optimization, debugging, and tuning will be essential. Working with Microsoft Azure cloud services including Azure Blob Storage, Azure SQL Server, and Azure Data Factory is also a part of this role. You will use GIT (Azure DevOps) for version control and collaboration, and participate in Agile/SCRUM methodologies for project management and development. Minimum qualifications include a minimum of 5 years of experience in ETL development and data warehousing, advanced proficiency in T-SQL, SSIS, and SQL Server database management, experience with MSBI stack including SSRS and SSAS, knowledge of data warehousing methodologies and concepts, skills in optimizing T-SQL queries and database performance, experience with Microsoft Azure cloud services, familiarity with Agile/SCRUM project management methodologies, and proficiency in GIT version control and Azure DevOps. Preferred qualifications include a Bachelor's degree in Computer Science, Information Systems, or a related field, certifications in Microsoft SQL Server or Azure Data Technologies, and experience with additional BI tools and data visualization platforms.,

Project Role : Software Development Lead Project Role Description : Develop and configure software systems either end-to-end or for a specific stage of product lifecycle. Apply knowledge of technologies, applications, methodologies, processes and tools to support a client, project or entity. Must have skills : Microsoft SQL Server, Microsoft SQL Server Administration, Microsoft SQL Server Reporting Services Good to have skills : NAMinimum 7.5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Lead, you will be responsible for developing and configuring software systems, applying knowledge of technologies, methodologies, and tools to support clients or projects, either end-to-end or for a specific stage of the product lifecycle. Roles & Responsibilities: Roles & Responsibilities:At least 10+ years of relevant experience in Data Analytics (preferably Microsoft BI stack) fieldLeading a multidisciplinary team of at least 10 professionals, including developers, business analysts, and technical specialists. Overseeing and managing the full lifecycle of projects and software development initiatives Ensuring alignment with organizational policies, regulatory standards, and security best practices. Coordinating cross-functional collaboration with other IT and business units. Driving the continuous improvement of tools, processes, and governance. Developing project roadmaps, assign tasks, and manage timelines. Managing stakeholder communication and ensure delivery of the solutions as per business need. Identifying risks and implement mitigation strategies to ensure data protection and system integrity.KNOWLEDGE AND S Qualifications/Education Required:Degree holder in Computer Science or related discipline Experience Required:This position requires 12 + years of relevant experiences in the IT industry with at least 3 years in Data analytics solution architect or Technical Leader role. Proven record of projects and people management, supporting the development/support of enterprise-wide solutions within major organizations, ideally in a banking environment. Project delivery experience and Team management Competencies RequiredSoftware Development Knowledge. Firm understanding of SDLC Experience in working in Waterfall and Agile settings. Ability to work with developers and contribute to technical discussions. Project Management Skills. Proven ability to lead and manage large-scale projects, including but not limited by vulnerability remediation, obsolescence management, and new software development. Team Leadership and Development. Experience in leading, coaching, and developing a diverse team of technical and non-technical professionals. Stakeholder Management. Ability to engage with senior management, business units, and external vendors to align IAM solutions with business objectives. Risk Management. Ability to identify, assess, and mitigate risks related to identity and access management, ensuring compliance with security standards. Communication Skills. Strong verbal and written communication abilities to effectively convey technical concepts to both technical and non-technical stakeholders. Strategic Thinking. Ability to align the team initiatives with long-term business goals, anticipating future needs Strong analytical and problem solving skills Skills & Knowledge Requirements Hands-on technical expert in the development of data analytics solutions, able to propose solutions to the business with a consulting approach Excellent experience with Power BI, MSBI stack of solutions (SSIS, SSRS, SSAS and SQL Server), DWH solutions and concepts Aware of modern data analytics developments and solutioning Experience in architecture, design, creation & delivery of solutions Understanding of RESTful APIs, and microservices architecture. Understanding of large data processing and manipulations. Knowledge of DevOps practices and CI/CD pipelines. Proficiency with build automation tools and version control tools, e.g. GitLab, Azure DevOps Knowledge of unit testing frameworks and static/dynamic code analysis tools to ensure code quality and security. Additional Information:- The candidate should have a minimum of 12 years of experience in Denodo Data Virtualization Platform- This position is based at our Mumbai office- A 15 years full-time education is required Qualification 15 years full time education

About The Role Project Role : Software Development Lead Project Role Description : Develop and configure software systems either end-to-end or for a specific stage of product lifecycle. Apply knowledge of technologies, applications, methodologies, processes and tools to support a client, project or entity. Must have skills : Microsoft SQL Server, Microsoft SQL Server Administration, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services Good to have skills : NAMinimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Lead, you will be responsible for developing and configuring software systems, applying knowledge of technologies, methodologies, and tools to support projects or clients in Mumbai. Roles & Responsibilities:- Expected to be an SME- Collaborate and manage the team to perform- Responsible for team decisions- Engage with multiple teams and contribute on key decisions- Software Development Knowledge. Firm understanding of SDLC Experience in working in Waterfall and Agile settings- Risk Management. Ability to identify, assess, and mitigate risks related to identity and access management, ensuring compliance with security standards- Excellent experience with Power BI, MSBI stack of solutions (SSIS, SSRS, SSAS and SQL Server), DWH solutions and concepts- Provide solutions to problems for their immediate team and across multiple teams- Lead and mentor junior professionals- Drive innovation and continuous improvement in software development processes Professional & Technical Skills: - Must To Have Skills: Proficiency in Microsoft SQL Server, Microsoft SQL Server Administration - Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services- Experience in architecture, design, creation & delivery of solutions - Understanding of RESTful APIs, and microservices architecture. Understanding of large data processing and manipulations. Knowledge of DevOps practices and CI/CD pipelines. Proficiency with build automation tools and version control tools, e.g. GitLab, Azure DevOps- Strong understanding of database design and optimization- Experience in performance tuning and query optimization- Knowledge of ETL processes and data warehousing concepts Additional Information:- The candidate should have a minimum of 9 years of experience in Microsoft SQL Server- This position is based at our Mumbai office- A 15 years full time education is required Qualification 15 years full time education

Job Title : Business Intelligence Engineering Lead Locations open - Hyderabad, Chennai, Bangalore, Delhi/NCR Position Description : The Data Engineering team is looking for an experienced Business Intelligence Engineering Lead to join our team. The successful candidate will contribute to all aspects of Data Management, Business Intelligence, and Analytics capabilities in the organization, including leading end-to-end Power BI reporting and dashboarding initiatives. Roles and Responsibilities: Create and design policies for effective data management, reporting, and analytics for the organization. Formulate techniques for quality data collection to ensure adequacy, accuracy, and legitimacy of data. Devise and implement efficient, secure, and scalable procedures for data handling, modeling, and visualization with attention to all technical and business aspects. Establish rules and procedures for data sharing, visualization, and usage across departments and with external stakeholders. Understand the current business model of Clients insurance data and propose operational and application improvements. Analyse user needs and software requirements to determine feasibility of design within time and cost constraints. Create data models and designs to meet specific business and reporting needs using Power BI and data warehouse best practices. Design and implement Power BI dashboards and reports that deliver actionable insights and business metrics across teams. Create source-to-target mappings and ETL design for integration of new/modified data streams into the Data Warehouse. Develop SSIS packages and Power BI Dataflows to load different producer/agent files and populate the staging and target data warehouse schemas. Monitor and analyse information and data systems, evaluate reporting performance, and identify enhancements (new technologies, upgrades, automation). Ensure databases, data models, and dashboards are secured and properly governed to prevent data breaches and losses. Troubleshoot data-related issues and report performance metrics; authorize system maintenance and enhancements. Skills Required: Strong experience with Power BI Desktop, Power BI Service, Power Query, DAX, and Dataflows. Ability to develop and optimize interactive dashboards, KPIs, paginated reports, and automated refreshes. Solid understanding of data storytelling and visualization best practices. Excellent SQL and T-SQL/PL-SQL skills; strong background in data modelling, warehousing (star/snowflake), and ETL pipelines. Experience with Microsoft BI Stack: SSIS, SSRS, SSAS, and Power Pivot. Experience in navigating large, complex, matrixed organizations. Knowledge of working with Big Data technologies and Azure data services is a plus. High-level analytical and critical thinking skills. Strong communication skills and ability to work collaboratively with cross-functional teams. Experience Required: BSc/BA in Computer Science, Engineering, or related field. 14-16 years of experience in Data Engineering and Business Intelligence. Minimum 5-6 years of experience with Microsoft BI Stack SSIS, SSRS, SSAS. At least 3-4 years hands-on experience with Power BI and DAX. Strong track record of delivering high-performance reports and data solutions. Experience in data governance, quality, and security standards. Share resume on standon@vbeyondapac.com

Role & responsibilities MSBI Development Data Warehouse Concepts MSBI (SSIS/SSAS(Tabular)/SSRS) Power BI Microsoft SQL Server, T-SQL Power BI Development: Design and develop visually compelling, interactive reports and dashboards using Power BI. Build data models, implement DAX calculations, and optimize performance for large datasets. Create reusable templates, themes, and standardized visuals. Data Integration & Governance: Connect Power BI to various data sources (SQL Server, Excel, SharePoint, Fabric, Dataverse, SAP, APIs, etc.). Implement row-level security (RLS) and dataset certifications to ensure secure and trusted analytics. Ensure data quality, integrity, and documentation across the BI solution lifecycle. Collaboration & Communication: Gather requirements from stakeholders and translate them into scalable BI solutions. Work closely with cross-functional teams including Data Engineers, Analysts, and Business Users. Present analytical insights to non-technical users in a meaningful way.