Job Purpose
- Assist in building out the backlog of Power BI dashboards, ensuring they meet business requirements and provide actionable insights.
- Collect and maintain a firmwide inventory of existing reports, identifying those that need to be converted to Power BI.
- Collaborate with the team to contract and integrate Snowflake, ensuring seamless data flow and accessibility for reporting and analytics.
Desired Skills and experience
Candidates should have a B.E./B.Tech/MCA/MBA in Information Systems, Computer Science or a related field
3+ year’s strong experience in developing and managing Power BI dashboards and reports, preferably within the financial services industry.
Experience required in Data Warehousing, SQL, and hands-on expertise in ETL/ELT processes.
Familiarity with Snowflake data warehousing solutions and integration.
Proficiency in data integration from various sources including APIs and databases.
Proficient in SQL for querying and manipulating data.
Strong understanding of data warehousing concepts and practices.
Experience with deploying and managing dashboards on a Power BI server to service a large number of users.
Familiarity with other BI tools and platforms.
Experience with financial datasets and understanding Private equity metrics.
Knowledge of cloud platforms, particularly Azure, Snowflake, and Databricks.
Excellent problem-solving skills and attention to detail.
Strong communication skills, both written and oral, with a business and technical aptitude
Must possess good verbal and written communication and interpersonal skills
Key Responsibilities
Create and maintain interactive and visually appealing Power BI dashboards to visualize data insights.
Assist in building out the backlog of Power BI dashboards, ensuring they meet business requirements and provide actionable insights.
Integrate data from various sources including APIs, databases, and cloud storage solutions such as Azure, Snowflake, and Databricks.
Collect and maintain a firmwide inventory of existing reports, identifying those that need to be converted to Power BI.
Collaborate with the team to contract and integrate Snowflake, ensuring seamless data flow and accessibility for reporting and analytics.
Continuously refine and improve the user interface of dashboards based on ongoing input and feedback.
Monitor and optimize the performance of dashboards to handle large volumes of data efficiently.
Work closely with stakeholders to understand their reporting needs and translate them into effective Power BI solutions.
Ensure the accuracy and reliability of data within Power BI dashboards and reports.
Deploy dashboards onto a Power BI server to be serviced to a large number of users, ensuring high availability and performance.
Ensure that dashboards provide self-service capabilities and are interactive for end-users.
Create detailed documentation of BI processes and provide training to internal teams and clients on Power BI usage
Stay updated with the latest Power BI and Snowflake features and best practices to continuously improve reporting capabilities.
Behavioral Competencies
Effectively communicate with business and technology partners, peers and stakeholders
Ability to deliver results under demanding timelines to real-world business problems
Ability to work independently and multi-task effectively
Identify and communicate areas for improvement
Demonstrate high attention to detail, should work in a dynamic environment whilst maintaining high quality standards, a natural aptitude to develop good internal working relationships and a flexible work ethic
Responsible for Quality Checks and adhering to the agreed Service Level Agreement (SLA) / Turn Around Time (TAT)
