Job description

Position: Power BI Developer with SQL expertise Must Have Technical/Functional Skills: Digital: Microsoft Power BI; SQL Server 2012 Development; SSIS; SSRS; SSASRoles & Responsibilities Design, Develop, Debug and Support Complex Data Integration Interfaces and Processes Using Various Tools and Technologies Including SSIS,SSRS, SSAS, T-SQL And SQL Server Technologies. Design Database Objects as Necessary to Meet Ongoing Business Needs for Reporting. Assist With Design, Testing, Support and Debugging of New and Existing ETL And Reporting Processes. Assist With Impact Analysis of Changing the Process to Data Warehouse and Reporting Systems. Clean And Blend Multiple Data Sources to Allow On Different Viewson Application Data into a Single Dashboard. Interact With Business Users To Get The Business Requirement andKPI Information. Work Extensively On Power Bi Dashboards To Create Various Analytical Dashboards That Depicts Critical KPI Along With Slicers And Dicers Enabling End User To Make Filters. Create Complex Calculations, Measures, Conditional Columns,Summarized Tables, Functions, Parameters Usingdax In The Reports. Analyze The Data In The Finance Reports And Provide Statistical Analysis Such As Standard Deviation, Mean, Median And Trend In Power BiReports. Work on Dynamic User Level Security To Provide To Users Based Ontheir Roles, implement Dynamic Row Level Security With Organizational Hierarchy In The Report. Create Different Visualizations Like Bar, Line, Matrix, Pie Charts, Waterfall, Gauge Chart and Custom Visuals. Migrate Tableau Dashboards To Power BI. Create Forecast, Trend Line And Reference Line In The Report. Work On Complex SQL Queries Which Is Used For Data Transformation. Create And Modify Tables, Stored Procedures, Views, Indexes, User Defined Functions And Triggers As Per the requirement. Investigate The Issues, Defects, Determine Problem Root Cause,Formulating Corrective Action Recommendation And Implement Them. Suggest Best Visualization In Power Bi For The Kpi Which Fulfills User Requirements To Understand The Datain M uch Better Manner To Make Decisions. Build Usage Matrix Reports In Power Bi For Audit Log Purpose. Publish The Power Bi Reports On Power Bi Service. Schedule Reports Based On The Requirement, Manage Roles On Power Bi Service. Create Deployment pipelines, Assign the workspace to each environment, configure deployment rules. - Develop powershell scripting to automate the manual processes. Salary Range: $67,100-$140,000 a year#

Requirements