Power BI Developer - SQL/ETL (5-10 yrs)

Job Description :

We are seeking a Power BI Developer to build and maintain BI and analytics solutions with insightful dashboards that transform data into knowledge. Experience with data and business analysis will be considered. It would be best if you are an analytical person and a good communicator. A Power BI developer's primary responsibility will be to transform raw data into relevant insights via interactive and simple-to-understand dashboards and presentable reports keeping everything in mind.

Roles and Responsibilities :

- Recognize business requirements in the context of BI and create data models to transform raw data into relevant insights

- Working closely with business team for articulating the requirements

- Taking ownership of the delivery and mentoring junior resources in the team

- Using Power BI to create dashboards and interactive visual reports

- Define key performance indicators (KPIs) with specific objectives and track them regularly

- Analyze data and display it in reports to aid decision-making

- Convert business needs into technical specifications and establish a timetable for job completion

- Create, test, and deploy Power BI scripts, as well as execute efficient deep analysis Use Power BI to run DAX queries and functions

- Create charts and data documentation with explanations of algorithms, parameters, models, and relationships

- Construct a data warehouse

- Expertise into SQL queries - use of joins, sub queries

- Make technological adjustments to current BI systems to improve their performance For a better

understanding of the data, use filters and visualizations

- Analyze current ETL procedures to define and create new system

Required Skills

- 4+ years of relevant experience in Power BI.

- Good to have experience in Azure services.

- Hands on experience on DAX functions- Date and Time, Time Intelligence, Logical, Mathematical and

Trigonometric, Statistical, Text, Parent-Child Functions

- Proficiency in writing SQL queries and use of Relational Keys, Select Queries, Joins, Data Modelling, Fact and Dimension Table Types, Different Schemas, DDL, DML

- Understanding of Data warehousing DWH concepts.

- Capable of enabling row-level data security

- Knowledge of Power BI application security layer models

- Prior experience in data-related tasks

- Understanding of the Microsoft BI Stack

- Be familiar with MS SQL Server BI Stack tools and technologies, such as SSRS and TSQL, Power Query, MDX, Power BI, Data Modelling

- Analytical thinking for converting data into relevant reports and graphics

- Ability to run DAX queries on Power BI desktop

- Proficient in doing advanced-level computations on the data set

- Excellent communication skills are required to communicate needs with client and internal teams successfully