Description

Responsibilities

 

  • 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

Education

Any Graduate