Technical Lead- MSBI Development

Job Description

We are looking for Microsoft Business Intelligence IT Professional having an experience more than 8 years and expertise in areas such as SSIS, SSRS & SSAS and SQL Server 2005/2012/2014/2017/2019/2022. The resource will play a key role as a Technical Architect in Access Management platform handling the complete back end of IIQ repository. The candidate should have a solid working knowledge of various IT systems/technologies and enjoy working collaboratively across teams. This position requires constant interaction with technology operations and security compliance teams to understand management processes, which must be re-engineered to work with SAILPOINT processes Responsibilities Direct Responsibilities Should be responsible of creating ETL packages for loading data from HR database. Should be responsible in maintaining / supporting / developing SSIS, SSRS & SSAS and SQL packages for the IIQ repository. Provide technical leadership and Propose improvements related to the development activity (job performance) Problem resolution: Incidents analysis, steering of corrective action Strong hands-on experience on Web and Application servers Needs to have experience in Performance engineering and improving SailPoint application performance Accountable for generation, reporting and improvements of various Production KPIs, SLs and dashboards for APS teams. Accountable for improvements in service and presentations for all governances and steering committees Accountable for maintenance and improvement of IT continuity plans (ICP) Contributing Responsibilities Technical & Behavioral Competencies Have minimum of 8 years of strong experience in Microsoft Technology (Microsoft Business Intelligence) MSBI like SSIS, SSRS & SSAS and SQL Server 2005/2012/2014/2017/2019/2022 In-depth Technical Knowledge on Microsoft Business Intelligence (MSBI) Tools like SQL Server 2005/2008/2012 Integration Services and Reporting Services Should have Knowledge on creating Package Configuration, Logging, and Error Handling for the SSIS Packages. Having knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and Data Marts. Experience in Deployment of ETL Packages in different environments and worked for preparing the deployment documentation for the DBA team. Experience in creating relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and (Multidimensional) MDX queries. Experience in extracting the data using SSIS from OLTP to OLAP. Experience in Dimensional Data Modeling Star and Snow Flake Schemas. Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and restore Database backup. Experience in creating like Drill-Down, Drill-Through, Sub Reports, Parameterized reports and subscriptions in SSRS. Configuring the Report security in the Report configuration manager Should have at least 3 years of excellent hands on experience on SailPoint, in design and developing functionalities like Lifecycle Management, Multiplexed and Direct Reconciliation, Workflow Management & Compliance Management Knowledge on Power BI, SAP BO Reporting & Tableau will be an added advantagePreferred to have Specific Qualifications (if required) Graduate in any discipline or bachelors in information technology Skills Referential Behavioural Skills : (Please select up to 4 skills) Ability to collaborate / Teamwork Creativity & Innovation / Problem solving Ability to deliver / Results driven Communication skills - oral & written Transversal Skills: (Please select up to 5 skills) Ability to manage a project Ability to set up relevant performance indicators Ability to anticipate business / strategic evolution Ability to develop and adapt a process Analytical Ability Education Level: Bachelor Degree or equivalent Experience Level At least 5 years