Responsibilities :
- Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.
- Connecting data sources, importing data, and transforming data.
- Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.
- Should have an edge over making DAX queries in Power BI desktop.
- Knowledge in Microsoft BI Stack and hands on experience over data analytics.
- Should have strong knowledge of SQL, Query optimization and database internals.
- Understanding of ETL / ELT and data transformation using python or any other language.
- Analyze, design, and build dimensional and relational data models and logical data specifications.
- Very good communication skills must be able to discuss the requirements effectively with the client teams, and with internal teams.
- Merge data from 2 different systems (e.g. ERP and CRM), in different formats
- Create dynamic reports that start with a summary view and then provide drill-down into the details
Skills Required
Power Bi, Dax, Sql, Data Modeling, Etl