Offer summary

Qualifications:

Minimum 5 years of experience with MS-SQL Server and Power BI., Strong SQL Server database knowledge and experience in writing complex stored procedures., Proficiency in DAX query language and advanced data modeling skills., Experience in the investment management or fintech industry is a plus..

Key responsibilities:

Perform end-to-end implementation of Power BI projects, including developing scorecards, KPIs, reports, and dashboards.

Build and maintain dashboards for clients and internal use, addressing various market needs.

Identify and troubleshoot UX/UI problems to enhance user experience with dashboards.

Conduct ad-hoc data analysis projects and manage data security through routine QA testing.

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