ESSENTIAL RESPONSIBILITIES
• The candidate will work closely with members of the Enterprise Data Management team as well as business partners to understand broad business information requirements and develop BI solutions, including:
oData visualizations
o Tabular models within Power BI Service and Desktop
o Complex DAX expressions for aggregating data visualizations
o Understand best practices to design, develop, and support Power BI visualizations
o Optimize Power BI dashboards and tabular models with a focus on usability and performance
o Use models to the Power BI Premium service Publish reports and dashboards using Power BI Service for sharing and collaboration
o Schedule dashboard refreshes and set up proactive notifications
o Implementing Row Level Security (RLS)
• Develop tabular models that support one-to-many Power BI dashboards • Manage Power BI workspaces
• Leverage Microsoft Azure tools to develop and deploy BI solutions (Strong Azure DevOps experience)
• Strong requirements analysis experience
REQUIRED SKILLS/EXPERIENCE
• 5+ years experience in developing Power BI dashboards, and converting data (raw and transformed) into meaningful insights
• Best Practices - Choice of data import vs. direct connectivity, Reuse of existing datasets, File Size Management and others.
• Experience with varied database sources such as SQL Server, SharePoint list, Azure analysis services.
• Experienced Tabular Developer with 1+ years focused Tabular development
• Experience writing DAX expressions
• Experience in Tabular performance monitoring and query optimization using MS and 3rd party tools. DAX studio or Tabular Editor, and ALM Toolkit experience is a plus
• Row-Level Security, Restricting Sharing and Publishing, Restricting Export and Printing
• Experience integrating Power BI reports into 3rd Party Applications
• Collaborate with and help to mentor less experienced Power BI Developers
• Strong SQL and Data models knowledge (Relational, Star schema), ability to connect to database and trace data lineage
• Ability to articulate technical issues outside team to get quicker resolution
• Bachelor’s degree in Computer Science or related degree