Power BI Developer
Diverse Lynx, Sunnyvale, CA, United States
- 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 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 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
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.