Business Intelligence Engineer

  • Bengaluru
  • Smc Squared

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