Offer summary

Qualifications:

Minimum 5 years of experience in MS-SQL Server and Power BI, Strong SQL Server database knowledge, Experience in Azure cloud environment is a plus, Advanced data modeling skills.

Key responsabilities:

Develop and implement Power BI projects

Design and maintain client and internal dashboards

Job description

At DiligenceVault, we’re the leading technology platform and industry network to streamline and digitize the manually intensive diligence process. We have experienced a wonderful period of growth as the direct result of increased efficiency and productivity for our network of over 50,000 platform users at over 13,000 firms in over 100 countries. To continue on this trajectory, we are looking for exceptional talent from across disciplines and industries to shape the future of due diligence and improve the lives of our clients and users in a meaningful way.

About the role:

We are seeking a highly skilled Power BI and Database Specialist with extensive experience in SQL, Power BI, and business intelligence solution development. The ideal candidate will have a proven track record of creating impactful, insightful, and visually compelling dashboards that drive strategic decision-making.

Interview requirement:

Must provide a portfolio of dashboard work and be willing to complete a dashboard development Proof of Concept as part of interview process

Key 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

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.
Experience of Azure cloud environment (ADF, ADLS, Analysis Services, and Azure SQL) is a Plus
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
Investment management/ Fintech industry experience a plus