Senior Power BI Developer and Database Engineer

Summary

Join DiligenceVault, a leading technology platform, as a highly skilled Power BI and Database Specialist. You will leverage your expertise in SQL, Power BI, and business intelligence to create impactful dashboards driving strategic decision-making. This role demands end-to-end Power BI project implementation, building and maintaining dashboards for clients and internal use. You will troubleshoot UX/UI issues, translate business processes into data visualizations, and work with embedded applications and APIs. A minimum of 5 years of experience with MS-SQL Server and Power BI is required, along with strong SQL Server Database knowledge. The ideal candidate will possess advanced data modeling skills and excellent communication abilities.

Requirements

• Minimum 5 years of Experience working with MS-SQL Server and PowerBI
• Definitely Required - Strong SQL Server Database knowledge and experience writing and debugging queries, and Writing complex Stored Procedures
• Database management
• Knowledge and experience related to database performance issues and ability to provide solutions
• Microsoft's Power BI and Power Pivot
• DAX query language
• Power BI to build business intelligence dashboards and interfaces for client use and internal use
• Advanced Data Modeling skills
• Critical thinking to solve complex user feedback requests
• Ability to communicate technical concepts to internal and external stakeholders

Responsibilities

• Visually display insights in a clear, concise, and actionable manner with representations for decision-making and a very high attention to detail
• Perform end-to-end implementation of Power BI projects for developing a portfolio of scorecards, KPIs, reports & dashboards
• Build, design, and maintain dashboards for our clients that address market needs and a wide range of use cases, including custom dashboards
• Build, design, and maintain internal BI dashboards that provide key insights and monitoring for different parts of the business and ultimately help drive efficiency and business planning
• Identify and troubleshoot UX/UI problems (e.g., responsiveness, performance, design, flows); conduct design adjustments to improve user experience and outcomes while using the dashboards
• Fast learner. Understand our users' business processes and translate them into data visualizations that can improve both operational and executive decision-making
• Work with embedded applications (PowerBI embedded for web applications)
• Implement Power BI REST APIs, Power BI Client Library APIs and object models for Client APIs including TypeScript or JavaScript and JSON schemas, and Power BI Report Authoring library extension
• Design of complex Stored Procedures, User Defined Function based on dashboard requirements
• Ad-hoc data analysis projects and/or SQL queries (extracting data from our tech stack exports and analyzing for insights)
• Manage data security by routine QA testing and troubleshooting

Preferred Qualifications

• Experience of Azure cloud environment (ADF, ADLS, Analysis Services, and Azure SQL) is a Plus
• Investment management/ Fintech industry experience a plus