Senior Power BI Developer & Analytics Engineer at DiligenceVault – Bird In Hand, Pennsylvania

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