Power Bi Developer

EXP 3-5 YEARS LOC Bangalore Pune Role Power Bi Developer-A3 Job Purpose Design and develop business intelligence solutions using Microsoft PowerBI including creating interactive reports and data visualizations to facilitate informed decision-making Transform raw data into meaningful insights and present them in a user-friendly manner collaborating with business analysts data engineers and stakeholders to deliver impactful data visualization solutions Involve in data modelling ETL processes and ensuring the security and integrity of data within the PowerBI environment Responsible for migrating raw data into meaningful dashboards that provide insights and support decision-making within the team Provide management and oversight of the platform as a Business Intelligence Data Analyst ensuring data availability and expected data quality for key security and risk processes Support the initial design review and enhancement of processes in the data management tool and contribute to regular data quality reports production including quantitative and qualitative analysis SQL developer will be involved in designing developing and maintain databases as well as write and optimize SQL queries SQL developers will also be responsible for ensuring that databases operate efficiently and securely and work closely with data analysts project managers and on-shore partners to achieve this Resource to work in Agile methodology and collaborate with business analysts data engineers stakeholders to understand requirements and deliver impactful data visualization solutions Additionally they will be involved in data modeling ETL processes and ensuring the security and integrity of data within the BI environment Primary job duties and responsibilities may include but are not limited to the following Power BI development and administration Building Analysis Services reporting models Developing visual reports dashboards and KPI scorecards using Power BI desktop Connecting to data sources importing data and transforming data for Business Intelligence Excellent in analytical thinking for translating data into informative visuals and reports Able to implement row level security on data and understand application security layer models in Power BI Proficient in making DAX queries in Power BI desktop Expertise in using advance level calculations on the data set Responsible for design methodology and project documentation Able to develop tabular and multidimensional models that are compatible with warehouse standards Adept in developing publishing and scheduling Power BI reports as per the business requirements Able to properly understand the business requirements and develop data models accordingly by taking care of the resources Should have knowledge and experience in prototyping designing and requirement analysis Should have knowledge and skills for secondary tools such as Microsoft Azure SQL data warehouse PolyBase Visual Studio etc Able to integrate Power BI reports into other applications using embedded analytics like Power BI service SaaS or by API automation Also one must be experienced in developing custom visuals for Power BI Excellent knowledge of database concepts designing databases and ensuring their stability reliability and performance develop database schemas tables and dictionaries Ensure the data quality and integrity in databases Data types in SQL Basic functions and SQL Commands Data definition language Data manipulation language Transaction control language Data control language Data query language Database concepts - data procedures RDBMS DBMS Architecture - single tier two tier and three tier architecture Design and create database tables Database administration - user management import export data SQL Functions and clauses - Aggregate function string function Joints - Inner join left join right join full join Knowledge on database backup management Test database and perform bug fixes