EXP:3-5 YEARSLOC: Bangalore/PuneRole: Power Bi Developer-A3Job 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