Microsoft Business Intelligence

Roles & Responsibilities

• Understand business requirements in the BI context and design data models to transform raw data into meaningful insights

• Create dashboards and interactive visual reports using Power BI

• Identify key performance indicators (KPIs) with clear objectives and consistently monitor those

• Analyzing data and presenting data through reports that aid decision-making

• Convert business requirements into technical specifications and decide timeline to accomplish

• Create relationships between data and develop tabular and other multidimensional data models

• Chart creation and data documentation explaining algorithms, parameters, models, and relations

• Design, develop, test, and deploy Power BI scripts and perform detailed analytics

• Perform DAX queries and functions in Power BI

• Analyze current ETL process, define and design new systems

• Data warehouse development and work with SSAS, SSIS, and SSRS

• Redefine and make technical/strategic changes to enhance existing Business Intelligence systems

• Create customised charts and custom calculations as per requirements

• Design, develop and deploy business intelligence solutions as per needs

• SQL querying for best results, use of filters and graphs for better understanding of data

• Work with users and team members at all levels for performance improvement and suggestions

Technical Skills (Must Have)

• Experience working with BI tools and BI systems like Power BI, Tableau, SAP, and so on

• Experience in creating data-rich dashboards, writing DAX expressions, and implementing row-level security in Power BI

• Develop custom BI products that require knowledge of scripting languages and programming languages like R and Python

• Sound knowledge of database management, SQL querying, data modelling, data warehousing, business intelligence, and OLAP(Online Analytical Processing)

• An added advantage is in-depth knowledge and experience with Microsoft Business Intelligence stacks such as Power Pivot, SSRS, SSIS, and SSAS.

• Should be good at Data Analytics

• Must know how to develop a custom BI solution.

• Essential to have an understanding of technical aspects as well as software development architecture to transform requirements into technical presence.

• Comprehensive knowledge of data design, data modelling, data management, and data visualization

Technical Skills (Desirable)

• Power Apps & Power Automate

• Power Virtual Agents

• SharePoint

• Functional Skills

• Strong communication and client management skills

• Ability to multitask and excellent interpersonal skills.

• Document processes, models, designs, and solutions and able to explain, represent, and discuss with the team.

• Apply learned lessons to future solution considerations.

• Ability to work in an agile environment with a focus on continuous improvement.

• Proven abilities to take initiative and be innovative.

• Analytical mind with a problem-solving aptitude

Minimum Qualifications:

• Minimum of 3 years’ experience in same role

• Bachelors / Masters -B.Tech / M.Tech / B.C.A / M.C.A

Other information:

• Salary: Above market - can be negotiated

• Work Arrangement: Hybrid (3 days on-site, 2 days WFH - can be negotiated depending on candidates’ location

• Dayshift