Participate in discussions with business partners to define key business questions, translate them into necessary requirements documentation and develop visual data-driven solutions.
Develop reports, thoughtful visualizations, dashboards and KPI scorecards using Microsoft's Power BI and Azure stack employing leading visualization techniques.
Perform UX design activities and Power BI navigation features (e.g., bookmarks, drill-throughs) to guide end-users through a data-driven story.
Able to develop calculations in SQL, DAX and Power BI measures which are accurate and performant on large datasets.
Able to use M language to build loops, pull APIs, etc.
Able to assist with governance and deployment of Power BI, including administration, content distribution/sharing, training and support.
Able to lead Power BI design methodology and best practices.
Able to extract data from various data sources; perform exploratory data analysis, cleanse, reshape, and aggregate data.
Proactively monitor and evaluate the impact of monthly Power BI releases.
Able to conduct deep-dive data analysis for business insights and recommendations, including ad hoc analytics for executive-level requests and priorities.
Requirements:
Overall 10+ years of experience is required.
Minimum 8+ years of experience with Power BI development, visualizations and deployment is required.
8+ years of experience with MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX
5 + Years of experience in documenting business requirements, processes, and workflows
Good experience with configuration / management of Microsoft Power BI Service
Good Experience in extracting, manipulating, and analyzing data via Dataflows, DataMart, Dashboards and Apps to recommend and/or take action.
Strong experience in working with relational databases: SQL Server
Proficient Data Architecture and Modeling experience (Structuring Tables, Attributes, and Relationships [One-to-One, One-to-Many, Many-to-One, Many-to-Many])
Experience in Capital Markets is must
Good to have:
Microsoft Power BI Certification is a plus.
AWS Cloud and/or Snowflake experience is a plus.
Advanced level of MS Excel skills with knowledge of functions, macros, and VBA programming