Logo
KGS Technology Group, Inc

SQL Power BI specialist

KGS Technology Group, Inc, Houston, Texas, United States, 77246

Save Job

The job of a SQL Power BI specialist is designing, building, and deploying reports and dashboards using Microsoft Power BI. Here are the job description and key responsibilities: Develop operational reports Build automated reports and dashboards with the help of Power BI and other reporting tools Understand business requirements to set functional specifications for reporting applications Be experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX Be able to quickly shape data into reporting and analytics solutions Create functional reporting Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more Responsibilities

The following are the various roles and responsibilities: To understand business requirements in the BI context and design data models to convert raw data to meaningful insights. To create dashboards and visual interactive reports using Power BI. To identify KPIs with clear objectives and monitor them consistently. To analyze data and present it through reports that can help in decision-making. To be able to convert business requirements into technical specifications and decide the timeline to accomplish tasks. To design, develop, and deploy Power BI scripts and perform efficient detailed analysis. To perform DAX queries and functions in Power BI. To create charts and document data with algorithms, parameters, models, and relations explanations. To conduct data warehouse development. To perform SQL querying for best results. To use filters and graphs for a better understanding of the data. To define and design new systems by analyzing current ETL processes. To make technical changes to existing BI systems in order to enhance their Performance. Reference no : KGS2023191218 Location : United States| Texas| Houston Type : Remote Salary : $80000 Salary Type: Annually Skills: SQL SSRS SSIS SSAS Power BI Data Analysis Data Migration ETL Python #J-18808-Ljbffr