Power BI Developer, Database Engineer

Summary

Join our team as a Business Intelligence Developer! You will leverage your expertise in SQL and Power BI to design, build, and maintain dashboards for both internal and client use. Responsibilities include end-to-end implementation of Power BI projects, troubleshooting UX/UI issues, and working with embedded applications and APIs. You will need 5+ years of SQL experience and 3+ years of Power BI experience. A portfolio of dashboard work and a proof-of-concept dashboard are required for the interview. Experience with Azure cloud environment and advanced data modeling skills are essential. Investment management industry experience is a plus.

Requirements

• Minimum 5+ years of experience with SQL
• Minimum 3+ years of experience with Power BI
• Provide a portfolio of dashboard work
• Be willing to complete a dashboard development Proof of Concept
• Strong SQL Server Database knowledge and experience writing and debugging queries
• Experience writing complex Stored Procedures
• 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)
• Experience with Microsoft's Power BI and Power Pivot
• Experience with DAX query language
• Experience using Power BI to build business intelligence dashboards and interfaces for client use and internal use
• Advanced Data Modeling skills
• Experience with Database management
• 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

Investment management industry experience