KR OTIS IT Solutions Pvt. Ltd.

Job Description: Position: BI Developer Experience 8+ years Work Location: Hyderabad & Chennai Work Mode: Hybrid Shift timings: 2:00 PM to 11:00 PM NP: Immediate to 15 Days Mandatory Skills: DWH,ETL, SQL, SSIS, Power BI, Snowflake BI developer will be working on designing various analytical reports and delivering them to different business units in the bank including executive management. Work closely with business to understand their day-to-day operations and gather requirements. Need to comply with common practices, best standards, and policies of the bank. · Partner with business teams to gather, document and maintain business requirements documents, create process flow diagrams, UI mockups for development teams using tools like Visio, MS Word, MS Excel, Adobe PDF and other similar tools. · Schedule meetings with IT SMEs to articulate solutions while ensuring the business requirements are met. · Develop logic by writing T-SQL queries to create data sets on adhoc basis based on requirements from business. · Create reports and dashboards using reporting tools like Power BI/SSRS as per business requirements. · Prepare Test plans and test cases for functional scenarios and perform testing effectively. · Responsible for peer code review and provide improvements (if necessary). · Responsible for creating a continuous improvement process, investigating problems, generating recommendations, and implementing solutions based on the use of reporting tools like Power BI and SSRS. · Identify and implement process improvements making the organization more effective and efficient. · Perform other duties as assigned including mentoring low-level peers. · Ensure data security is enforced concerning all confidential information including but not limited to internal use and restricted information. · Minimum Education Level: Bachelor’s Degree · Language requirements: English Written, Advanced Verbal · Computer/software skills: Microsoft Office 365 (Outlook, Word, Excel, Visio, Power point), · Required: ü Writing Business Requirement Documents, functional specification documents and use cases. ü Expertise in writing T-SQL queries, stores procedures. Understand data optimization, query profiling and performance improvement. ü Proficient experience in data visualization tools like Power BI, Tableau etc ü Understanding of database management systems like Microsoft SQL Server, Oracle etc, online analytical processing (OLAP) and ETL (Extract, Transform and Load) framework. ü Experience in effectively translating concepts into non-technical terms to business owners in a clear and concise manner. ü Experience in managing project timelines and ability to effectively self-prioritize and execute tasks in a high-pressure, fast-paced environment. ü Strong interpersonal, presentation and relationship building skills. ü Exhibit strong desire to learn, adapt to new technologies and grow. · Preferred: ü Banking industry experience in Commercial and Consumer Loans