Technical/Functional Skills
Digital : Microsoft Power BI, SQL Server 2012 Development
Experience Required
6 Years
Roles & Responsibilities
Power BI Developer
- 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 Views On Application Data into a Single Dashboard. - Interact With Business Users To Get The Business Requirement And KPI 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 Com plex 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 Bi Reports. - Work on Dynamic User Level Security To Provide To Users Based On their 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 Much 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.