Power BI Developer & Analytics Engineer

​​​​​​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

Interview requirement:

• Must provide a portfolio of dashboard work and be willing to complete a dashboard development Proof of Concept

Experience:

• Strong SQL Server Database knowledge and experience writing and debugging queries.
• Design of complex Stored Procedures, User Defined Function based on dashboard requirements.
• 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)
• Microsoft's Power BI and Power Pivot
• DAX query language
• Strong professional experience in using Power BI to build business intelligence dashboards and interfaces for client use and internal use
• Creative and aesthetic in interface design and visualization with demonstrated familiarity with best practices in design principles
• Data-driven and detail-oriented in understanding underlying data structures.
• Advanced data modeling skills
• Database management experience
• Critical thinking to solve complex user feedback requests
• Ability to communicate technical concepts to internal and external stakeholders
• Investment management industry experience a plus